Skip to Content
Menu
This question has been flagged
3 Replies
7750 Views

I need to re-open a closed fiscal year, and I'm wondering whether how I am doing this is the correct and safe way to do it:

Under "Accounting -> Periodic Processing -> End of Period -> Cancel Closing Entries" (a very promising name!) I'm not offered a closed fiscal year. I also noticed in accounting/wizard/account_open_closed_fiscalyear.py (also a very promising name) entries are removed, but the state of the fiscal year is not changed.

If I tell Postgres to

UPDATE account_fiscalyear SET state="draft" where name="2013 (My fiscal year)" and state="done";

then that fiscal year does become available in the "Cancel Closing Entries" form. After removing the closing entries with that function the fiscal year looks like it's been correctly reverted/re-opened.

Is that how it is done correctly - change the state internally, then use Cancel Closing Entries afterwards??? Thank you for your help.

Avatar
Discard

I've always been told by Odoo that this is irreversible and to never close a year until the time passed 'statue of limitations) for restating financials or auditing has passed. I have passed this information on to all of the clients I support and have never closed a year with any of them. Restoring from a BACKUP is the safest way to unclose a year.

Best Answer

I don't know if you solved this question already. But theres a chance to revert the closing. Yes, just change the state from "done" to "draft"; more over if want to edit journal entries, then look for account_journal_period and set "draft" to the journals you want to edit. I recommend you to use pgadmin to this or any other application to manage postgres db. 

I hope this helps if you are still looking for help.

Kind regards

Avatar
Discard
Best Answer

Can confirm that this process appears to work. Use at own risk, or better, dont do it at all, though.

Avatar
Discard
Related Posts Replies Views Activity
7
Oct 16
8082
0
Mar 19
3463
4
Feb 24
14953
0
Mar 15
3649
0
May 15
3138