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

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

Your Answer

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