We are getting a request from our purchasing and production that requires the MRP to actually filter down the “Sum Req’d Qty” to the “Order #” instead of showing us the quantity we need to complete that work order.
For example, in our current MRP, I select “SLC-Main” in Location, “Supply/Demand” in Source Type and “2683.1” in the Order #.
It currently shows every part in that “Order #” that currently has demand regardless if that “Order #” demands it or not. The waterfall for part 70-11565 shows that 2683.1 doesn’t require any further orders to complete that work order number but it’s showing a demand for 19EA from other work orders.
Instead, we need this report to just show what is actually required for the “Order #” we filtered by – in this case 2683.1. In this example, 70-11565 shouldn’t show up on this filtered view because no additional material from that part number is needed to complete the “Order #”
Because our systems are large and are built over a few months, the overlapping orders require we be able to filter down on work orders to a very specific set of what is still needed to complete a system.
I understand why we would want to see the report as it is laid out now in the future, but we also need finer detail than that. Is there a way we could add a checkbox to the search options that restricts results ONLY to the searched Work Order?