SELECT ACCOUNT.id AS acct_id,
    ACCOUNT.acctnumber AS acct_code,
    SUM(TransactionAccountingLine.netamount) AS acct_balance
FROM TRANSACTION,
    ACCOUNT,
    TransactionAccountingLine,
    transactionLine
WHERE TransactionAccountingLine.ACCOUNT = ACCOUNT.ID(+)
    AND transactionLine.TRANSACTION = TransactionAccountingLine.TRANSACTION
    AND transactionLine.ID = TransactionAccountingLine.transactionline
    AND TRUNC(TRANSACTION.trandate) <= TO_DATE('2021-01-31', 'YYYY-MM-DD')
    AND TRANSACTION.ID = transactionLine.TRANSACTION
    AND ACCOUNT.isinactive = 'F'
    AND TRANSACTION.posting = 'T'
    AND ACCOUNT.ID IS NOT NULL
    AND ACCOUNT.issummary = 'F'
GROUP BY (ACCOUNT.id, ACCOUNT.acctnumber)

UNION ALL

SELECT
	BUILTIN.DF( Status ) AS StatusName,
	COUNT( * ) AS TransactionCount,
	SUM( ForeignTotal ) AS TotalAmount
FROM 
	Transaction 
WHERE 
	( Type = 'SalesOrd' )
GROUP BY
	ROLLUP( BUILTIN.DF( Status ) )

SELECT
	Transaction.TranID,
	Transaction.TranDate AS date,
	Transaction.duedate AS due_date,
	Transaction.foreigntotal as total,
	Transaction.foreignamountunpaid AS amount_paid,
	Transaction.foreignamountpaid AS remaining_balance,
	BUILTIN.DF( Transaction.Status ) AS Status,
FROM
	Transaction
	INNER JOIN Entity ON
		( Entity.ID = Transaction.Entity )
WHERE
	Transaction.Type = 'CustInvc' AND Entity.Id = 23268

{
  "custentity_date_field": "7/13/2021 11:00:00"
}

Unable to parse value '7/13/2021 11:00:00' (String) from the DateTime,ZonedDateTime field (custentity_date_field).

transactionline.mainline = 'T'

SELECT * FROM (SELECT tranid FROM transaction	 where type='SalesOrd' group by tranid) ORDER BY tranid

SELECT * FROM Item WHERE Subsidiary = '1'