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?
Best answer
Logically thinking from my understanding, its correct, you are excluding paid in full status on account payables that aren’t non-posting. No date range specified which is fine.
In a general hierarchical structure then account payables is the first filter you normally specify as thats the account you’re working but shouldn’t matter in an AND statement. If you try that and the results are the same as your initial filters then its ought to be okay. Let us know how you get on.
