Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
How to change the behavior of bank statement line numbering?
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?
About This Community
This platform 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.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 11/8/13, 7:01 AM |
| Seen: 1378 times |
| Last updated: 6/6/15, 7:41 PM |
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