Odoo Help


How can the system administrator re-open a fiscal year?

Danny W. Adair
on 5/12/14, 12:08 AM 2,761 views

At the bottom of doc.openerp.com/book/3/3_9/periods_and_fiscal_years/ the documentation states "The system administrator can re-open a period, which have been closed by mistake.".

When a fiscal year is closed it can contain a mix of open and closed periods. Can the system administrator also re-open a fiscal year? How?

P.S.: I noticed that under "Accounting -> Periodic Processing -> End of Period -> Cancel Closing Entries" (a very promising name!) I'm not offered a closed 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 it does become available in the "Cancel Closing Entries" form. Is that how it's done - change the state internally and use Cancel Closing Entries afterwards???

Thanks for any pointers.

matt crouch
On 10/12/16, 10:46 AM

For what it is worth, I have done this on two separate occassions, and everything seemed fine. Manually changing the state of the fiscal year to draft in the database directly, then running the wizard to cancel the closing entry seemed to work. . But you _Should_ not. No one reading any of the rest of this post can  or should hold me responsible for anythign that happens if you do - generally a fiscal year should be closed only once you have submitted data to a governmental or tax authority, and Odoo has worked to make this immutable (as it should!) after the FY is closed. 

Update account_fiscalyear set state ='draft' where id = YOURFISCALYEARID ;

Find the view for account.open.closed.fiscalyear (in stock odoo 8, name may change in other versions) . Update the search domain to find the FY if necessary.

make sure you cancel the opening journal entry, which means you need the account_cancel option

Run the wizard , which should remove the opening entry, as well as the reconciliation between the closing entry and the opening entry.

And then, I think, you are good. You can re-open periods in the formerly closed fiscal year. I closed a FY prematurely once, and while I could have restored from a backup taken 5 minutes before, I wanted to see if a process could be made to work. I Absolutely understand why Odoo would not want to encourage or even publish data about this. Taxes are serious stuff.


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 5/12/14, 3:49 PM

Close a Period:

image description

(Click the Close Period button)

Re-Open a Period:

image description

(Click the Re-open Period button)

Thank you Ray. Sorry I see now that what I'm after is re-opening a closed fiscal year. Checking the periods in that year I see there's a mix of open and closed periods - opening a period still keeps the fiscal year closed. We're investigating my approach in "P.S." but it looks good so far. Would be nice to get confirmation from someone who's done this before.

Catalyst IT Ltd, Danny W. Adair
on 5/12/14, 7:30 PM

It is not possible to re-open a closed fiscal year. The process of closing a fiscal year is irreversible.

Ray Carnes
on 5/12/14, 8:38 PM

By editing your question and changing it from 'period' to 'year' you have now made my answer irrelevant. If you ask the wrong question, it is probably better to delete the question and ask a new one.

Ray Carnes
on 5/12/14, 8:41 PM

Thanks Ray, sorry I agree I should delete this question. Also I will reword, as you can see I have re-opened a fiscal year.

Catalyst IT Ltd, Danny W. Adair
on 5/12/14, 9:34 PM

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/12/14, 12:08 AM
Seen: 2761 times
Last updated: 10/12/16, 10:46 AM