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

Matching the posting numbers with the journal date

By
Emad Sherbini
on 7/12/13, 12:45 PM 1,325 views

I am using openerp 7, when I post journal entries using “Periodic Processing” the post numbers are giving randomly and sometimes it start from the last journal to first for example:

01/01/2013 is giving “Bank/2013/003” 02/01/2013 is giving “Bank/2013/002” 25/01/2013 is giving “Bank/2013/001”

How can I match the posting number with the journal date as:

01/01/2013 is giving “Bank/2013/001” 02/01/2013 is giving “Bank/2013/002” 25/01/2013 is giving “Bank/2013/003”

1
Viktor Aditya
On 7/15/13, 12:31 AM

You should define the sequence of the journal. Every Journals have their own entry sequence, try to modify your sequence via "Entry sequence" in journal or via Setting >> Technical >> Sequences & Identifiers >> Sequences.

If you want your sequence as "Bank/2013/001", the setting for the prefix is "Bank/%(year)s/", number of padding is 3, next number is 1, and increment number is 1.

Dear thank you but i dont want to match the look or view of the tag, i want to match the number of the post with the journal entry. As journal entry No. 1 is in 01/01/2013 and No. 2 is in 16/01/2013 now when i post the system should go to JE No 1 and give it "Bank/2013/001" since its the first entry and then moves to No. 2 and give it "Bank/2013/002" since its last entry in the month. but what its happing with me is that the system is going to the last entry which is entry No. 2 and he give it "Bank/2013/001"

Emad Sherbini
on 7/15/13, 8:01 AM

Are you sure you didn't change the invoice date when validate the invoice? or you make manual entries? because it can cause the date and the entries was not in series.

UNTAR, Viktor Aditya
on 7/16/13, 2:03 AM

all data were imported using csv file

Emad Sherbini
on 7/18/13, 11:48 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)

Stats

Asked: 7/12/13, 12:45 PM
Seen: 1325 times
Last updated: 3/16/15, 8:10 AM