Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
By mistake a fiscal year has been closed.
I read here on the forum that there is a possibility to reopen it.
<UPDATE account_fiscalyear SET state="draft" where name="2014-2015 (verlengd boekjaar)" and state="done";>
apparently there is something wrong in the previous instruction because I get an error message.
Can someone check it and explain me in detail how and where to put these instructions?
Need to re-open the fiscal year because the journal items for opening the next fiscal year have not been generated.
UPDATE account_fiscalyear SET state="draft" where name="2014-2015 (verlengd boekjaar)" and state="done";
is an SQL command to manipulate the database table directly, it is not any kind of XML-view or model in Odoo. After that manipulation, you'll find the fiscal year again in the "Cancel Closing Entries" form.
Please make a backup before such manipulations ( and read Ray Carnes remark in this thread very carefully).