SQL error during the annual accounts closing.

[GregChant]

Bug

There is no A-nouveau for the year 2022, the exercise starts in 2023. It is impossible to close the fiscal year. An SQL syntax error is blocking the operations. Attached are screenshots.

Dolibarr Version

19.01

Environment PHP

8.1.27

Environment Database

MariaDB 10.6.15

Steps to reproduce the behavior and expected behavior

• Click on the "Closing" menu in the accounting section.
• Step 1: Validate and lock the transactions for the year 2023.
• Step 2: Close the financial year.
• Activate the generation of reports in A-New and click on the yes button.
• An SQL error is generated. In my opinion, the SQL error occurs because this is the first year-end closing, as there were no transactions in 2022.

Attached files

No response

[GregChant]

Ok, I found the issue occurring because I did not fill in all the fields in the account closure configuration. It would be wise to add a condition to avoid sending an SQL query on pcg_type. I will leave the bug open until it is fixed.