When materials run short on active work orders, production slows, jobs slip, and your team scrambles to find out what to buy first. Many purchasing teams look for a single parts short sheet that tells them which components are short and where they are needed.

In Cetec ERP, that parts short picture comes from two core reports. The MRP - Buy report shows total demand and shortage by part, and the Order Material Report shows required components by work order. Used together, they give purchasing and production a clear, practical view of shortages across your manufacturing business.

Using MRP - Buy to See Total Part Demand

From the purchasing side, start with the MRP - Buy report set to exclude BOMs. This view shows the total net need for each part across all open orders and considers any supply already on open purchase orders. It effectively answers the question, "Across the entire schedule, where are we short on this part number?"

With that report, your buyers can sort by shortage quantity, required date, or other fields to focus on the highest impact parts first. Instead of chasing one job at a time, you can see the full picture of material demand and place purchase orders that cover multiple open work orders at once.

Using the Order Material Report for Work Order Detail

The Order Material Report, available from the production side, breaks demand down by work order. Instead of total demand per part, you see which work orders require each component and in what quantity. This is the view you use when you need to answer, "Which job is going to be short on this part next?"

You can set the Trans Code search field to Stock to focus on components that must come from inventory or new purchasing. That helps production planners and buyers coordinate on which jobs can proceed with on-hand stock and which jobs are pending material arrivals.

Using Both Reports as a Practical Parts Short Sheet

In practice, the MRP - Buy report and the Order Material Report work together as your parts short sheet in Cetec ERP. MRP - Buy tells you which parts are short across the business and in what quantities after considering open purchase orders. The Order Material Report shows you exactly how those shortages affect individual work orders and delivery dates.

A typical workflow is to review MRP - Buy to identify critical shortages, then use the Order Material Report to see which jobs will be affected and when. Purchasing can then issue or update purchase orders with confidence, while production knows which jobs can move forward and which may need to be rescheduled or split.

Key Takeaways

• MRP - Buy shows total net demand and shortages by part across all open orders, considering supply from open purchase orders.
• The Order Material Report breaks material requirements down by work order and can be filtered to focus on stock components.
• Using both reports together gives purchasing and production a clear view of which parts are short, where they are needed, and how to act first.
• A consistent reporting routine helps keep customer orders on time and reduces last-minute expediting when shortages appear.

Conclusion

There is no single parts short sheet button in Cetec ERP, but the combination of MRP - Buy and the Order Material Report gives you the same result with more control. When your team understands how to read and use these reports together, you can spot shortages early, prioritize purchasing, and keep production and customer commitments on track.