Delete Transaction Records from Netsuite

Question

Does anybody have any sort of experience deleting test transaction records from Netsuite. Right now what I can see is, going to each customer record and delete specific Sales Orders/CashSales/Journals which is a quite painful task(with large volume of data). Is there any other way that I'm unaware of ? Any help would be appreciated.

EDIT : The scenario here being mentioned is for production environment. Where we do have some test customers and transaction records which are impacting the Financial reports. So we want to get rid of all these test data(which is quite large).

Thanks!

Answer 1

You can delete multiple records at once by using inline editing, see the documentation here (NetSuite login required):

To delete field data by editing inline:

Enable the Edit button on the search results of the data containing the fields you want to delete.

Select an editable element, in the first row, then hold down the Shift key and select the same element in the last row.

While all of those fields in the column are highlighted, choose delete from the menu on the left. You can also set your segment size higher in Home > Set Preferences, to do more than 50 at a time.

Another option is to write a Mass Update script, here is a very basic example:

function perform_update(rec_type, rec_id) {
    try {
        nlapiDeleteRecord(rec_type, rec_id);
    } catch(err) {
        nlapiLogExecution('DEBUG', 'Error deleting record', 'type = ' + rec_type + ", id = " + rec_id);
    }
}