Odoo Help


This community 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.


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

Danny W. Adair
on 5/12/14, 12:08 AM 1,888 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
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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.

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.

Bista Solutions US, 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.

Bista Solutions US, 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.

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

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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