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

Hi everyone, is there a quick way to delete all financial/inventory transactions in sandbox?

The quickest way without writing a pretty involved script is to create a mass update script. There's definitely a quicker way if you're pretty good with suitescript. If you're not, I can send you the code snippet that I wrote to delete transactions

This requires that you delete transactions in a specific order so you have to run the mass update script for each transaction type

Thanks <@U015L7ELL5Q>, went without any scripting and just did it manually. Sad day

here's the code just in case you ever need to do this again

```function delete_records(rec_type, rec_id)
{
  try {
	nlapiDeleteRecord(rec_type, rec_id); // Delete record
  } catch (err) {
    nlapiLogExecution('ERROR', rec_id);
  }
}```

Just build the search for the mass update and include the record type and id. Be sure to set the criteria correctly if you're not trying to delete all transactions