Skip to Content
Menu
This question has been flagged
2 Replies
20833 Zobrazenia

hello,


In stock module, I have 'inventory control' -> 'products'; when switched to list view I can see list as on pisture attached. Problem I have is that I can sort the list using for example 'product type' column (marked green), but cannot sort using 'quantity on hand' nor 'forecasted quantity'. View name used for the list is 'product.template.product.tree'; column 'quantity on hand' and 'forecasted quantity' are inherited from other, 'product.template.stock.tree.inherit'.

How to make fields marked in red on picture, labeled as:

<field name="qty_available"/>

<field name="virtual_available"/>

to be sortable?


regards

Tomasz

Avatar
Zrušiť
Best Answer

That fields are compute fields. By default, they are not stored at database, so you cant sort products by that fields.

You can set them store="True" and thats make it possible to sort on qty on hand of forecast

Avatar
Zrušiť

Indeed, and yet, the more computed fields are in tree view, the more it takes to be fully charged. You should use them wisely.

Autor Best Answer

 


..and picture attached.
Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
nov 19
3504
0
jan 25
1
0
júl 24
973
3
máj 16
5519
2
dec 22
7302