This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

One more Why the "order by tranid" doesn't work ?
SELECT tranid
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
WHERE
         TranDate = TO_DATE( TO_CHAR ( SYSDATE - 1, 'DS' ), 'DS' )
and type = 'CustInvc'
and location = 2
and taxline = 'F'
and iscogs  = 'F'
and Transaction.entity in ('712','551','1135','553','552')

group by tranid

haha I remember that issue with order by...
solution iiiiiiis : add ASC DESC
order by tranid ASC