When NetSuite shows stock on hand but a lower available quantity, start by comparing the same item, location, unit, and moment in time. On hand describes inventory recorded as stocked. Committed quantity represents inventory assigned to outstanding demand. Available quantity describes what remains eligible for commitment in the view you are using. Inventory status and picking activity can make a simple subtraction misleading.
The practical goal is to build a quantity bridge that explains every unit before promising stock or posting an adjustment. A warehouse-wide number, a lot-level inventory balance, and a sales-order line can all be correct while answering different questions.
Write the scope above your reconciliation. Include the item internal reference, subsidiary where relevant, warehouse location, units of measure, and capture time. Add bin, inventory status, and lot or serial number when those features apply. If one report shows cases and another shows individual units, convert them before investigating a variance.
Record the exact screen or search used for each number. A label alone is insufficient. The inventory balance view may expose inventory detail, while the item record provides a location summary. A saved search with transaction joins can repeat an inventory quantity across multiple rows. Adding those repeated rows creates a reporting error without any warehouse transaction being wrong.
Keep the initial comparison small. Choose one item and one location with a known open order. Reconcile that case before applying a formula to thousands of items. A small sample lets the warehouse supervisor verify what is physically present while the administrator checks transaction evidence.
For a straightforward item-location balance, available stock starts with on hand less committed stock. NetSuite does not display available quantity as a negative amount in the standard stock-level definition. A zero available quantity therefore does not prove that on hand is zero.
Inventory Status adds another distinction. Units in an unavailable-for-commitment status can remain on hand while being excluded from available stock. Supply Allocation, where enabled, can consider future supply as well. An allocation to an expected receipt does not mean those units are physically sitting in the warehouse.
Use three questions in operational conversations:
Avoid labeling all three answers “stock.” That shorthand is how a customer-service representative can promise quarantined material or assume a future purchase order is ready to ship.
A useful working bridge begins with the location's on-hand quantity, identifies unavailable-status stock, then explains eligible stock already committed or otherwise unavailable in the particular execution view. Treat this as a reconciliation worksheet, rather than a universal saved-search formula.
The categories must be mutually exclusive. Do not subtract committed units a second time when the available quantity already excludes them. Do not combine an item-level commitment figure with individual lot balances unless you understand whether that commitment has been assigned to particular lots.
For each category, retain a supporting list of transactions or inventory-detail rows. The bridge should let another person move from a total to the orders, statuses, or picks behind it. If the detail cannot be reproduced, the bridge is a hypothesis awaiting validation.
A productive exception log contains the compared values, scope, difference, evidence, and next action. Assign a reporting issue to the report owner, a missing receipt to receiving, and a status-release issue to quality. Sending every difference to accounting encourages adjustments that conceal the original cause.
Suppose a distributor records 120 individual filters at its East warehouse. Twenty are held for inspection. Of the 100 eligible units, 65 are committed to open customer orders. In this simplified example, 35 units remain available for another commitment.
The bridge is 120 on hand, comprising 20 inspection units, 65 committed eligible units, and 35 uncommitted eligible units. The inspection units have not disappeared. They remain part of the physical inventory responsibility even though customer service should not offer them for immediate shipment.
A second warehouse holds 40 eligible filters. The company total now looks generous, but an East-only order still needs a fulfillment-location decision or a transfer process. Adding the second warehouse's stock to the first warehouse's availability would hide transport time and execution restrictions.
Now assume the customer requests four cases of ten filters. That is 40 individual units, exceeding East's simplified available quantity by five. Comparing “four” to “35” would approve an order the warehouse cannot fully satisfy. The useful answer is a five-unit shortage at East, with alternative supply requiring a separate decision.
With Pick, Pack, and Ship, lot, serial, and bin-level available quantities can change when goods are picked, while on hand decreases when the fulfillment is shipped. A lot assigned on a sales order can also affect its available detail before picking. These timing differences are especially important when comparing inventory-detail views with summary quantities.
Build a small transaction timeline: order approval, commitment, lot assignment, pick, pack, and shipment. Capture balances after each relevant step in a sandbox using the same operating role as production. Do not expect every quantity column to move at the same event.
If a picker reports that goods are in staging, establish whether the fulfillment is picked, packed, or shipped. Physically leaving a storage bin is different from leaving company inventory. A report that ignores staging can suggest shrinkage even when every unit is accounted for.
First, refresh both views and capture their times. A receipt processed between exports can explain a legitimate difference. Then check location filters, inactive locations, subsidiaries, and unit conversions. These checks are faster and safer than changing inventory.
Next, inspect statuses and open commitments. Look for damaged or inspection quantities, orders awaiting cancellation cleanup, and work or transfer demand if used. Review order-line settings rather than assuming every open order commits stock in the same way.
Finally, inspect inventory detail and recent operational activity. A lot may exist at the warehouse but in a different bin or status from the one selected on a transaction. If only a customized search differs, review joins and aggregation before escalating an inventory defect.
A role restriction can hide the underlying evidence. Ask an authorized administrator to compare the same transaction under the affected role. Broadening warehouse access is not the first troubleshooting step; reproduce the problem and identify the specific permission or restriction.
Give customer service a short decision record: item, requested quantity in sales units, fulfillment location, eligible quantity, committed quantity for that order, earliest supportable ship date, and any exception owner. Include the capture time when stock changes quickly.
Train staff to distinguish “available elsewhere,” “allocated from future supply,” and “ready for this shipment.” Each requires a different customer message. A shortage queue is more useful than a single green inventory indicator when inspection or inbound timing remains unresolved.
For a persistent mismatch, CuriousRubik's NetSuite support services provide a relevant starting point for reviewing account configuration and reporting. Bring one reproducible item-location example with transaction references, rather than an unexplained screenshot of a company total.
Yes. In the standard stock-level definition, on hand includes units committed to outstanding orders. Those units are still stocked until the relevant inventory-decreasing transaction occurs. Compare the same location and unit before calculating what remains.
Eligible stock may already be committed, or on-hand units may have a status that excludes commitment. Check inventory detail and demand at the relevant location. Zero available does not establish that the warehouse contains no units.
Not safely without checking the search's grain and meaning. Lot, bin, and status balances can reflect picking or inventory-detail assignments differently. A summary commitment repeated across joined rows can produce a false shortage if subtracted repeatedly.
No. Allocation can reserve expected supply when Supply Allocation and the strategy permit it. Physical receipt, appropriate inventory detail, quality release, and warehouse readiness still need to occur before that supply can support shipment.
Investigate scope, units, timing, statuses, commitments, and search joins first. An adjustment should correct an evidenced inventory error with approval. It should not be used to force two reports with different definitions to match.