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
- Проекты
- MRP
Этот вопрос был отмечен
2
Ответы
3452
Представления
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
июн. 16
|
3149 | ||
|
2
июл. 22
|
5638 | ||
|
2
авг. 25
|
1108 | ||
|
2
авг. 25
|
8960 | ||
|
2
мая 25
|
1572 |
