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.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/12/14, 9:41 PM|
|Seen: 1763 times|
|Last updated: 11/5/16, 8:57 AM|