How to filter out deleted transactions from NS Transactions table?


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 (
I Couldn’t find any identification in the Transactions table for deleted transactions.
I tried using the System_notes table after reading this thread:, 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.


Rookie Asked on June 18, 2020 in How To's.
Add Comment
4 Answer(s)

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

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

Hi..just curious to know what method are you using to fetch the records from netsuite backend tables say REST or SOAP or RESTLET ?, and are you trying to fetch just the transactions or individual record types also like invoice, accounts, customers etc There are different mechanisms to fetch deleted records based on the integration method we use.

Rookie Answered on July 22, 2020.
Add Comment

‘DELETE’ is logged as Action in TRANSACTION_HISTORY table

Rookie Answered on May 22, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor