Searching for Deleted Records

For some records, when the record is deleted, NetSuite retains some general data about it.

You can find deletion details using several methods depending on the data source your record uses. For information about data sources, see The Analytics Data Source and SuiteAnalytics Workbook.

• Records that use the old data source – These records use the old data source that was designed for saved searches and reports. To search for deleted records of this type, you can use the Deleted Record search type. For more information, see Searching Deleted Records That Use the Old Data Source.

  Note:

  In addition, for record types that support System Notes v2, system notes retain all information for deleted records. For more information about viewing and searching system notes v2, see System Notes v2 Overview.

• Records that use the new analytics data source – These records use the new analytics data source that was designed for SuiteAnalytics Workbook. To search for deleted records of this type, you can use a SuiteQL query in either SuiteScript or SuiteAnalytics Connect.

  Note that you must have the NetSuite Analytics Warehouse feature enabled to search for deleted records that use the new analytics data source. For more information, see Searching for Deleted Records That Use the New Analytics Data Source.

The following tables list the records of each type that support deletion tracking. NetSuite creates a deletion log for deletion instances of these records. The log provides basic information about the deleted record. The information is searchable.

Old Data Source Records
account	invoice group
accounting book	item account mapping
accounting period	item collection
advanced intercompany journal entry	item-item collection relationship
allocation schedule	item demand plan
amortization schedule	item location configuration
analytical impact	item process family
budget deletion tracking	item process group
billing account	item revision
billing class	item supply plan
bin number record	location
bill of materials	manufacturing cost template
bill of materials revision	manufacturing operation task
bill of materials component	manufacturing routing
bonus	media item
bonus type	merchandising hierarchy level
bundle	merchandising hierarchy node
buying reason	merchandising hierarchy version
buying time frame	monthly quota
cardholder authentication	nexus
case issue	note type
care origin	order allocation strategy
case priority	order type
case status	other name
case type	other name category
category	overtime policy
billing revenue event type	overtime policy basic rule
billing schedule	partner
bill of distribution	payment method
boost type	payment processing profile
budget	payroll item
charge	units for pick decomposition
charge rule	pick strategy
charge type	pick task
classification	planned order
CMS content	planned standard cost
CMS content type	planning item category
CMS page	planning item group
CMS page type	planning rule group
CMS site map	planning workbench view
commerce catalog	price book
commerce category	price type
classification	pricing group
competitor	project expense type
contact	promotion code instance (coupon code)
contact type	quantity pricing schedule
cost category	rate plan
crm message	resource group
coupon code	revenue element
currency	revenue plan
currency exchange rate	revenue recognition field mapping
custjob	rule (gain loss account mapping, recognition treatment rule, transaction accounting rule)
custom list definition	sales readiness
customer category	subscription change order
customer message	subscription line
customer- subsidiary relationship	subscription line revision
custom record	script deployment
custom segment	script
custom record entry	standard cost version
customer referral code (promotion code)	statistical journal
department	subscription
distribution network	subscription change order
document folder	subscription online
employee	subsidiary
employee status	supply chain snapshot
employee type	supply change order
entity account mapping	supply planning
entity group	terms
entity status (job status and customer status)	time code
event	time code subsidiary mapping
expense category	time line track (time tracking, time entry, manufacturing planned time)
fulfillment exception reasons	time-off change
generic resource	time-off request
global account mapping	timesheet
global inventory relationship	transaction
impact subcategory	treatment
inbound shipment	units type
incoterm	usage
intercompany allocation schedule	user notes
intercompany journal entry	vendor
inventory cost template	vendor category
inventory item	vendor-subsidiary relationship
inventory number	win/loss reason
inventory status	workflow
—	workflow definition
—	zone

New Analytics Data Source Records
billing account billing schedule
billing class
bin
charge run
campaign event
campaign email template/online form template
customer subsidiary relationship
custom field
custom record type
default campaign event
direct mail campaign event
drip campaign event
email campaign event
generic resource
incoterm
memorized transaction template
other campaign event
price book
pricing group
quantity pricing schedule
schedule work item
shipping package
subscription line revision
transaction address mapping
transaction line address mapping
usage
vendor category

Querying a Dataset or Workbook for Deleted Records

Administrators can use the Deleted Records type in Analytics to track deleted records. Datasets can include the Deleted Records as the root record and you can create a dataset or workbook to track deleted records. For more information, see Defining a Dataset and Creating a Workbook.

Related Topics

• Auditing Data Changes using Searches
• Searching System Notes
• Viewing an Audit Trail for a Record Type
• Understanding the Context for Changes

General Notices