Skip to Content
This question has been flagged
stockwarehouseproductcontext
2 Replies
7077 Rodiniai
Portretas
Arian Shariat, Arian Shariat

I'm using the following code to get the quantity of a product based on two warehouses I already created:

product = self.env['product.product'].browse(PRODUCT_ID)

product_wh_1_qt = product.with_context({'warehouse': WAREHOUSE_ID_1}).qty_available
product_wh_2_qt= product.with_context({'warehouse': WAREHOUSE_ID_2}).qty_available
but something odd happens: the first result is right but the second result is the same as the first result (but it should not be because quantities are different in warehouses)

If I change the order qnd do this:

product_wh_2_qt = product.with_context({'warehouse': WAREHOUSE_ID_2}).qty_available
product_wh_1_qt= product.with_context({'warehouse': WAREHOUSE_ID_1}).qty_available
again the first result is right but the second one is the same as first one. any ideas how to fix?

Portretas
Atmesti
Portretas
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

Try like this,

product_wh_2_qt = product.with_context({'warehouse': WAREHOUSE_ID_2}).qty_available
product_wh_1_qt = product.with_context({}, warehouse=WAREHOUSE_ID_1).qty_available

For more see: Odoo ORM


# current context is {'key1': True}
r2 = records.with_context({}, key2=True)
# -> r2._context is {'key2': True}
r2 = records.with_context(key2=True)
# -> r2._context is {'key1': True, 'key2': True}


Thanks

Portretas
Atmesti
Arian Shariat, Arian Shariat
Autorius

thanks a lot

Portretas
Zone4erp Solutions, Swathi
Best Answer

Hi @niyas, both the lines are coming same value only for multiple warehouses..!!! 

Any solution..??

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Product Stock
stock warehouse product
Portretas
0
birž. 16
3846
OdooV13 Get product availability in warehouses using odoo ORM Solved
stock warehouse product odooV13
Portretas
Portretas
2
gruod. 20
4441
Fraccionar lotes en / Splitting Lots in Odoo 18
stock warehouse
Portretas
Portretas
Portretas
2
rugp. 25
2332
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Solved
stock warehouse
Portretas
Portretas
2
birž. 26
11525
The inventory module does not assign the next storage location but the central location.
stock warehouse
Portretas
Portretas
Portretas
2
geg. 25
2979