Skip to Content
This question has been flagged
stockfilterproductqty_availableodoo
1 Reply
7216 Views
Avatar
Nicolás Visús

I want to add a filter to the tree view to show only products that have real stock greater than 0.
I tried to add a custom filter from CONFIGURATION - TECHNICAL - USER INTERFACE - USER DEFINED FILTERS, but nothing happened
The values ​​I used in the filter are:

NAME FILTER: My filter
MODEL: Product
DOMAIN: [['qty_available', '>', 0]]
CONTEXT: {}

Any suggestions?

I'm using odoo version from the odoo official page

 

Avatar
Discard
Avatar
Ludo - 21South
Best Answer

Does the filter itself show up? If so, is nothing changes when you select it from the list view?

Avatar
Discard
Nicolás Visús
Author

Yes, the filter correctly on SALES - PRODUCTS - PRODUCTS but when selected nothing happens (does not filter the database). Another thing I find strange is that, being in SALES - PRODUCTS - PRODUCT, if I click on the columns "internal reference", "variant", "name", etc. the database is sorted, whereas if I click on "quantity on hand" or "forecasted quantity" database is not ordered

Related Posts Replies Views Activity
How name="%(window_action)d" in button works Solved
stock product odoo
Avatar
Avatar
1
Dec 24
2446
How to calculate qty_available OpenERP ?
stock product qty_available
Avatar
Avatar
2
Mar 15
6525
Product on hand quantity is not equal with product move calculation odoo12
stock product inventory odoo
Avatar
0
Sep 21
2357
How to get others Company Data in v12cc ? Solved
stock multicompany qty_available odoo odoo12
Avatar
Avatar
1
Jun 19
4368
Option "Stock Product" is missing in "Product Type" Solved
stock product
Avatar
Avatar
Avatar
3
Aug 24
1982