how to set the sublist valuees in an aftersubmit f...
# suitescriptv
vennila ramasamy
11/13/2023, 12:02 PMhow to set the sublist valuees in an aftersubmit function?
n
Nathan L
11/13/2023, 1:14 PMTo set any record values in afterSubmit you have to load the record in your script, then save the record after setting values
v
vennila ramasamy
11/13/2023, 1:14 PMi did it, but it didnt reflect
n
Nathan L
11/13/2023, 1:34 PMAre you loading it in dynamic mode?
v
vennila ramasamy
11/13/2023, 2:27 PMtried dynamic mode as true and false both, but not successful
b
burkybang
11/13/2023, 2:38 PMShow us your code
this 1
v
vennila ramasamy
11/14/2023, 8:34 AMfunction afterSubmit(context) {
try{
var newRecordID = context.newRecord.id;
//var invoiceRecord = context.newRecord;
log.debug('re',newRecordID);
var invoiceRecord = record.load({
type : 'invoice',
id : newRecordID,
isDynamic : true
});
var lineCount = invoiceRecord.getLineCount('item');
log.debug('line',lineCount);
for( var i = 0; i < lineCount; i + 2 ){
log.debug('i',i);
var item = invoiceRecord.getSublistValue({
sublistId : 'item',
fieldId : 'item',
line : i
});
log.debug('item',item);
if (item !== '6177'){
var quantity = invoiceRecord.getSublistValue({
sublistId : 'item',
fieldId : 'quantity',
line : i
});
log.debug('quantity',typeof quantity);
var item = invoiceRecord.getSublistValue({
sublistId : 'item',
fieldId : 'item',
line : i + 1
});
log.debug('lineid',lineIDBaseItem);
if(item === '6177'){
log.debug('item if',item);
invoiceRecord.setSublistValue({
sublistId : 'item',
fieldId : 'quantity',
line : i + 1,
value : quantity
});
}
}
}
invoiceRecord.save();
//}
}catch(e){log.debug('eror',e);}
}
b
burkybang
11/14/2023, 1:15 PMYou need to use dynamic mode methods in dynamic mode when getting/setting sublist line values.
1. selectLine
2. getCurrentSublistValue
3. setCurrentSublistValue
4. commitLine <-- Don't forget this one!
v
vennila ramasamy
11/15/2023, 8:44 AMits fixed. in the for loop to increment by 2, it should be i+=2, i did i+2 by mistake
6 Views