Hi Sir,

The purchasing manager wanted me to break it down by components. So when a customer orders the assembly then she can just run this application and it will give her what can be build at this point and how many components to order for the next build. With the TotalOnHand, it will tell how many in stock of each component; and the NetQty is the remaining stock after the assembly is built. QtyPer is the number of each component needed to build the assembly.

Currently, I have a function called What-If. The purchasing manager wanted to go on the Sales Order level to add to this. This will ask for a parent part number and quantity of the assembly to be built. This will generate the Bill of Material of the particular assembly and it will show per component what we have in the warehouse. It will calculate if we are capable of building the specified quantity or we need to order more of the components that is showing negative NetQty. This is where the TotalOnHand and NetQty per component come into place.

The purpose of this application is to predict/see at the current situation if the production is capable of building the specified quantity and it will also show how much per component we need to buy.

Thanks,
Sam