I need to display the results of a saved search calculated field - Formula(numeric)
So far I was able to display the Internal ID, Name, Description which are grouped. Code so far looks like this:
function downstocking(request, response) { // Global Variables var form; // GET Request if (request.getMethod() == 'GET') { var myform = createForm(); var mysublist = createSublist(myform); var filters = new Array(); //select all and remove all mysublist.addMarkAllButtons(); //Define search columns var columns = new Array(); columns[0] = new nlobjSearchColumn('internalid').setSort(); columns[1] = new nlobjSearchColumn('name'); columns[2] = new nlobjSearchColumn('displayname'); var searchresults = nlapiSearchRecord('item','20995'); var p = 1; for (var i = 0; searchresults != null && i < searchresults.length; i++) { var searchresult = searchresults[i]; mysublist.setLineItemValue('internalid',p,searchresult.getValue('internalid',null,'group')); mysublist.setLineItemValue('name',p,searchresult.getValue('name',null,'group')); mysublist.setLineItemValue('description',p,searchresult.getValue('description',null,'group')); p++; } function createForm() { form = nlapiCreateForm('Downstocking Report', false); form.addFieldGroup('maingroup', 'Select').setShowBorder(false); //form.addSubmitButton("Submit Checked Item(s)"); return form; } function createSublist(form) { list = form.addSubList('cc_inv_list', 'list', 'Downstocking Report', null); list.addField('internalid', 'text', 'Internal ID'); list.addField('name', 'text', 'Name'); list.addField('description', 'text','Description'); return list; }The above code works fine. It outputs this: [ATTACH=CONFIG]n416788[/ATTACH] The calculated fields in the saved search I'm referencing in the code that I need to display look like this: [ATTACH=CONFIG]n416789[/ATTACH] How do I get these calculated fields to display as shown above in the code that works to display it in NS?Thanks!