Items: Customers That Purchased A Specific Item

Returns a list of customers that purchased a specified item.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-customers-by-address-and-purchase-history/
SELECT DISTINCT
	Customer.LastName,
	Customer.FirstName,
	Customer.Email,
	EntityAddress.Addr1,
	EntityAddress.Addr2,
	EntityAddress.Addr3,
	EntityAddress.City,
	EntityAddress.State,
	EntityAddress.Zip
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
	INNER JOIN Customer ON
		( Customer.ID = Transaction.Entity )
	INNER JOIN EntityAddress ON
		( EntityAddress.nKey = Customer.DefaultShippingAddress )
WHERE
	( Transaction.Type = 'SalesOrd' )	
	AND ( TransactionLine.Item = 8919 )
	AND ( Customer.IsInactive = 'F' )

Click here to return to the list of available queries.