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).
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/13/17, 10:09 AM|
|Seen: 463 times|
|Last updated: 2/13/17, 12:36 PM|