From Where I will get Current quantity of product?

Question

Hi All,
*From which table i can find current quantity of product ?*
*Like If some SO confirmed creates some DO automatically====>Stock decreassing*
*Same like PO confirmed creates some IN automatically ..=====>Stock increassing*
*So from where I will get current quantity of product *
*is it from stock.quant? or some other way ?*
*
*
* need to iterate on stokc.quant table to find qty ?
*

Parth Patel (pat) · Accepted Answer

Hello,
The better way will be use On Hand Qty:
Quantity on hand = qty_available (technical name)
Model: product.product

This field is inherited in stock module in product.py.
*NOTE: *As this is compute field, an instance of it will not available in the database table, you will be able to directly get it in through your model query.

This question has been flagged

Enjoying the discussion? Don't just read, join in!