SuiteQL Query Library

Items: Summarized by Type

Returns the number of active items group by item type.

-- Contributor: Tim Dietrich (timdietrich@me.com)
SELECT
	ItemType,
	COUNT( ID ) AS ItemCount
FROM
	Item
WHERE
	IsInactive = 'F'
GROUP BY
	ItemType
ORDER BY
	ItemType

← Back to Query Library