This question has been flagged
4011 Views
sequencebank_statementnumbering
Avatar
Erik

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?

Avatar
Discard
michel Guénard

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