Hello,
Is there a any change to round this issue?
I have a customer that wants to split work order with quantity of 60 to 60 of work orders with quantity of one.
I made a client script that is executed from custom buttom.
Everything works fine, but after creating 33 new work orders Script execution usage is full and scripts stops.
I't doesn't make a rollback, it just stops.
Is there any way to write more effectice script that uses less usage units?
My Script :
function splitwo()
{
var id = nlapiGetRecordId();
var WOrec = nlapiLoadRecord('workorder',id);
var count = WOrec.getFieldValue('quantity');
var newcount = count-1;
if (newcount =='0')
{
alert ('No Work orders to create')
}
else
{
alert ('Starting to creaate new work orders');
var assembly = WOrec.getFieldValue('assemblyitem');
var units = WOrec.getFieldValue('units');
var trandate = WOrec.getFieldValue('trandate');
var orderstatus = WOrec.getFieldValue('orderstatus');
var firmed = WOrec.getFieldValue('firmed');
var startdate = WOrec.getFieldValue('startdate');
var enddate = WOrec.getFieldValue('enddate');
var promisedate = WOrec.getFieldValue('custbody_promisedate');
var location = WOrec.getFieldValue('location');
var entity = WOrec.getFieldValue('entity');
var job = WOrec.getFieldValue('job');
var createdfrom = WOrec.getFieldValue('createdfrom');
var sotranid = createdfrom ? nlapiLookupField('salesorder',createdfrom,'tranid'): '';
for (var i = 1; i <= newcount;i++)
{
console.log('starting_'+i)
var usage = nlapiGetContext().getRemainingUsage();
console.log('usage_'+i+'_'+usage);
var NEWwo = nlapiCreateRecord('workorder',{recordmode: 'dynamic'})
var y = i+1
var detailedinformation = sotranid+'_'+y+'/'+count
NEWwo.setFieldValue('quantity',1);
NEWwo.setFieldValue('assemblyitem',assembly);
NEWwo.setFieldValue('units',units);
NEWwo.setFieldValue('trandate',trandate);
NEWwo.setFieldValue('orderstatus',orderstatus);
NEWwo.setFieldValue('firmed',firmed);
NEWwo.setFieldValue('startdate',startdate);
NEWwo.setFieldValue('enddate',enddate);
NEWwo.setFieldValue('custbody_promisedate',promisedate);
NEWwo.setFieldValue('location',location);
NEWwo.setFieldValue('entity',entity);
NEWwo.setFieldValue('job',job);
NEWwo.setFieldValue('custbody_mpc_wosplit_info',detailedinformation);
NEWwo.setFieldValue('custbody_mpc_sonumforprinting',sotranid);
NEWwo.setFieldValue('custbody_mpc_wonumforprinting',+y+'/'+count);
try {
var NEWwoId = nlapiSubmitRecord(NEWwo);
nlapiLogExecution('Audit', 'Created WO', +NEWwoId);
} catch (e) {
console.log(e)
//nlapiLogExecution('ERROR', 'Work Order creation error', e.getCode() + '\n' +e.getDetails());
}
}
nlapiSubmitField('workorder',id,'quantity','1')
nlapiSubmitField('workorder',id,'custbody_mpc_wosplit_info',sotranid+'_1/'+count)
alert(+newcount+'work orders created!')
}
window.self.location.reload(false);
}