NetSuite Work Order Component Shortage Worksheet
Planners often export component data from NetSuite and then work out in a spreadsheet which work orders cannot start. This worksheet does that calculation row by row: free stock, shortage now and shortage after open purchase orders.
| Work order | Component | Required | On hand | Committed elsewhere | On order | Free stock | Short now | Short after POs | Needed by | |
|---|---|---|---|---|---|---|---|---|---|---|
180 | 60 | 60 | ||||||||
700 | 0 | 0 | ||||||||
10 | 50 | 0 | ||||||||
0 | 60 | 60 | ||||||||
90 | 30 | 0 | ||||||||
450 | 0 | 0 |
If your committed quantity already includes the quantity committed to the work order you are analysing, subtract that amount first or you will double count the demand. On order does not guarantee timing, so also compare PO due dates with the needed by date.
Automate the daily shortage list?
Ask for a short review of how this check could run automatically from your NetSuite data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add a row per work order component. Enter the required quantity from the work order, on hand and committed from an inventory report or saved search, and on order from open purchase orders. The sheet calculates free stock, what is short today and what would still be short once all open purchase orders arrive. Export to Excel to share with buyers.
- Use a saved search on the work order components sublist for required quantity
- Pull on hand and committed from an inventory status report
- Enter committed to other demand, not to this work order
- Set needed by dates so buyers can chase the earliest first
The formulas
Free stock is on hand minus committed elsewhere, never below zero. Short now is the required quantity minus free stock, never below zero. Short after POs subtracts the on order quantity as well. These are simple net requirement calculations, the same logic MRP applies, but without lead times or safety stock, so treat the result as a quick triage.
Reading the result
A line with short now above zero and short after POs at zero is covered by an open order, so the action is to confirm the delivery date. A line that remains short after POs needs a new purchase, expedite or an engineering substitute. In the example rows, the harness has no stock and no order, which is the line a buyer should chase first.
Common mistakes
Double counting commitments is the most common error, followed by ignoring location, since on hand is per location and a shortage at the plant is not solved by stock at another warehouse. Also remember that substitute components and phantom assemblies change the demand picture.
Frequently Asked Questions
Does NetSuite already show component availability?
Yes, work orders show component availability and there are standard reports for it. This worksheet is useful for quick what-if work, for combining data from several sources, or for sharing a clean list with buyers who do not use NetSuite.
Why is committed elsewhere separate?
Committed stock may already be promised to other work orders or sales orders. Subtracting it from on hand gives the quantity genuinely free for the work order you are checking, which avoids promising the same parts twice.
Should I include safety stock?
You can, by reducing free stock manually or adding the safety quantity to required. The worksheet keeps the logic transparent, so adjust the inputs to match your policy rather than hiding it in a formula.
Can I load many rows?
You can add rows and export to Excel, but the worksheet is built for a working list of a few dozen lines. For a plant wide view use a saved search or a reporting tool connected to NetSuite.
If this check is something you run every morning, we can help you automate it from NetSuite data so the shortage list is ready before the shift starts.
Related Tools
NetSuite Manufacturing and Item Record Types Reference
Find the record id for assembly items, BOMs, revisions, routings and the manufacturing transactions, with a note on what each is for.
NetSuiteNetSuite Transaction Type Codes Reference
Look up the short type code stored in transaction.type for common NetSuite transactions, with the matching record id.
NetSuiteNetSuite Manufacturing Go-Live Checklist
A 30 item checklist covering data, setup, costing, inventory, roles and cutover before you run production in NetSuite.
NetSuiteNetSuite Manufacturing Process Maturity Assessment
Answer ten questions about BOM accuracy, shop floor posting, costing and reporting to see where your NetSuite manufacturing setup is strong or weak.
More NetSuite tools
See all- NetSuite Work Order Status Reference
- NetSuite Assembly Build Checklist
- NetSuite BOM Revision Change Request Template
- NetSuite Routing Operation Cost Worksheet
- NetSuite Component Yield and Scrap Requirement Calculator
- NetSuite Saved Search Formula Generator
- NetSuite CSV Import Template Guide
- NetSuite Role Permission Matrix Worksheet
- NetSuite Inventory Costing Method Reference
New to NetSuite? Start with the NetSuite guide and toolkit, or plan with NetSuite Cost Calculator, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- NetSuite Component Yield and Scrap Requirement CalculatorWork out how much of a component a work order really needs once yield loss and setup scrap are included, and what you are short.
- NetSuite Work Order Status ReferenceLookup table of NetSuite work order statuses and the transactions and records around them, with what each one means and what to check.
- NetSuite Work Order Labor Variance CalculatorBreak labor variance on completed work orders into a rate variance and an efficiency variance and read labor efficiency.
ERP fixes and how-tos
- How to create an assembly build or work order in NetSuiteHow to build assembly items in NetSuite: when to use a simple Assembly Build versus a Work Order, BOM setup, component availability, and completion steps.
- NetSuite Manufacturing Mobile: shop floor work orders and requirementsWhat the NetSuite Manufacturing Mobile app does for shop floor work orders, what features and roles it needs, how to enable it and where it falls short.
- How to Set Up Routings and WIP in NetSuite ManufacturingSet up manufacturing routings, work centers and WIP in NetSuite: cost templates, operation tasks, work order issue and completion, and why WIP will not clear.
Runs with your ERP
- NetSuite Connector for ADP Workforce Now (First-Party)Oracle's first-party NetSuite connector for ADP Workforce Now syncs employees, payroll journals and paychecks, with Labor Cost Insights. Setup and pitfalls.
- NetSuite CPQ: Configurator and Manufacturing SuiteApps with work ordersHow NetSuite CPQ SuiteApps configure complex items on transactions and create work orders from configured materials and routing. Setup, pitfalls and AI uses.
- NetSuite Field Service Management (formerly NextService) for equipment manufacturersWhat NetSuite Field Service Management, formerly NextService, offers equipment makers: scheduling, dispatch, mobile app, asset history and work orders, plus setup tips.
AI on your ERP
- AI agents for NetSuite manufacturing operationsAI agents for NetSuite manufacturing: WIP tracking, routing exceptions, and work order status grounded in SuiteQL, with human approval on anything that writes back.
- NetSuite Procurement With AI for Purchase Orders, Receipts and Vendor BillsAI for NetSuite procurement: query purchase orders, item receipts and vendor bills with SuiteQL, flag three-way match breaks, and draft vendor follow-ups.
Integrations
- How to add AI agents to Oracle NetSuiteHow to add AI agents to Oracle NetSuite: SuiteQL and REST tool layer, RESTlet writes, role-scoped tokens, human approval, and where a private model fits.
- How to use ChatGPT with Oracle NetSuiteConnect ChatGPT to Oracle NetSuite: custom GPT actions, exports versus live access, enterprise data controls, and when a private model is the safer choice.