I have a strange one, I have a transaction (Journal entry) with 5 lines. I created a Suiteql, see below -------------------------------------------------------- SELECT transaction.id,postingperiod, tranid, subsidiary, trandate,approvalstatus FROM transaction INNER JOIN TransactionLine ON TransactionLine.Transaction = Transaction.ID AND TransactionLine.MainLine = 'T' WHERE transaction.id = 2573458 --------------------------------------------------------------------------- It return 2 lines !!! It should return 1 line . TransactionLine.MainLine = 'T' Any idea of what is going on ?

I assume it is because JEs don't have a mainline in the common sense of the word. all the other tran types have an account at the header level and an assumption of credit/debit to/from some other account as setup in accounting prefernces for that tran type. JEs don't have any restrictions or assumptions like that so there is no amount at the header level, or account at the header level all that only exists on the lines for JEs

Instead of

mainline = 'T'

for journal entries, you can try

linesequencenumber = 0

which should approximate the

mainline

option of other transactions. https://netsuite.smash-ict.com/understand-line-id-vs-line-sequence-number-in-netsuite-transactions/

Wow. Never knew that. And the article is VERY well done.