RE: Identifying NetSuite Accounts payable open invoices for reporting


  STATUS <> ‘Paid In Full’


  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?

ddumas Rookie Asked on March 28, 2023 in Accounting.
Add Comment
3 Answers
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.

Beginner Answered on March 29, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.