Item search returning incorrect value

I’ve seen occasional quirks in NS displays in the Saved Search UI.

Have you managed to get the data you need? If not, have you tried joining to the Item record to get the field?

Is the value (including the item code) you are expecting inside the field ITEM NAME/NUMBER? Which is basically the “itemid” column. I tried this on my test account and was able to pull what’s inside the said field.  I did not get the Display Name column. My saved search is pretty basic, no formulas or anything. And I used the snippet below.

var mySearch = search.load({
id: 'customsearch67_2'
});
mySearch.run().each(function (result) {
itemName = result.getValue({
name: 'itemid'
});
console.log(itemName);
return true;
});

Is the item code the only thing missing? I have experience where UI Saved Search combines certain data like Item Code + Item Name, but when getting the data through scripting, it will only show one or the other. One suggestion is to use formula, simply put {itemid}, it should display the same thing, and use this formula column in the script.

Hope it helps.

I tried copying the above code snippet into a suitelet and found it worked OK. I then realised that the difference was that I’m running mine “Available without login” and testing on a public facing URL (it’s for a data feed integration).

Running my script as administrator, the correct {itemid} values come out. Running it as anything else, I get {storedisplayname} values instead – even using our “superuser” role, which is basically administrator with the mandatory 2FA customization permissions removed. From the deployment screen, I can run the same script and output a CSV with different column values depending on whether I use the UI or external URL links.

It’s obviously a permissions issue, but I presume also an underlying bug somewhere. I can’t believe Netsuite intended it to swap values rather than return an error.

Team,

Though not entirely related to this, I ran into an issue with a Summary saved search NOT returning the same results in script than in the UI. Turns out the issue was the “Filter By” option. This was set to Order Type, but the transaction search was running on only Journal Entries for specific accounts. Oddly, this resulted in only a few rows not returning data in script tho returning data in the UI.

Hope this helps someone in the future!