Material Shortage Report: Catch the Short Part Before the Line Stops

It is 6:40 on first shift. The assembler pulls the tote for MO-00005, twenty hydraulic power units, and finds the drive shafts missing. Last night's stock report said everything was fine. The control valve sub-assemblies are two hours away in another depot. The aluminum rod for the housings never arrived. The O-rings, the bearings and the spur gears are the only lines that are actually here.

By 6:50 the planner is on the floor with a clipboard, moving people to another job. The half-built pallet stays on the bench for three days. The purchase order for the drive shafts goes out on Thursday, after the weekly shortage meeting, and the customer date slips a week.

The order was planned and the parts were "in stock". What was missing was a material shortage report that tells you, per order and per operation, which components are covered, which are short, and what to do about the short ones without leaving the screen.

Where the shortage hides until the shift starts

The stock system usually knows about the shortage days before the floor does. The people reading it miss it, because "on hand" and "available" are different numbers and the report only shows one of them.

Picture a bin of 500 weld nuts. The count says 500. Another released order has already spoken for 300 of them, but they are still sitting in the bin, so the count still says 500. A hundred more are in the quarantine rack waiting on an inspection. Eighty are on a cart behind the wrong cell. Your order needs 120. The report says 500 in stock, and the line stops at 6:40.

A planner on an Epicor user forum described the same trap with bigger numbers: a hundred jobs that each need 1,000 pieces, a single bin holding 1,000, and every one of the hundred jobs reporting "we're fine". Each job looks at the bin on its own. Nobody nets them against each other until somebody actually issues the parts.

The second place shortages hide is the spreadsheet. SourceDay, a supplier-collaboration vendor, describes the typical shortage list as an export with nine columns: part number, supplier, required date, commit date, quantity required, quantity available, quantity short, production impact, action owner. It names "spreadsheet lag" as the core failure, because the export is stale almost as soon as it lands, and sums it up in one line: the shortage itself is rarely the surprise. The surprise is discovering it too late.

Large plants have the same problem. In a 2026 Wakefield Research survey of 150 senior leaders at large discrete manufacturers, commissioned by LeanDNA, 72% say they discovered a material shortage only after production delays were already unavoidable, and 51% take a week or longer to decide on corrective action. Big plants with full planning teams still find out at 6:40.

What a material shortage report should actually show

A useful shortage report answers three questions for every component on the order:

1. How much does this order still need, after what has already been issued to it?
2. How much of that is covered, either by stock already reserved to this order or by free stock nobody else has claimed?
3. How much is short, and at which operation does the shortage bite?

That means keeping five numbers apart instead of collapsing them into one "in stock" tick. Required is what the operation calls for. Issued is what has physically left the bin for this order. Reserved is what is held for this order and not yet issued. Available is free stock at the issue location that no other order has claimed. Short is required, minus issued, minus reserved, minus available, when that number is still above zero.

Knowing which operation is short changes the decision. A bearing set needed at final assembly on Friday does not have to stop the saw and the mill on Monday. A report that gives one status per order hides that, and the mill sits idle for a week waiting on a part the first three operations never touch.

How the Material Plan works in Qualis

Qualis treats release as the moment of truth for materials, then keeps a live per-operation grid on the order for everything that happens after.

Release is the gate

When you release a manufacturing order, Qualis freezes the bill of materials and routing on the order, converts every component quantity into the unit your stock is counted in, and reserves stock for each component at the order's issue location, operation by operation. Earlier operations claim stock first.

If a component cannot be fully reserved, one of two things happens, and you choose which in Manufacturing Settings:

• Block the release. The order stays put and you get a message naming the short components, the operation, and the quantity short of required (up to five, then "and N more"). Nothing is half-reserved.
• Release with a shortage. The order goes out with a Shortage reservation status, a red banner on the order, and an urgent notification to the person who created it. Production can start on the operations that are covered.

Either way, the shortage is recorded on the order itself, with a component, an operation and a quantity, for anyone who opens it.

The Material Plan tab

Open a released order and click Material Plan. You get one table per operation, and for every component in that operation: Required, Issued, Reserved, Available, Short, and a status pill that reads Sufficient, Short, or Not tracked.

The summary line at the top says either "All components covered" or how many components are short. The Refresh button recomputes everything from live stock, so if receiving put away a pallet ten minutes ago, the grid knows.

Two rules inside that grid decide the numbers.

First, the numbers are time-phased inside the order. A component used at operation 10 and again at operation 20 gets its reserved stock and free stock allocated to operation 10 first. Operation 20 only sees what is left. So the Short column lands on the operation where the bin actually runs out, not on the order as a whole.

Second, stock reserved to another order never shows up as available here. The reservation taken at release is what stops two orders from both reading the same bin as full. If a second order needs the same 300 pieces and the first one already holds them, the second order shows 300 short. Nobody gets two green pills for one bin.

Buy or Make, from the short line

