01
About this report
Today's stock position, one row per active item and location with a quantity on hand, committed or on order. Each row gives on hand, committed to orders, available, on order from vendors, the average cost, and the on-hand value NetSuite records for that location, in base currency.
Filter on Location for one warehouse, or on Item to see where an item is held.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Item | Description | Location | On hand | Committed | Available | On order | Average cost | On-hand value |
|---|---|---|---|---|---|---|---|---|
| BRK-40 | Steel bracket 40mm | Main Warehouse | 1,240 | 300 | 940 | 200 | 9.20 | 11,408 |
| BRK-40 | Steel bracket 40mm | West Distribution Center | 310 | 0 | 310 | 0 | 9.20 | 2,852 |
| CTL-V3 | Controller board v3 | Main Warehouse | 42 | 40 | 2 | 120 | 88 | 3,696 |
| HNG-KIT | Hinge kit | Main Warehouse | 0 | 150 | -150 | 750 | 6.25 | 0 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT i.itemid AS item,
i.displayname AS description,
BUILTIN.DF(a.location) AS location,
a.quantityonhand AS on_hand,
a.quantitycommitted AS committed,
a.quantityavailable AS available,
a.quantityonorder AS on_order,
a.averagecostmli AS avg_cost,
a.onhandvaluemli AS value
FROM aggregateitemlocation a
JOIN item i ON i.id = a.item
WHERE i.isinactive = 'F'
AND (NVL(a.quantityonhand, 0) <> 0 OR NVL(a.quantitycommitted, 0) <> 0 OR NVL(a.quantityonorder, 0) <> 0)
ORDER BY i.itemid, location