RE: Identifying NetSuite Accounts payable open invoices for reporting
Answered
WHERE
STATUS <> ‘Paid In Full’
AND IS_ACCOUNTS_PAYABLE = TRUE
AND is_non_posting = ‘No’
In the above, I am filtering the transactions and transaction_lines tables.
Does anyone know if the above filters are correct?
yeah – those filters seem to be correct, when compared to the NetSuite “stock” AP aging report
