Sales Order: With Sales Tax

Returns header-level values for a specified Sales Order, including the Tax Total value sourced from the related TransactionLine records.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-sales-tax/
SELECT
	Transaction.TranID,
	Transaction.TranDate,
	Transaction.Entity AS CustomerID,
	BUILTIN.DF( Transaction.Entity ) AS CustomerName,
	BUILTIN.DF( Transaction.Status ) AS Status,
	Transaction.ForeignTotal AS Total,
	( 
		SELECT 
			SUM( TransactionLine.ForeignAmount * -1 ) AS SalesTax 
		FROM
			TransactionLine 
		WHERE
			( TransactionLine.Transaction = Transaction.ID )
			AND ( TransactionLine.TaxLine = 'T' )
	) AS SalesTax
FROM 
	Transaction
WHERE 
	( Transaction.Type = 'SalesOrd' )
	AND ( Transaction.ID = 11708 )

Click here to return to the list of available queries.