Identifying NetSuite Accounts payable open invoices for reporting
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?
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.
sql query used on netsuite tables imported into the data warehouse
Sorry, I don’t. I will delete my answer and allow someone else to answer.
yeah – those filters seem to be correct, when compared to the NetSuite “stock” AP aging report
