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	Views
How to hide the add detail line button of an order odoo v15	1 Dec 23	1002
Want to show Products line in Payment View odoo v15	2 Aug 23	934
AttributeError: 'ir.model.data' object has no attribute 'xmlid_to_object' Solved odoo v15	1 Dec 23	2077
how to customize default view in odoo 15? odoo v15	1 Jul 23	1522
How do payments matching against invoices/vendor bills in odoo15? odoo v15	0 May 23	1286

This question has been flagged

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