The quick answer
Open Reports > Inventory/Items > Inventory Turnover. Confirm the period shown in the footer, then read Cost, Average Value, Turnover Rate, and Average Days on Hand together. Low turnover can identify an item worth investigating, but it does not prove excess stock.
The person, company, items, month, and figures shown here are fictional example data. This walkthrough reads one monthly report; it does not change dates or save a shortlist.
Before you start
Inventory must be enabled, and your role needs access to Inventory Turnover and the relevant inventory data. In OneWorld, results depend on your role and subsidiary restrictions. If NetSuite displays Subsidiary Restrict View Required, resolve that view requirement before running the report. This walkthrough begins with report access already available.
01 · Open Inventory Turnover
Go to Reports > Inventory/Items > Inventory Turnover. Check the title. This example shows Item and Description, followed by Cost, Average Value, Turnover Rate, and Average Days on Hand. The example rows sit in the Assembly group.
02 · Check the displayed month
Read the footer before interpreting the numbers. This is a monthly date range, not an accounting-period selection. In this example, Date says this month, and From and To both show 09/2026. The example month is September 2026. Keep the displayed period unchanged while comparing rows.
03 · Compare two rows
Control Assembly has Cost $600.00, Average Value $20,000.00, Turnover Rate 0.03, and Average Days on Hand 1,000.00. Monitor Assembly has Cost $900.00, Average Value $3,000.00, Turnover Rate 0.30, and Average Days on Hand 100.00 for the same month.
Cost represents cost of sales for the period. Turnover divides that cost by average inventory value. Control Assembly has lower turnover relative to its inventory value in this example. Check its demand, stocking purpose, and transaction history before deciding whether its stock is excessive.
Read Average Days on Hand directly from the report. Calculating it from the rounded rate can give a different answer, and it does not predict a guaranteed stockout date.
04 · Inspect a zero-cost row
Service Assembly, the third row, shows Cost $0.00, Average Value $6,000.00, Turnover Rate 0.00, and blank Average Days on Hand.
A zero-cost row does not prove the item never sold or has no inventory. Check the period, transaction activity, and costing context. Treat zero Cost, blank Average Days on Hand, and zero or blank Average Value as separate cases. A ratio with an unusable denominator cannot support a normal comparison.
The completed review leaves the same report visible. You should be able to identify the month, explain why the first two rows differ, and recognize why the zero-cost row needs follow-up. No purchasing or inventory setting changes here.
Common questions
How is turnover calculated?
Turnover Rate divides Cost by Average Value for the displayed range. In the example, $600 divided by $20,000 gives 0.03. It is a cost-based measure, not a count of units moved.
What does Average Days on Hand mean?
It relates the number of days in the selected range to turnover. The example’s 30-day month and 0.30 rate give 100 days. Read the report’s displayed result because rounded rates can distort a recalculation. It is not a guaranteed stockout date.
Why can turnover be zero while days on hand is blank?
The example has zero Cost and positive Average Value, with 0.00 turnover and blank days on hand. Check the reporting range and costing context before interpreting it. Zero cost does not prove there was no physical inventory movement or that the item never sold.
Does low turnover prove an item is overstocked?
No. Low turnover can prompt a review of demand, stocking purpose, seasonality, and transaction history. Use those details before changing purchasing or replenishment settings.