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

There is a “deleted record” type of saved search, maybe you could run that and cross reference between the two?

Intermediate Answered on June 18, 2020.

Thanks, but I need an automatic solution that won’t relay on data I periodically manually download from the UI and integrate onto our data base.

on June 18, 2020.
Add Comment

Your Answer

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