The sales team confirmed the delivery date in CRM, and the planner issued a production order in ERP, but the workshop supervisor said, “Materials are not all available; we can’t start production.” The warehouse system indicated sufficient raw materials, yet upon closer inspection, it turned out that some materials were in the pending inspection area, others were reserved by other work orders, and some were still en route and hadn’t arrived yet —three instances of “available stock” combined do not equate to “production can commence.” If inventory management and production scheduling operate independently, what enterprises see will always be fragmented local optima .
Why does separate management inevitably lead to mismatches?
Many companies’ ERP systems have inventory and production modules that went live at different times, with unsynchronized master data and unconfigured reservation rules . A typical disconnect:
- Sales order → Production demand : During MRP calculations, the BOM version is outdated, resulting in material requirements that don’t match actual processes.
- Procurement arrival → Available inventory : Goods arrive for inspection, yet MRP still calculates full sets based on “in transit + inventory,” leading planners to mistakenly believe production can begin.
- Production material issuance → Inventory deduction : First issue then subsequent replenishment or over-issuance without approval causes further discrepancies between records and physical stock.
- Work reporting & completion → Finished goods warehousing : The workshop reports work completed, but warehouse staff haven’t confirmed receipt, leaving sales unable to verify available quantities, which remain at zero.
What managers need isn’t four independent reports, but rather a single, visible end-to-end link from order to delivery : whether this work order can start production, what’s missing, when everything will be ready, and how much can be shipped upon completion.
How should business functions be divided: inventory, work orders, material availability, and work reporting?
Inventory: Available quantity vs. bookkeeping quantity
Inventory management must distinguish among: bookkeeping inventory, available inventory, reserved inventory, inventory in transit, and inventory awaiting inspection . Sales commitments, MRP calculations, and material availability checks should all be based on “available plus expected in-transit (with ETA),” rather than simply SUM(quantity).
Production work orders: The interface between planning and execution
Work orders carry: product, quantity, planned start/completion dates, BOM breakdowns, process routes, priorities, and associated sales orders. Work order statuses should be more granular than just “in progress”: awaiting material availability, already available but awaiting dispatch, in production, awaiting warehousing, closed . The “awaiting material availability” status should automatically trigger a shortage list and procurement/allocation recommendations.
Material availability check: The gatekeeper before production begins
Material availability equals meeting all required materials for a work order (including auxiliary materials and packaging) within available inventory plus allocated reserves . Inspection granularity can extend down to the process level—for example, before starting a particular operation, only the preceding materials need to be fully available. The shortage list should display: material name, required quantity, available quantity, shortfall, estimated arrival date, and alternative material options.
Work reporting and write-back
Work report records: process, finished quantity, scrap, labor hours, operator. The final process report triggers the finished goods awaiting warehousing ; after warehouse confirmation, additional finished goods are added to available inventory, with an optional automatic update of the sales order’s available quantity. Work reporting and quality inspection are linked: no work completion is allowed unless the item passes inspection (see quality module design).
How to design: Reservations, allocations, and an integrated dashboard
Reservation and allocation mechanisms
When confirming a sales order or issuing a work order, soft reserve based on BOM requirements is applied to inventory; once material availability is confirmed, hard allocation to the work order occurs (locking specific batches/locations). Production material picking is done from the allocated pool, avoiding disputes like “total warehouse has stock, but the work order gets nothing.” For rush orders, there must be revised reservation calculations and priority rules , otherwise high-priority orders will never secure materials.
Integrated dashboardPlanner’s dashboard: All work orders’ material availability status, top shortages, and estimated start dates. Workshop’s dashboard: Today’s assignments, materials awaiting pickup, tasks pending reporting. Sales’ dashboard: Order line’s promised quantity and estimated shipping date (derived from work order progress, material availability, and ongoing production). All three view the same data set, rather than three separate Excel spreadsheets.
Boundaries with WMS/MES
ERP manages
planning, reservations, costs, and financial inventory ; WMS handles storage locations and picking operations; MES oversees process reporting and work-in-progress. Interface agreement: WMS confirms shipment → ERP deducts inventory; MES reports work → ERP records labor hours and completion; ERP issues work orders → MES schedules processes. Master data (materials, BOM) originates in ERP, with execution layers only reading synchronized updates.
How to implement: Sequence of deployment and acceptance testingImplementation sequence
- Master data governance : Clean up BOM versions, process routes, unit conversions, and safety stock all at once.
- Refine inventory status : Pending inspection/available/reserved/frozen—only then proceed to run MRP.
- Reservation rules : From sales order → reservation → work order allocation, ensuring one product line runs smoothly.
- Material availability and work reporting : Material availability checks serve as the gatekeeper for production starts, while work reporting updates finished goods inventory.
- Dashboards and early warnings : Shortage alerts and delivery-date risks are automatically pushed to planning and sales teams.
Acceptance criteria
- Any work order’s material availability status can be checked in real time , with shortage lists linked to ongoing procurement efforts.
- When sales check order availability, the data matches the warehouse’s pickable quantity (after configuration rules are set).
- Delay in reporting work until finished goods are saleable <1 hour(under normal procedures).
Plan changes and rush orders
Rush orders are commonplace in manufacturing: After an emergency order is inserted, material availability checks should automatically recalculate all affected work orders’ available start dates and shortage lists, instead of waiting for planners to manually rearrange Excel spreadsheets. The system must record each instance of “displacement”—which work order was delayed, by how much, and whether the customer was notified—to prevent sales and production from talking past each other.
Common pitfalls
MRP treated as a black box : Not accounting for pending inspections or reservations, resulting in unreliable procurement recommendations. Material availability checks only produce reports, not enforce gates : Shortages still allow production to start, making on-site stoppages even more chaotic. Multiple warehouses lack unified visibility : Raw materials stored in the central warehouse, while line-side materials sit in workshops, yet material availability checks only examine the central warehouse. Work reporting and warehousing are disconnected : Completed quantities and sales’ available stock remain mismatched over long periods.
Only when inventory, work orders, material availability, and work reporting are seamlessly linked into a single chain can enterprises upgrade from “each module has its own data” to “order delivery becomes predictable.”
Shandong XYN Information Technology Co., Ltd. (XYN Tech) delivers digital and intelligent systems related to ERP production, inventory management, and shop-floor execution, covering master data governance, reservation allocation, bill-of-materials logic, and integration with MES/WMS. For more details, please refer to xynadmin.com and About Us.