Resolve a material shortage against the quantity and date that a specific production order needs. Match the approved component requirement with eligible stock and supply that can arrive, pass required checks, and reach the operation in time. Keep planned requests, unconfirmed orders, and late receipts distinct from usable coverage.
If tomorrow’s build is waiting for one component, start with that component’s demand and supply records. A warehouse total can include held stock or units reserved to another order (even when the total exceeds your requirement). The shortage report needs to show the uncovered quantity, its required date, and which owner can change the next decision.
Confirm the order’s remaining component demand
Use the released order and approved bill of materials to establish item, revision, required quantity, unit, and need date at the consuming operation. Subtract components already issued under the source workflow, preserving returns and approved changes. Do not count the original order quantity and its remaining requirement as two demands.
The bill of materials article covers component quantities and revisions. Here, retain the requirement line that connects the part to the affected build. If several orders need the same part, keep their dates and priorities before rolling them into a purchasing total. One aggregate shortage can hide the order that will miss its start first.
ERPNext’s BOM Stock Analysis documentation describes a detailed view of raw-material availability and shortfall for a specified build. Its summarized view estimates producible quantity for a BOM and warehouse. Use that source-specific distinction when selecting a report; a warehouse-level producible total still needs the order and date context for an execution decision.
Separate physical stock from supply the order can use
Check the item and revision, warehouse, stock status, and any lot or expiry restrictions that apply to the build. Confirm whether the source’s available quantity already excludes reservations or holds. Subtracting them again would understate supply; ignoring them in a gross on-hand balance would overstate it.
Read the source definition behind projected stock. ERPNext’s projected-quantity formula includes planned, requested, and ordered quantities alongside actual stock and reservations. That is useful planning context, but the included future quantities are not all physically available today. Keep their document type and status when using them in a dated shortage view.
Retain the inbound order line, remaining quantity, confirmed date, receiving location, and inspection or transfer time required before use. A supplier’s ship date is not the same as your material-ready date. If confirmation is missing, show the date as uncertain and assign purchasing to obtain it; substituting the requested date would hide the uncertainty.
Calculate the shortage before the next receipt arrives
Assume a hypothetical production order needs 70 identical components at 08:00 Tuesday. Monday’s warehouse balance shows 80 units. Ten are held, twenty are reserved to other orders, and these are disjoint quantities excluded from this order. No components have been issued to the build. A confirmed receipt of 30 usable units will be ready Wednesday morning, after the required start.
| Demand or supply | Treatment for Tuesday | Quantity |
|---|---|---|
| Remaining build requirement | Required at 08:00 | 70 |
| Eligible on-hand | 80 minus 10 held minus 20 reserved | 50 |
| Wednesday receipt | Late for this need date | 0 before Tuesday start |
| Tuesday shortage | 70 minus 50 | 20 |
The order is short twenty units at its required start, despite eighty physical units and another thirty on the way. Under these assumptions, Wednesday’s receipt would cover that shortage after the required date. It does not remove the Tuesday exception. Keep both the quantity gap and the later coverage date in the handoff.
If the bill of materials uses two of these components per finished unit and every other component is ready, the fifty eligible units support at most twenty-five complete units before Tuesday. That is a material-only bound for this example, not a capacity or release recommendation. The production owner must confirm that a partial build is permitted and that the downstream sequence can accept it.
Part, quantity, need date
Status, commitment, ready date
Affected build and next owner
Assign the response without counting supply twice
Ask purchasing to confirm an earlier usable receipt or another supported source. A transfer needs eligible stock at the sending location and enough time to receive it at the consuming site. Reallocating stock from another order needs the owner’s approval and a visible consequence for that order. Keep each proposal separate until it changes an authorized record.
Before creating another request, inspect the documents already linked to the shortage. ERPNext’s Production Plan documentation shows how available and projected stock affect material-request quantities and how requirements can lead to work orders or requests. Preserve those links in your review so a request that became a purchase order is not counted again as independent incoming supply.
Engineering owns substitute eligibility. A similar description or shared supplier does not establish that another revision, grade, or dimension can be used. Record the approved substitution and affected orders, then have the responsible owners update the source instructions. A shortage report can expose the decision without granting permission to change the build.
If the response is to move the build, use the production schedule adherence process to preserve the original commitment and record the reason for the revision. Changing the planned start after the fact should not erase the material constraint that caused the change.
Close the exception when usable coverage is recorded
Keep the shortage open until the approved response has evidence: a released hold, a received transfer, or a confirmed schedule change with its affected demand. An email promising an expedited delivery can support follow-up, but it is not the receiving event. Preserve the promised date and actual material-ready date so purchasing can review what changed.
For recurring shortages, group causes only after reviewing their evidence. Missing stock, late supply, obsolete requirements, and competing reservations need different corrections. Use inventory allocation for shared-stock priority rules; a new purchase order will not fix a report that assigns the same units to several builds.
How Permute connects a shortage to its supporting records
Permute sells connected business data, custom applications, and governed analysis. We can connect permitted NetSuite demand and inventory records with Excel supplier confirmations, retaining the order and component references behind a shortage. Ambiguous item mappings and missing dates remain review items.
We apply your declared eligibility and date rules across a recurring report. A production planner can inspect which order lacks usable coverage by its need date and which source records explain the gap. An exception view can preserve the affected build, proposed response, and current evidence under the permissions you grant.
Trace one shortage through its records
Connect permitted component demand, stock, and inbound order extracts to inspect their matching references.
Keep supply commitments and build approval with their owners
We are not a forecasting engine, and this workflow does not create a purchase commitment or authorize a substitute. Purchasing, engineering, and production approve their respective decisions in the operating systems. Confirm source freshness before using the view for release; an outdated hold or receipt status can change the answer.
A material shortage is a dated gap between a build’s remaining requirement and eligible coverage. Retain the source definitions behind on-hand and projected quantities. Assign each proposed response to an owner and preserve the other orders it affects. Close the exception with recorded usable supply or an approved demand change, keeping the reason visible for the next review.
Review the records behind recurring shortages
Bring component requirements and the supply exceptions that keep delaying their release.
Questions about production material shortages
Does a material shortage require a negative stock balance?
No. Stock can be positive while the eligible quantity before the need date is insufficient. Review holds, reservations, revision restrictions, and material-ready dates before concluding that the build is covered.
Is a shortage resolved when the purchase order is sent?
The purchase order establishes a supply request or commitment under its own terms. Confirm the delivery and material-ready dates against the build’s need date. Keep the execution exception visible until the response supports the required quantity and timing.
Should the cheapest missing component receive lower priority?
Use the affected build and approved priority policy, not component price alone. A low-cost part can block a much larger order when the build cannot proceed without it. Keep that dependency visible while evaluating expediting cost and the effect on other work.