Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
2922 Visualizzazioni

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
Abbandona
Autore Risposta migliore

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
Abbandona
Risposta migliore

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
Abbandona
Autore

Is there any way to do this using odoo ORMs?

Sorry, that I don't know

Post correlati Risposte Visualizzazioni Attività
0
giu 16
2830
2
lug 22
5047
2
ago 25
436
2
ago 25
2606
2
mag 25
903