Returns Authorizations: Summarized by Item

Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range, summarized by item.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-return-authorizations/
SELECT
	Item.ItemID,
	Item.Description,
	Count(*) AS RMACount
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
	INNER JOIN Item ON
		( Item.ID = TransactionLine.Item )
WHERE
	( Transaction.Type = 'RtnAuth' )
	AND ( Transaction.TranDate BETWEEN TO_DATE('2020-01-01', 'YYYY-MM-DD' ) AND TO_DATE('2020-11-30', 'YYYY-MM-DD' ) )	
	AND ( Transaction.Voided = 'F' )
GROUP BY
	Item.ItemID,
	Item.Description
ORDER BY
	RMACount DESC,
	Item.ItemID

Click here to return to the list of available queries.