Odoo Help

Welcome!

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.

0

Journal Entry Numbering

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

Hi

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.

1

Ray Carnes

--Ray Carnes--
15677
| 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 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?

Bista Solutions US, Ray Carnes
on 8/2/13, 1:57 AM
0
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

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

1 follower(s)

Stats

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