Every short line carries an action. Click Buy and a dialog opens with the short quantity already filled in, a supplier picker, the receiving warehouse (defaulting to the order's site) and a unit price prefilled from the product's purchase price. Confirm, and Qualis creates a draft purchase order in that supplier's currency, with the originating manufacturing order number on it.

If the short component is something you make yourself, the line also carries Make. That creates a planned manufacturing order for the short quantity on the same site, with the sub-assembly's own bill of materials already loaded, and a note saying which order it was raised to cover.

Once the supply order exists, the short line shows a chip with the new number, and the chip is a link. The audit trail on the manufacturing order records who raised what, for which component, in what quantity, and which record was created. Six months later, when someone asks why there is a purchase order for twenty drive shafts dated the morning of the shortage, the answer is one click away.

One guard rail is deliberate. Buy and Make check the permission to create the target document, on top of the permission to read the order. A planner who can see the order but is not allowed to raise purchase orders sees the Short pill and nothing else, so the shortage never turns into an unapproved commitment.

Where the shortages surface before you open the order

You should not have to open forty orders to find the three that are short. The manufacturing orders list opens on a Needs Attention view by default: open orders with a shortage, orders past their planned end date, and orders whose planned start has arrived and are ready to release. The Attention column shows the most severe reason on each row, with a shortage outranking an overdue date.

A Shortages tile above the table counts the open orders in shortage, and clicking it filters the list to exactly those. On the main dashboard, a Material Shortages widget lists them for anyone who never visits the manufacturing app.

What this prevents

• The 6:40 discovery. The shortage is known at release, on the order, before the tote is pulled. Roughly one in nine US plants running below full capacity names an insufficient supply of materials as a reason, per the Census Bureau's plant capacity survey for the first quarter of 2026.
• The stale export. There is no Tuesday spreadsheet to reconcile, because the grid reads live issued and reserved balances every time you open it.
• Two orders claiming one bin. Reservation at release, plus allocation to the earliest operation, means one of them shows the shortage instead of both looking fine.
• The half-built pallet. You can see that operations 10 and 20 are covered and only operation 30 is short, and start the work that can start.
• The lost purchase order. Buy and Make create the supply from the short line, tie it to the order, and write it to the audit trail. The follow-up does not depend on someone's memory after the meeting.

The whole loop on one page

From a written order to a closed shortage, the flow is five steps, and every step leaves a record on the order.

1. Release. The bill of materials and routing are frozen on the order.
2. Reserve. Stock is held per component, earliest operation first. A shortage either blocks the release or is flagged, per your policy.
3. Plan. The Material Plan tab shows required, issued, reserved, available and short for every component at every operation, from live stock.
4. Buy or Make. Each short line raises a draft purchase order or a planned sub-assembly order for the short quantity.
5. Link back. The new order's number sits on the short line, and the audit trail records who raised it and why.

Frequently Asked Questions

How do I know a production order has enough material before I release it to the floor?

Release it. Qualis checks every component at release and either refuses, naming the components, operations and quantities that are short, or releases with a Shortage flag if your Manufacturing Settings allow it. The Material Plan tab then shows the same numbers per operation for as long as the order is open.

Why does my ERP say the part is in stock but the line still stops?

Because on hand is not available. Part of that stock is usually reserved for another order, held in quarantine, or sitting at a location the order cannot issue from. The Material Plan keeps Issued, Reserved and Available as separate columns, so a healthy on-hand count never reads as a promise to your order.

When two work orders need the same part, which one gets it first?

The order that reserves it first, which in practice is the order released first. Inside a single order, the earliest operation gets first claim. If you want a different order to win, put it on hold or cancel its release to free the reservation, then release the other one. Two orders never both show the same stock as available.

Can I raise a purchase order for the missing parts straight from the manufacturing order?

Yes. Every short line on the Material Plan has a Buy button that creates a draft purchase order for the short quantity, to the supplier you pick, in that supplier's currency, with the manufacturing order number on it. Components you make yourself also get a Make button that raises a planned sub-assembly order.

Should I release a work order with a partial kit or wait for the missing component?

Look at which operation is short. If the missing part is only consumed at final assembly, the earlier operations are fully covered and can run. If it is consumed at the first operation, releasing only ties up the covered components. The per-operation grid gives you that answer with numbers, and the release policy in Manufacturing Settings lets you decide whether shortages block or flag.

What should a material shortage report include?

For each component: the quantity required, what has been issued, what is reserved, what is available, the shortage, and the operation where it is needed. It also needs an action and an owner. The Material Plan carries the first six on every line, and the Buy and Make buttons turn the action into a real purchase or manufacturing order with a name on it.

The bottom line

A material shortage report only earns its name if it is on the order, per operation, computed from live reserved and issued stock, and one click from the purchase order that fixes it. That is what the Material Plan tab in Qualis is: release freezes the recipe and reserves the parts, the grid shows what is short and where, and Buy or Make raises the supply without leaving the screen.

If your shortages still show up at 6:40, see it on a live order in Qualis or read how available-to-promise keeps sales from selling stock production has already reserved, and how automatic replenishment keeps the bin from running low in the first place.