Hi all 👋 I’m new to NetSuite so I hope I’m in the right channel, if not, please direct me to the right place. 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!

You want to ask in #C2A1ZEMF0 if you are using suiteanalytics connect

thanks