Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

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

Subscribe

Get notified when there's activity on this post

This question has been flagged
closedyearfiscal
7 Replies
8811 Views
Avatar
Nicholas Tring

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.

0
Avatar
Discard
Avatar
matt crouch
Best Answer

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.



0
Avatar
Discard
Avatar
Ray Carnes
Best Answer

Close a Period:

image description

(Click the Close Period button)


Re-Open a Period:

image description

(Click the Re-open Period button)

0
Avatar
Discard
Nicholas Tring
Author

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.

Ray Carnes

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

Ray Carnes

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

http://help.openerp.com/question/6725/how-to-reopen-closed-year-for-accounting/

Nicholas Tring
Author

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.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Is this the correct way to re-open a closed fiscal year?
closed year fiscal
Avatar
Avatar
Avatar
3
Nov 16
8508
[11 CE] Can not save fiscal year entry - on runbot as well
year fiscal save
Avatar
0
Mar 19
4088
How to reopen closed year for accounting Solved
accounting closed year
Avatar
Avatar
Avatar
Avatar
4
Feb 24
15745
Move period from one year to another
period year fiscal modify
Avatar
0
Mar 15
4272
What would be the best way to display chart of accounts for multi fiscal years?
chart multiple year multi fiscal
Avatar
0
May 15
3767
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now