Odoo Help

2 Answers
3/20/19, 6:00 AM

Thank you, I managed to open the closed fiscal year of 2017 thanks to your advice, now another message appears at the closing of the point of sale session "Field(s) `account_id` failed against a constraint: You cannot create journal items on an account of type view or consolidation." 


Yenthe Van Ginneken

--Yenthe Van Ginneken--
| 8 8 10
--Yenthe Van Ginneken--

My Odoo blog: http://www.odoo.yenthevg.com/

My Twitter: https://twitter.com/Yenthe666

Yenthe Van Ginneken
3/19/19, 12:33 PM

Hi Baldwuin,

Alright not the easiest to do but still possible. You will first need to reopen the fiscal year 2017 in order to be able to write and generate bookings for that year. You can do this by either changing the state of the column 'state' on the fiscal year model through an SQL query or by installing the OCA module that allows you to do it (https://apps.odoo.com/apps/modules/8.0/account_fiscal_year_reopen/). Be sure to take a backup first, just in case.
After you've opened the fiscal year again you should be able to close the point of sale session. After closing and booking all transactions from the point of sale you will need to close the fiscal year again. Either by SQL or by closing the fiscal year from the frontend.

P.S: You also have some other issues now:
- All the transactions that have been done and are in the POS are most likely not in your accounting now, resulting in missing numbers most likely. You might want to check that out and check with your accountant.
- You will most likely have a lot of POS records so you might run into runtime errors. In that case add more RAM to the server and change the timeouts in the Odoo configuration.
- If Odoo complains about not being able to open two fiscal years at once you'll first need to close of your current year then do all the steps and then reopen the current year. A pain, I know.

I hope this atleast helps you on the right way!


Ask a Question
Keep Informed
1 follower(s)
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