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); } } } What I'm missing is the filter so that I can search for only open orders, don't know what that value maybe. After that it should work but it doesn't! I'm also getting an unexpected error when the script is run. This is deployed after submission of a customer edit. I haven't put in any code to determine if the terms value has changed but will do so after I figure this one out.