SuiteQL Query Library

Sales Orders: Top Orders for the Current Day

Returns the top sales orders of the day, based on the estimated gross profit.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-sales-related-queries/
SELECT * FROM
(
	SELECT
		Transaction.TranID,
		Transaction.TranDate,
		Transaction.ShipDate AS ScheduledShipDate,
		Transaction.ActualShipDate,
		Transaction.ForeignTotal,
		Transaction.TotalCostEstimate,
		Transaction.EstGrossProfit,
		ROUND( ( Transaction.EstGrossProfitPercent * 100 ), 2 ) AS GPPct,
		Employee.LastName,
		Employee.FirstName,
		BUILTIN.DF( Transaction.Entity ) AS Customer
	FROM
		Transaction
		INNER JOIN Employee ON
			( Employee.ID = Transaction.Employee )		
	WHERE
		( Transaction.Type = 'SalesOrd' )
		AND ( Transaction.TranDate BETWEEN TO_DATE( '2020-11-01', 'YYYY-MM-DD' ) AND TO_DATE( '2020-11-30', 'YYYY-MM-DD' ) )
		AND ( Transaction.Voided = 'F' )
	ORDER BY
		Transaction.EstGrossProfit DESC
)
WHERE
	ROWNUM <= 5

← Back to Query Library