A schedule script that deletes the expiration on a gift certificate

 Sometimes, gift certificates with no expiration dates are required.Following is a scheduled script that, when run daily, will delete the expiration date on any gift certificate that was created on the same day.

Note: The information contained in this article may or may not lead to the alteration of data in your production account, thus NetSuite holds no liability whether you choose to follow the instructions. In the event that data is deleted, altered or removed and requires restoration there will be applicable fees – please proceed with caution.

//define the script functionfunction scheduled(type) {//create an array to hold search results var filters = new Array(); //create a search filter to specify the condition 'purchase date= today' filters[0] = new nlobjSearchFilter( 'purchasedate', null, 'on','today'); //search for gift certificate records that fulfill the purchase date condition var searchresults = nlapiSearchRecord( 'giftcertificate', null, filters, null );//loop through the search results for ( var i = 0; searchresults != null && i < searchresults.length; i++ ) {//get the record id for each record var id = searchresults[i].getId(); //load the selected gift certificate record var record=nlapiLoadRecord('giftcertificate', id); // set the field 'Expiration Date' to blank record.setFieldText('expirationdate',''); //submit the record nlapiSubmitRecord(record); } }