Ravi
07/28/2022, 7:32 AMMarvin
07/28/2022, 7:37 AMRavi
07/28/2022, 7:39 AMallocationSearchObj.run().each(function(result) {
var accountId = result.getValue('custrecord_da_all_acc');
console.log('accountId', accountId);
var weight = result.getValue('custrecord_da_dest_wght');
console.log('weight', weight);
var checkPercentage = result.getValue({
name: "custrecord_da_alloc_prcnt",
join: 'custrecord_da_all_sett'
});
console.log('checkPercentage', checkPercentage);
gainAndloss = result.getValue({
name: "custrecord206",
join: 'custrecord_da_all_sett'
});
var lineAmount = 0;
if(debitAmount > 0){
lineAmount = debitAmount;
}
if(creditAmount > 0){
lineAmount = creditAmount;
}
var value;
if (checkPercentage == true) {
value = (weight / 100) * lineAmount;
} else {
value = (weight * lineAmount) / weightTotal;
}
value = Number(value).toFixed(3);
// totalValue = parseFloat(totalValue) + parseFloat(value);
context.currentRecord.selectNewLine({
sublistId: 'line'
});
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'account',
value: accountId,
forceSyncSourcing:true
});
if (credit == true) {
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'custcol_da_cr_3_decimal',
value: value
});
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'credit',
value: value
});
}else{
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'custcol_da_dr_3_decimal',
value: value
});
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'debit',
value: value
});
}
if (memo) {
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'memo',
value: memo
});
}
var department = result.getValue('custrecord_da_dest_dept');
if (department) {
context.currentRecord.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'department',
value: department
});
}
context.currentRecord.commitLine({
sublistId: 'line',
ignoreRecalc: false
});
return true;
});
Ravi
07/28/2022, 7:41 AMMarvin
07/28/2022, 8:01 AMRavi
07/28/2022, 8:04 AMMarvin
07/28/2022, 8:07 AMRavi
07/28/2022, 8:10 AMRavi
07/28/2022, 8:11 AMMarvin
07/28/2022, 8:13 AMbattk
07/28/2022, 8:28 AMforceSyncSourcing
on every line to avoid commiting the line before sourcing is completeRavi
07/28/2022, 8:30 AMRavi
07/28/2022, 8:30 AMbattk
07/28/2022, 8:32 AMRavi
07/28/2022, 8:34 AM