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.

Această întrebare a fost marcată

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