How to get product quantity

Question

I need to get product quantity on product onchange. There is a model stock_quant, which records all quantity activity.
How can I get the available quantity of the product? I am writing following function and getting stock_quantity lines but not sure how to filter out the available quantity -
@api.multi
@api.onchange('product_id')
def product_location_change(self):
if self.product_id:
stock_qty_obj = self.env['stock.quant']
stock_qty_lines = stock_qty_obj.search([['product_id', '=', self.product_

Md. Tanzilul Hasan Khan · Accepted Answer

For All Warehouse this is how the quantity can be checked:
product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.qty_available For specific warehouse/location:
product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.with_context({'warehouse' : WAREHOUSE_ID}).qty_available
available_qty = product.with_context({'location' : LOCATION_ID}).qty_available
Other fields are:
Forecasted Stock => virtual_available
Incoming Stock => incoming
Outgoing Stoc

Jaime Vasquez · Answer

Add a loop to the stock lines:
def product_location_change(self):
if self.product_id:
stock_qty_obj = self.env['stock.quant']
stock_qty_lines = stock_qty_obj.search([['product_id', '=', self.product_id.id]])
print stock_qty_lines
# TODO: GET AVAILABLE QUANTITY OF THE PRODUCT
*available_quantity = 0
for row in stock_qty_lines:
available_quantity += row.quantity #change for your quantity field
print available_quantity
*
HTH

Vijay Maurya · Answer

This module will help you
https://www.odoo.com/apps/modules/10.0/product_qty_in_multi_warehouse/

المنشورات ذات الصلة	الردود	أدوات العرض
Product Stock stock warehouse product	0 يونيو 16	2820
EAV product attributes product orm odooV8	2 مارس 15	5091
Odoov13 object.with_context(...) result doesn't change تم الحل stock warehouse product context	2 يوليو 22	5013
OdooV13 Get product availability in warehouses using odoo ORM تم الحل stock warehouse product odooV13	2 ديسمبر 20	2914
Reading product lines - Odoo v8 - Object has no attribute '' تم الحل warehouse product mrp odooV8	1 أكتوبر 17	3533

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!