Delete Records From NetSuite Using Saved Search

To delete records using saved searches in NetSuite, you'll need to follow the following steps:

Create a Saved Search:

a. Go to Customization > Lists & Records > Saved Searches.

b. Click New.

c. Choose the appropriate record type (Transaction).

d. Define your search criteria to filter down to the records

-To specify the record types choose “Type” then choose the transaction type (Invoices, payments, journals or any other type) you want to delete

- One Important criteria here is to add the “System Notes Fields..” and add “Context” as a filter then choose “Script (RESTlet)”

e. Make sure that only the records that you want to delete are on this saved search

f. Save the search.

Use the Saved Search to Identify Records:

a. Run the saved search.

b. This will display a list of records that match your criteria.

Delete the records:

a. Go to Customization > Scripting > Script Deployment.

b. Choose the following Script “TF | Mass Record Delete (MR)” (You might have deferent versions here kindly choose the last version).

c. Click View on the script deployment record then click edit.

d. Make sure that the deployment is a single event

e. Go to the parameters, on the saves search add the search that you have created.

f. Click on the arrow next to the save button and choose “Save and Execute”. (You might need to repeat this step second time in order to delete all of the records)