Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
On the inventory "listing view" page I want to sort the field "Lot/Serial number" from lowest to highest, but the field seems to be a "text" so it sorts wrong: 1,10,100, etc instead of 1,2,3,4...etc.
is there a way to sort it well?
I am on the Odoo 15.0+e Enterprise Version with little access to the code.
The "Sequence" may have been changed, but default it is setup to provide seven "digit" character based numbers padded on the left with 0's (as @Yann explains):
Find the Sequences Menu when Developer Mode is active.
Hi
The Lot/Serial number field is a Char.
So, Odoo use the alpha order.
If you want to have a list in a numeric order, you should prefixe your number with the same number of 0 :
00001, 00010, 00100
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
