Discussions
Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.
Click on this link for the poll.
Saved Search - Display Formula Text Field to Screen
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)");
Tagged:
0