SuiteQL Query Library

Items: Item Types and Counts

Returns a list of the types of items that are setup, and the count for each item type.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-item-types-counts/
SELECT
   ItemType,
   COUNT(*) AS ItemCount
FROM
   Item
GROUP BY
   ItemType
ORDER BY
   ItemType

← Back to Query Library