Hello,
I was using the code from one of the answers here to get the Rate and Amount from the "createdfrom" record on the Item Fulfillment. The issue is the values on the IF don't reflect the correct sequence. See image below for how this appears:
/**
*@NApiVersion 2.x
*@NScriptType ClientScript
*@NModuleScope SameAccount
*/
define(['N/search', 'N/currentRecord'], function (search, rec) {
function pageInit(context) {
var ifRec = rec.get();
var SalesOrderId = ifRec.getValue('createdfrom');
var numLines = ifRec.getLineCount({ sublistId: 'item' });
var itemArr = [];
for (var i = 0; i < numLines; i++) {
var ifItem = ifRec.getSublistValue({ sublistId: 'item', fieldId: 'item', line: i });
itemArr.push(ifItem);
}
var filter1 = search.createFilter({ name: 'mainline', operator: search.Operator.IS, values: 'F' });
var filter2 = search.createFilter({ name: 'internalid', operator: search.Operator.ANYOF, values: SalesOrderId });
var filter3 = search.createFilter({ name: 'item', operator: search.Operator.ANYOF, values: itemArr });
var column1 = search.createColumn({ name: 'rate', summary: search.Summary.GROUP });
var column2 = search.createColumn({ name: 'amount', summary: search.Summary.GROUP, function: 'absoluteValue' });
var SalesOrderSearch = search.create({
type: search.Type.SALES_ORDER,
filters: [filter1, filter2, filter3],
columns: [column1, column2]
});
var toRateArr = [];
var toAmountArr = [];
var searchResult = SalesOrderSearch.run().each(function (result) {
var toRate = result.getValue({ name: 'rate', summary: search.Summary.GROUP });
var toAmount = result.getValue({ name: 'amount', summary: search.Summary.GROUP, function: 'absoluteValue' });
toRateArr.push(toRate);
toAmountArr.push(toAmount);
return true;
});
for (var i = 0; i < numLines; i++) {
ifRec.selectLine({ sublistId: 'item', line: i });
ifRec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'custcol_ful_rate', value: toRateArr[i], forceSyncSourcing: true });
ifRec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'custcol_ful_amount', value: toAmountArr[i], forceSyncSourcing: true });
ifRec.commitLine('item');
}
}
return {
pageInit: pageInit
};
});