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

<@UN8UBEXK2> Try something like this:
```SELECT
	Transaction.ID,
	Transaction.TranID,
	Transaction.TranDate,
	BUILTIN.DF( Transaction.Entity ) AS Customer,
	Transaction.ForeignTotal AS TotalAmount,
	Transaction.ForeignAmountUnpaid AS BalanceDue,
	REPLACE( BUILTIN.DF( Status ), 'Invoice : ', '' ) AS Status,
	Transaction.DueDate,
	TransactionLine.CreatedFrom AS SalesOrderID
FROM
	Transaction		
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
		AND ( TransactionLine.MainLine = 'T' )
WHERE
	( Transaction.TranDate &gt;= TRUNC( SYSDATE ) )
	AND ( Transaction.Type = 'CustInvc' )```
