İçereği Atla
Bu soru işaretlendi
stockwarehouseproductodooV13
2 Cevaplar
4435 Görünümler
Avatar
Arian Shariat, Arian Shariat

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.

Avatar
Vazgeç
Avatar
Arian Shariat, Arian Shariat
Üretici En İyi Yanıt

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 ...
Avatar
Vazgeç
Avatar
Tom Van de Velde
En İyi Yanıt

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.


Avatar
Vazgeç
Arian Shariat, Arian Shariat
Üretici

Is there any way to do this using odoo ORMs?

Tom Van de Velde

Sorry, that I don't know

İlgili Gönderiler Cevaplar Görünümler Aktivite
Product Stock
stock warehouse product
Avatar
0
Haz 16
3835
Odoov13 object.with_context(...) result doesn't change Çözüldü
stock warehouse product context
Avatar
Avatar
Avatar
2
Tem 22
7059
Fraccionar lotes en / Splitting Lots in Odoo 18
stock warehouse
Avatar
Avatar
Avatar
2
Ağu 25
2328
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Çözüldü
stock warehouse
Avatar
Avatar
2
Haz 26
11522
The inventory module does not assign the next storage location but the central location.
stock warehouse
Avatar
Avatar
Avatar
2
May 25
2973