So I'm having issues when I try to edit the shipping address on a Purchase Order, created from a Sales Order. I am getting the shipping address values from the Sales Order, and checking the length on each one of the fields. If they are too long I edit them. The problem is, when I try to commit / save these new values on the Purchase order, I get an Unexpected Error. This script is running on a user event beforeSubmit, and I've also tried afterSubmit. Has anyone tried to edit a shipping address on a PO created from an SO? Here is my code:
/** * @NApiVersion 2.x * @NScriptType UserEventScript * @NModuleScope Public */ define(['N/record', 'N/search'], /** * @param {record} record * @param {search} search */ function(record, search) { function beforeSubmit(scriptContext) { if(scriptContext.type != 'create'){ return; } var poRecord = scriptContext.newRecord; // var poRecord = record.load({ // type: record.Type.PURCHASE_ORDER, // id: 27180627 // }); var form = poRecord.getValue({ fieldId: 'customform' }); if(form != 145){ return; } var createdFrom = poRecord.getValue({ fieldId: 'createdfrom' }); if(!createdFrom){ return; } var salesOrderSearchObj = search.create({ type: "salesorder", filters: [ ["type","anyof","SalesOrd"], "AND", ["internalidnumber","equalto", createdFrom] ], columns: [ "shipaddressee", "shipaddress1", "shipaddress2", "shipcity", "shipstate", "shipzip" ] }); var results = salesOrderSearchObj.run().getRange(0, 1); log.debug('results', results); if(!results.length){ return; } // Address Name (N102) – 1/60 // Address1 (N301) – 1/55 // Address2 (N302) – 1/55 // City (N401) – 2/30 // State (N402) – 2/2 // Postal Code (N403) – 3/15 // Country (N404) – 2/3 var addressName = results[0].getValue( salesOrderSearchObj.columns[0] ); var subaddressName = addressName.substring(0, 60); var address1 = results[0].getValue( salesOrderSearchObj.columns[1] ); var subaddress1 = address1.substring(0, 55); var address2 = results[0].getValue( salesOrderSearchObj.columns[2] ); var subaddress2 = address2.substring(0, 55); var city = results[0].getValue( salesOrderSearchObj.columns[3] ); var subcity = city.substring(0, 30); var state = results[0].getValue( salesOrderSearchObj.columns[4] ); var substate = state.substring(0, 2); var postalCode = results[0].getValue( salesOrderSearchObj.columns[5] ); var subpostalCode = postalCode.substring(0, 15); log.debug('gettingFields: ', 'AddressName: ' + subaddressName + ' address1: ' + subaddress1 + ' address2: ' + subaddress2 + ' city: ' + subcity + ' state: ' + substate + ' postalCode: ' + subpostalCode); poRecord.setValue({ fieldId: 'shipaddresslist', value: null }); // GET PO's subrecord var shipAddress = poRecord.getSubrecord({ fieldId: 'shippingaddress' }); log.debug('shipaddressfirst', shipAddress); shipAddress.setValue({ fieldId: 'addressee', value: subaddressName }); shipAddress.setValue({ fieldId: 'addr1', value: subaddress1 }); shipAddress.setValue({ fieldId: 'addr2', value: subaddress2 }); shipAddress.setValue({ fieldId: 'city', value: subcity }); shipAddress.setValue({ fieldId: 'state', value: substate }); shipAddress.setValue({ fieldId: 'zip', value: subpostalCode }); shipAddress.commitLine({ sublistId: 'shippingaddress' }); log.debug('shipAddressafter', shipAddress); } return { beforeSubmit: beforeSubmit }; });