NetSuiteFree worksheetPDF, Excel, Word exportNetSuiteDiscrete Manufacturing

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.

Download:

Free stock	Short now	Short after POs
180	60	60
700	0	0
10	50	0
0	60	60
90	30	0
450	0	0

Total short now

200

Total short after POs

120

Lines reviewed

Short now as share of required

18.5%

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.

Talk to an Expert Explore More Free Tools

Related Tools

NetSuite

More NetSuite tools

See all

Back to All Tools