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