RE: How to filter out deleted transactions from NS Transactions table?

Hi!

I’m pulling data from a few NetSuite back-end tables into Snowflake. I’ve noticed that deleted transactions do not show up in the UI interface, but are still included in the Transactions back-end table (https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/odbc/record/transaction.html).
I Couldn’t find any identification in the Transactions table for deleted transactions.
I tried using the System_notes table after reading this thread: https://stackoverflow.com/questions/46433007/how-to-identify-deleted-transactions-in-the-netsuite-transactions-table, but no deleted transactions show up in the System_notes table.
Does someone know how to identify and filter out deleted transactions when pulling data from NS back-end tables? This process needs to be fully automatic, not a one-time manual filtration, as I try to recreate a P&L NetSuite report outside NetSuite.

Thanks

shimon Rookie Asked on June 18, 2020 in How To's.
Add Comment
3 Answers

Have you tried taking out “inactives”? I’ve been using the SuiteAnalytics tool for a while now and haven’t noticed deleted transactions showing up in my data, so perhaps they get marked as “inactives”?

Rookie Answered on June 18, 2020.
Add Comment

Your Answer

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