How To Look Up Material Shortages (Order Material Report)
List the open orders that are short of material, which component is short, how many you need and what's on order, then drill into one order line to see where its parts are coming from.Updated Nov 9 2026
Before you start
- Order Material Report is under Production > Orders and needs the Production or Shortage Report role.
-
Run the report
- Go to Production > Orders > Order Material Report. The report loads straight away and shows one row per short component on each open order line (Mode is Short and View By is Order Line by default).
- Read each row: the Order and Line, the Shortage Prcpart, Need Qty, QOH, QOO (on order), Avail and Qty Short, and the next purchase order for it (PO, PO Dock Date, PO Qty Due in).
- To narrow it, click the filter search bar (Filter or search…) and pick a field, for example Customer, Order, Top Level Prcpart, Short Comp Prcpart, a date (Work Start Date, Ship Date, Dock Date), Trans Code or Location. Click Apply (n).
- Optional: set Mode to Ontime to list the lines that aren't short, or View By to Order to judge each order across all its lines.
-
See an order line's material
- On Production > Orders > Order Material Report, click View at the end of the row. The Allocation For page for that order line opens (a classic page) with the order, quantities, dates and customer.
- Click Use New Version to see the same page on the new work order screen (Parts > Order Material Report). Cetec ERP remembers the choice.
- Each short component is listed with its Balance Due. Click Show under Allocation to see which orders its stock is allocated to, and open Part Info for its stock and purchase orders.
- Type a note in Late/Short Comment and click Submit to record why the line is short.