Hello All,

I have written some code that will update all the open sales orders terms field for a customer.  We do this because sometimes we will put in an order for a customer before their terms is complete and although we keep them on hold, when the terms is updated it is not reflected on the sales order and the resulting invoice.

Here is what I have:

// update sales order with new customer terms  function updateSalesOrderForCustomers(type){   if (type == 'edit') {    var customerRecord = nlapiGetNewRecord();    var terms = customerRecord.getFieldValue('terms');    var customer_id = customerRecord.getFieldValue('entityid');    var filters = new Array();    filters[0] = new nlobjSearchFilter('name', null, 'equalTo', customer_id, null);    filters[1] = new nlobjSearchFilter( 'status', null, 'equalTo', 'Open', null); //What do you set so that it only updates open sales orders?    var searchresults = nlapiSearchRecord('salesorder', null, filters, null);    for ( var i = 0; searchresults != null && i < searchresults.length; i++ ) {     var record = nlapiLoadRecord(searchresults[i].getRecordType(), searchresults[i].getId());     record.setFieldValue('terms', terms);     nlapiSubmitRecord(record, true);    }   }   }