RE: 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.


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

‘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.