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:
- CRM
- e-Commerce
- Бухгалтерия
- Склад
- PoS
- Project
- MRP
Этот вопрос был отмечен
2
Ответы
2912
Представления
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Регистрация| Related Posts | Ответы | Просмотры | Активность | |
|---|---|---|---|---|
|
0
июн. 16
|
2817 | ||
|
2
июл. 22
|
5012 | ||
|
2
авг. 25
|
388 | ||
|
2
авг. 25
|
2518 | ||
|
2
мая 25
|
890 |
