This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Do I need Suite Analytics Connect to get the DeletedRecord table via SuiteQL?

&gt;*AI generated answer (using internal Slack threads):*
Yes, you do need Suite Analytics Connect to get the DeletedRecord table via SuiteQL. Suite Analytics Connect provides ODBC access to your NetSuite data, allowing you to create complex reports and queries using SQL. The DeletedRecord table is part of the NetSuite database and can be accessed using SuiteQL via Suite Analytics Connect. This table contains information about records that have been deleted from the system, including the ID of the employee who deleted the record.

Here is an example of a SuiteQL query that can be used to retrieve data from the DeletedRecord table:

```sql
SELECT * FROM DeletedRecord WHERE DeletedDate &gt; TO_DATE ( '2021-07-27', 'YYYY-MM-DD' )
```

This query will return all records that were deleted after July 27, 2021.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1627408083323900|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.817618132

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C2K2RJNAC/p1592481591232500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.817098856

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1587456420279500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.816049874



Please provide your feedback on this answer.