If your company runs on NetSuite and you have a need to mass delete several records in your system, you will find this technique very helpful.
Note that your role must have the "full" permission level in order to delete a record. Additional required permissions include Setup > Delete Records permission.
The result set should only include one record type. For example you cannot use this technique when your results set includes different record types such as both Vendors and Customers.
Once you are sure, hit the DELETE key on your keyboard. If you have the "Delete Reasons" feature enabled, you may be asked to provide a note as to why you are deleting the records. If not - the system will immediately try to delete all the records in your selection.
If some or any of the records in your selection have related or dependent records, the system will fail to make the deletion in the same way it would fail if you tried while deleting a single record from the master record page in edit mode. You will have to investigate any remaining records and diagnose any issues one by one.
I hope you find this quick technique helpful. There are a few other built-in methods to deleting multiple records at once including utilizing NetSuite's Mass Update area. At this time, there are limitations to marketing and CRM-type records. We'll typically use one of our tried and true Map/Reduce scripts for more complex jobs where conditional logic may be executed over thousands to millions of records at once.
NetSuite equips you with a comprehensive set of tools to maximize the efficiency of your software investment, benefiting both your team and the broader business. If you require expert NetSuite assistance, in process optimization, development or training, please feel free to contact us.
Here's what we've been up to recently.
This article is relevant to you if you are running your business on Oracle NetSuite and would like to add an isolated custom note on a transaction line. This article demonstrates a simple end to end architecture to customize and extend the capabilities of NetSuite.
This article will be relevant for you if your company is using NetSuite ERP, uses standard inventory items and a new business requirement arises where you now need the functionality of Serialized or Matrix for an existing item.
From us to your inbox.
