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?
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.