How can I get a report on the quantity of products I have sold but not yet reserved?

Question

Example:
I have 100 units in stock I sell 15 for an order this week, so 15 units are reserved I sell 25 for an order next week, and since I am not reserving until 2 days before the order, no units are reserved  This is what my Inventory Report shows:
Image [1]

I want to see that I have 60 units since that is what I can sell.  I can calculate this from the 100 On Hand minus the 40 Outgoing, and I know I can see for an individual product what the forecast is but where can I get a report that show

Ray Carnes (ray) · Accepted Answer

You can unhide the Forecasted Quantity in the Inventory --> Reporting --> Stock report:
image [1]

Then, via the Inventory --> Reporting --> Moves Analysis report, you can switch to List View and filter for moves that are "not done" to see the individual orders making up that 40 and how many have been reserved so far (15):
image [2]

[1] /web/image/70905816-2757e8c6/image.png?access_token=9079b4d7-c4fb-413c-8f37-badb2ddfa39f
[2] /web/image/70905815-d7d8f65f/image.png?access_token=6cbc72ee-a98f-

Related Posts	Replies	Views
How to Build Custom Forecasted Quantity Reports in Odoo Solved inventory report forecast quickstart Quickstart	1 सित॰ 25	1298
How to add a field that displays information related to the distance of the last movement of goods with the date the report was drawn inventory report	1 अग॰ 25	1215
Inventory report at date inventory report quantity count Quantity on Hand	0 जन॰ 23	3002
Forecasting based on Sales Data ? inventory forecast	0 फ़र॰ 24	3274
Warehouse \| QTY inventory quantity	1 जुल॰ 21	3179

This question has been flagged

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