I need to sort "Lot/Serial Number" as numbers , not text.

Question

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. None [1]
is there a way to sort it well?

I am on the Odoo 15.0+e Enterprise Version with little access to the code.

[1] https://4%5C.%5C.%5C.etc

Ray Carnes (ray) · Answer

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.

Yann Glorieux · Answer

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

Related Posts	Replies	Zobrazenia
How to hide the add detail line button of an order odoo v15	1 dec 23	2761
Want to show Products line in Payment View odoo v15	2 aug 23	2406
AttributeError: 'ir.model.data' object has no attribute 'xmlid_to_object' Solved odoo v15	1 dec 23	4215
how to customize default view in odoo 15? odoo v15	1 júl 23	3019
How do payments matching against invoices/vendor bills in odoo15? odoo v15	0 máj 23	2951

This question has been flagged

Enjoying the discussion? Don't just read, join in!