Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I would like to query available stock for a given list of products, in a given location.
Currently I'm searching in stock.quant, with [['product_id.x_some_studio_field','in',[array of blah],['location_id.name','=',location_name]]
the problem with this approach is that it seems if the product never had stock entered in stock.quant, it will not return a line for the product.
Is it possible to query the product.product model, so I can read qty_available, but only for certain locations?
Hello Hernan,
You can do the following to fetch the available quantities particular for that stock location
product.with_context( {'warehouse': your_warehouse_id}).qty_available Thanks
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
