mtoniato
04/08/2022, 6:49 AMNickSuite
04/08/2022, 7:01 AMmtoniato
04/08/2022, 7:02 AMfunction pageInit(scriptContext) {
var current_record = scriptContext.currentRecord;
var rfq_vendor_id = current_record.getSublistValue({
sublistId: "item",
fieldId: "custcol_pce_vendor",
line: 0
});
console.log("First Line Vendor ID: "+ rfq_vendor_id);
if(rfq_vendor_id!=null){
current_record.setValue({
fieldId: 'entity',
value: rfq_vendor_id,
fireSlavingSync: true
});
var num_lines = current_record.getLineCount({sublistId: 'item'});
console.log("NUM Lines: "+ num_lines);
for (i = num_lines-1; i >=0 ; i--) {
current_record.selectLine({
sublistId: "item",
line: i
});
current_rfq_vendor_id=current_record.getCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_pce_vendor"
});
if(current_rfq_vendor_id!=rfq_vendor_id){
current_record.removeLine({
sublistId: "item",
line: i
});
continue;
}
console.log("RATE BEFORE: "+current_record.getCurrentSublistValue({
sublistId: "item",
fieldId: "rate"
}));
custcol_pce_cost=current_record.getCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_pce_cost"
});
console.log("PCE Cost for Line "+i+": "+custcol_pce_cost);
current_record.setCurrentSublistValue({
sublistId: "item",
fieldId: "rate",
value: custcol_pce_cost,
fireSlavingSync: true
});
current_record.commitLine({
sublistId: "item"
});
current_record.selectLine({
sublistId: "item",
line: i
});
console.log("RATE AFTER: "+current_record.getCurrentSublistValue({
sublistId: "item",
fieldId: "rate"
}));
}
}
}
NickSuite
04/08/2022, 7:48 AMmtoniato
04/08/2022, 7:52 AMNickSuite
04/08/2022, 7:58 AMmtoniato
04/08/2022, 8:15 AMmtoniato
04/08/2022, 8:19 AMmtoniato
04/08/2022, 8:31 AMmtoniato
04/08/2022, 8:49 AMNickSuite
04/08/2022, 9:16 AMNickSuite
04/08/2022, 9:16 AMmtoniato
04/08/2022, 9:52 AMmtoniato
04/08/2022, 9:52 AMmtoniato
04/08/2022, 9:52 AMvar num_lines = current_record.getLineCount({sublistId: 'item'});
console.log("NUM Lines: "+ num_lines);
for (i = num_lines-1; i >=0 ; i--) {
current_record.selectLine({
sublistId: "item",
line: i
});
current_rfq_vendor_id=current_record.getCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_pce_vendor"
});
if(current_rfq_vendor_id!=rfq_vendor_id){
current_record.removeLine({
sublistId: "item",
line: i
});
continue;
}
}
mtoniato
04/08/2022, 9:54 AMmtoniato
04/08/2022, 11:08 AM