Would it be possible to add a column in manufacturing centre which states that X amount of that product has been took up by an order. Until the order has been "Completed", parts are still sat in our warehouse until we have collected, packaged and shipped them.
For example I have 1 part in stock. A customer buys 1 item and now my stock levels are at 0.
So no my Committed - shortage - Free To Use - Total In Warehouse are all at 0.
If there could be another column which states "On Order" which would show 1.
This would make life much easier as we have 100 plus parts and we know how many of each part we need to collect to complete the orders without having to look at each order separately.