We import netsuite data tables into snowflake, and...
# general
d
We import netsuite data tables into snowflake, and I am trying to identify NetSuite Accounts Payable open invoices. I currently have the filter based on columns in the transactions and transaction_lines tables as this below. Does anyone know if this is correct? WHERE STATUS <> 'Paid In Full' AND IS_ACCOUNTS_PAYABLE = TRUE AND is_non_posting = 'No'