Forecasted Quantity = "on hand" plus "on order" minus "sold not delivered". Can I see "on order" and "sold not delivered" separately?

Question

When I created a sales order for a product the forecasted quantity is decreased and when I create a purchase order for the same product, the forecasted quantity is increased.
Is it possible to view both, separately?

Ray Carnes (ray) · Accepted Answer

The names of the fields you want are: *incoming_qty *= what has been purchased (confirmed Purchase Orders) but not yet received. *outgoing_qty* = what is sold (confirmed Sales Orders) but not yet delivered. Inherit and override product.template.stock.tree.inherit and add them: You will then see four Quantities per product:

Sushma · Answer

Hi Salih,
Forecasted quantity of products you can sell for a specific warehouse or location. It is defined as the Quantity on Hand - Future Delivery Orders + Future incoming shipments + Future manufactured units.
In your case you can define new computed fields to find forecasted for sale order and same for purchase order,  you find this difference based on destination and source locations.

Nikhil Agarwal · Answer

Forecasted quantity is the the status of your inventory based on what purchases and sales are done. You can build a custom view to compute the total items not shipped in sales and also the items purchased but not delivered. This is something that you can get customized by doing a count on your purchased orders for that product and on the sales orders for that product.

This question has been flagged

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