Skip to Content
This question has been flagged
fieldsinventoryquantitymodelquotations
1 Reply
2735 Views
Avatar
Hibou Ambigu

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 find it - even in developer mode.

Perhaps I'm missing it.  

Avatar
Discard
Avatar
Jack Dane
Best 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 search on the product_id.default_code to check that the sales order line is the product you are looking for. You then map by the quantity and get the sum. 

I hope this helps.

Thanks, 

Avatar
Discard
Related Posts Replies Views Activity
Warehouse | QTY
inventory quantity
Avatar
Avatar
1
Jul 21
1566
name field is not created
fields model
Avatar
2
Jun 19
1679
What the usage of ir.model.fields in m2o field? Solved
fields many2one model
Avatar
Avatar
1
Nov 24
147
Negative quantities on hand
inventory quantity Quantity on Hand
Avatar
Avatar
2
Oct 24
178
Set the quantity by default to 0 if it is not validated yet.
inventory receipt quantity
Avatar
0
Oct 24
437