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

I have a Sales Order with 2 lines on the screen. When I use SuiteQL, it return 12 transactionline. Is there's a "trick" to return only the 2 lines  ?
I tried
AND mainline = 'F'
 AND taxline = 'F'
AND donotdisplayline ='F'
.
.
.
Any idea ?

Are you doing joins and whatnot?  you may have to set mainline to F for other records.

the statement looks like this
SELECT sum(COALESCE(quantity,0) *-1) AS requested,sum (COALESCE(quantitypacked,0)) AS packed
            FROM  TransactionLine
            WHERE TransactionLine.Transaction = " + results[jj]['id']
             AND mainline = 'F'
             AND taxline = 'F'
             AND donotdisplayline ='F'

It's returning more lines than on the screen

Sum() without GROUP, doesn't look like a complete statement.