Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
How to map the corresponding Sales Order Item Lines on Item Fulfillment in SuiteScript?
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' });