Odoo Help


Journal Entry Numbering

Abdullah Aljelaify
on 8/1/13, 9:12 PM 2,963 views


when working on 2 fiscal years in the same time for ex 2012 and 2013 during posting the journal entry i get the number for the 2012 year like this ex. GNR/2013/0004 this will make an issue for the accountant during the work. so how to assign the number code 2012 for the year 2012 journal entries and the 2013 for the year 2013 journal entries.


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 8/2/13, 12:28 AM

The method you outline is actually the correct 'out of the box 'way to have a sequence matching the fiscal year.

A module that supports FISCAL YEAR as a prefix placeholder is at http://v6apps.openerp.com/addon/6205

will this work on V7 also?

Abdullah Aljelaify
on 8/2/13, 12:43 AM

Try it - it states "for v61 and above" and was last updated two days ago so I think there is a good chance don't you?

Ray Carnes
on 8/2/13, 1:57 AM
Abdullah Aljelaify
On 8/1/13, 11:15 PM

OK i have found a solution my self for this maybe its a temp solution

so i go to

Accounting> configuration>Journals> select the journal i want to change the numbering for and select edit

under entry sequence i choose the small box with the arrow on the side

go to fiscal year select add then select the fiscal year you want 2012 for ex and in the sequence field select create here change the prefix delete it and just add 2012

same goes for all the fiscal years

now in the journal entry section

when you make an entry in the year 2012 you get a number starting with 2012 and when you make an entry in 2013 you get a number starting with 2013

please note that when the year ends you have to add the new year numbering too 2014

so that is why i think this is a temp solution and it needs to be made automated

i think if someone could add the prefix for the Fiscal year to the sequence then this will be a good fix

i wanted to add a pic but i don't have much Karma for that

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

1 follower(s)


Asked: 8/1/13, 9:12 PM
Seen: 2963 times
Last updated: 3/16/15, 8:10 AM