Customers: Transaction Ledgers

Used for generatin a transaction ledger for a specified customer.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-customer-transaction-ledgers/
SELECT
	Transaction.TranDate,
	Transaction.ID AS Transaction,
	BUILTIN.DF( Transaction.Type ) AS Type,
	Transaction.TranID,
	Transaction.OtherRefNum,		
	Transaction.ForeignTotal,
	BUILTIN.DF( Transaction.Currency ) AS Currency,
	REPLACE( BUILTIN.DF( Transaction.Status ), BUILTIN.DF( Transaction.Type ) || ' : ', '' ) AS Status,
	BUILTIN.DF( Mainline.CreatedFrom ) AS CreatedFrom
FROM
	Transaction
	INNER JOIN TransactionLine AS Mainline ON
		( Mainline.Transaction = Transaction.ID )
		AND ( Mainline.MainLine = 'T' )	
WHERE
	( Transaction.Entity = 237 )
	AND ( Transaction.Void = 'F' )
	AND ( Transaction.Voided = 'F' )
ORDER BY
	Transaction.TranDate DESC,
	Transaction.TranID DESC

Click here to return to the list of available queries.