Skip to Content
This question has been flagged
stockwarehouseproductcontext
2 Replies
5709 Views
Avatar
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?

Avatar
Discard
Avatar
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

Avatar
Discard
Arian Shariat
Author

thanks a lot

Avatar
Swathi
Best Answer

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

Any solution..??

Avatar
Discard
Related Posts Replies Views Activity
Product Stock
stock warehouse product
Avatar
0
Jun 16
3154
OdooV13 Get product availability in warehouses using odoo ORM Solved
stock warehouse product odooV13
Avatar
Avatar
2
Dec 20
3487
Fraccionar lotes en / Splitting Lots in Odoo 18
stock warehouse
Avatar
Avatar
Avatar
2
Aug 25
1144
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Solved
stock warehouse
Avatar
Avatar
2
Aug 25
9004
The inventory module does not assign the next storage location but the central location.
stock warehouse
Avatar
Avatar
Avatar
2
May 25
1613