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

Job ID: 32549778

Budget: €8 – €30 EUR

Hello,

*pictures added.

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? If you can tell me how to do it I can give you 30$.


I am on the Odoo 15.0+e Enterprise Version with little access to the code.
Related categories: Python Software Architecture ERP Odoo