Pricelists: How do I sort by product ("Applicable On" field)

Question

I would like to sort pricelists by the product code and description ("applicable on" field as shown below), instead of by other fields like MOQ and start/end dates. How can I do this?

I tried to do this within studio, but the "applicable on" field was not available to choose from for sorting ("applied on" is a different, normally invisible, field):

Jainesh Shah(Aktiv Software) · Answer

Hello Paul Phillips,
You can try '_order' attribute in your model to sort the records as shown below.
_inherit = " product.pricelist.item" [1]
_order = "applicable_on,field_2 asc, field_3 desc"
Please refer below link it may help you to configured properly.
link: https://www.odoo.com/documentation/15.0/developer/howtos/rdtraining/12_sprinkles.html?highlight=_order [2]
Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

[1] https://product.pricelist.item
[2] https://www.odo

Related Posts	Odpovědi	Zobrazení
How do I disable the price list quantity warning? sales pricelists	1 čvn 25	538
How to add additional content in chatter while cancelling the sale order. Vyřešeno sales v14	1 čvn 22	2044
sales startup cost sales v14	1 lis 21	1587
Price for extra product items different from base price pricelists v14	0 dub 21	1912
Turnover Reports for Sales People - EE14 sales turnover v14	1 říj 24	2026

This question has been flagged

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