SuiteQL Query Library

Items: Returned Items by Date Range

Returns a list of items that were returned the most frequently in the previous year.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-returned-items/
SELECT
	TransactionLine.Item,
	BUILTIN.DF( TransactionLine.Item ) AS ItemName,
	Item.Manufacturer,
	SUM( TransactionLine.Quantity ) AS TotalQuantityReturned
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
	INNER JOIN Item ON
		( Item.ID = TransactionLine.Item )
WHERE
	( Transaction.Type = 'RtnAuth' )
	AND ( Transaction.Void = 'F' )
	AND ( Transaction.Voided = 'F' )
	AND ( Transaction.TranDate BETWEEN BUILTIN.RELATIVE_RANGES( 'LY', 'START' ) AND BUILTIN.RELATIVE_RANGES( 'LY', 'END' )  ) 
GROUP BY
	Item,
	BUILTIN.DF( TransactionLine.Item ),
	Manufacturer
HAVING
	SUM( TransactionLine.Quantity ) > 0 
ORDER BY
	TotalQuantityReturned DESC,
	ItemName ASC

← Back to Query Library