We have two warehouses and several products in our system. quantity of products are updated and assigned to these warehouses. Is there any way to find out a specific product is available in which warehouse? for example we have a product named 'testproduct'. I want to see which warehouses have this product using odoo ORM. (in which warehouses quantity of testproduct is not zero). thanks in advance.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
2
回复
2920
查看
I've figured it myself.
product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.with_context({'warehouse' : WAREHOUSE_ID}).qty_available
if available_qty <= 0 ...
Hi Arian,
You can find that in the inventory report. There you can filter on product, and you'll find all stock locations in the list. In my screenshot below, I have 2 warehouses: M and TT.
There are 11 pieces of the whiteboard in warehouse M and 10 pieces in warehouse TT.
Is there any way to do this using odoo ORMs?
Sorry, that I don't know
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
0
6月 16
|
2830 | ||
|
2
7月 22
|
5047 | ||
|
2
8月 25
|
434 | ||
|
2
8月 25
|
2591 | ||
|
2
5月 25
|
903 |
