Inventory Report suggestion

Manager is already a great tool for the Management of Inventory. And there is a report I want to suggest that will take the management of inventory to a higher level.

I do my best to suggest and comment to make this app better every year. I bet @lubos will have better ideas on how to interlace such a feature into the app.

The application shows the user Quantity to receive, Quantity on hand, quantity to deliver and quantity owned. However all merchandise companies strive to have great control of the management of customer orders for optimum consumer satisfaction and JIT delivery.
To achieve this the company will have to have quick reports on inventory quantity owned adjusted by pending inbound and outbound orders.

This is important to make sure every customer is happy and important customers always get what they want.

Below is a report I suggest Manager.io should have to help all users and sales managers, production managers and warehouse managers better manage inventory and satisfy customers.

The report is displayed inventory item by inventory item. So the user will have to select the inventory item being considered and proceed to see the statement.
The inventory item in my example is called ZT Light Bulb (medium sized).

This report brings Purchase and Sales orders into the decision-making for inventory formula.
Users can for example decide to adjust orders or delay delivery of inventory for regular customers to meet the demands of a highly important customer with this guide.

Of course the current sales and purchase order tabs are just document generating tabs. They will have to come alive to be able to provide for manager stats to compute such report. Orders will have to have opened and closed statuses (order fulfilment tracking) to make such a feature work.

It is just a suggestion/idea.

I think the report would also have to take into consideration Goods Receipts & Delivery Notes.

You could have issued a Delivery Note for 8 units so there would be 72, but the Quantity owned is not adjusted until the Sales Invoice is created. So you would have:

Quantity Owned
Less delivers not sales invoiced
Less pending sales orders
Plus receipts not purchased invoiced
Plus pending purchase orders
= Adjusted quantity owned

Or work from the Quantity on Hand, then Goods Receipts & Delivery Notes have already been included.

I agree