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

Anyone have a nice clean way to get the Invoice summary lines via SuiteQL. I am doing this and able to get Total and Tax Total. 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 TaxTotal

FROM

    Transaction

WHERE

 Transaction.ID = 8799892