Skip to Content
This question has been flagged
stockwarehouseproductcontext
2 Replies
4396 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 IT)
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
2408
OdooV13 Get product availability in warehouses using odoo ORM Solved
stock warehouse product odooV13
Avatar
Avatar
2
Dec 20
2461
The inventory module does not assign the next storage location but the central location.
stock warehouse
Avatar
Avatar
1
May 25
69
Negative Inventory Journal Entry - "Revaluation of PM/DO/XXX" Solved
stock warehouse
Avatar
Avatar
Avatar
2
Apr 25
429
Error in setting outgoing-shipment steps Odoo
stock warehouse
Avatar
Avatar
1
Apr 25
4086