How to get # of items present in active quotations - what field/model am I looking for?

Question

We need to be able to query the number of a given product currently in *quotations*. In other words, take inventory of a given SKU, and get a number back which is the total no. of them currently in active (not cancelled) quotations.
I understand that Odoo's logic is to count inventory once it is on a sales order. But for our needs, we also need to be able to get a quick take of how many are in quotations.
What database model/field do I need to look for here?
I've looked around and cannot seem to

Jack Dane · Answer

Hello Hibou,
I wrote this script within a scheduled action and seems to work:
internal_reference = "DESK0004"
sale_order_lines_quantity = sum(
env["sale.order.line"].search
(
["&", ("product_id.default_code", "=", internal_reference), ("order_id.state", "=", "draft")]
).mapped("product_uom_qty")
)

raise Warning(sale_order_lines_quantity)

The idea behind it is that you are searching for all sales orders lines where the order_id (related sales order) is in the draft stage (quotation). You then s

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Warehouse \| QTY inventory quantity	1 heinäk. 21	2987
name field is not created fields model	2 kesäk. 19	3274
Set the quantity by default to 0 if it is not validated yet. Ratkaistu inventory receipt quantity	1 heinäk. 25	2769
What the usage of ir.model.fields in m2o field? Ratkaistu fields many2one model	1 marrask. 24	2983
Negative quantities on hand inventory quantity Quantity on Hand	2 lokak. 24	2850

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!