Mass data deletion from NetSuite

Hello Everyone!


Today’s issue is related to cleaning a client account of test and unwanted items/transaction without manually deleting them one by one. NetSuite provides a Mass Deletion within Lists-> Mass Updates tab as you can see below.




The problem with this is that not everything can be mass deleted, for example you can mass delete Reports but you cannot do the same for Transactions. (see below pic)


Fortunately we at KEYSTONE DATA have the solution which can be customized to your needs.

  1. Create a Saved Search by the criteria you want.
  2. Implement a script which will delete all items from the Saved Search.

Please bear in mind that the maximum items/transaction that you can delete in the same time in NetSuite is 1000, thus if you would like to delete 10 000 items/transactions you just need to make the script loop(scheduled).


I hope this was helpful, have a nice day!