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
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
