01
About this report
One row per location and item type, with the number of items in stock, the quantity on hand, the on-hand value in base currency, and each row's share of the total value. Values are the ones NetSuite holds on the item location records. Items with nothing on hand are left out.
Use it at month end to check against the inventory asset accounts, or to see which location holds the stock.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Location | Item type | Items in stock | On hand | Value | Share of value |
|---|---|---|---|---|---|
| Main Warehouse | InvtPart | 412 | 58,210 | 684,300 | 0.62 |
| Main Warehouse | Assembly | 38 | 1,120 | 201,450 | 0.18 |
| West Distribution Center | InvtPart | 205 | 17,400 | 188,900 | 0.17 |
| West Distribution Center | Assembly | 9 | 95 | 28,600 | 0.03 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT BUILTIN.DF(a.location) AS location,
i.itemtype AS item_type,
COUNT(DISTINCT a.item) AS items,
SUM(a.quantityonhand) AS on_hand,
SUM(a.onhandvaluemli) AS value,
SUM(a.onhandvaluemli) / NULLIF(SUM(SUM(a.onhandvaluemli)) OVER (), 0) AS share
FROM aggregateitemlocation a
JOIN item i ON i.id = a.item
WHERE NVL(a.quantityonhand, 0) <> 0
GROUP BY BUILTIN.DF(a.location), i.itemtype
ORDER BY value DESC04