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.

1

How to change the behavior of bank statement line numbering?

By
Erik
on 11/8/13, 7:01 AM 966 views

When I create a bank statement and confirm it the lines (journal entries) are numbered as follows:

BNK/2013/007/1
BNK/2013/007/2
BNK/2013/007/3
...

While I can change the first part "BNK/2013/007" in Settings/Sequences I have no control over the last part (1, 2, 3 ...).

This is a problem if I have more then ten entries because the tenth will be BNK/2013/007/10.

Then when I try to sort the journal entries by number I get the following behavior:

BNK/2013/007/1
BNK/2013/007/10
BNK/2013/007/2
BNK/2013/007/20
BNK/2013/007/3
BNK/2013/007/4
BNK/2013/007/5
...

Ok, I understand the way the sorting works (by characters - no problem there) - so the solution would be, to add leading zeros (001, 002, ... , 010 ...).

How / Where can I do this?

in my opinion leading zeros are not the good solution and I have no idea that it is possible; this being said, OpenErp seems not to be able to properly sort a list of number, as it sorts lists based on caracters only

AD LIBITOM, michel Guénard
on 11/8/13, 8:05 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: 11/8/13, 7:01 AM
Seen: 966 times
Last updated: 6/6/15, 7:41 PM