RE: Item search returning incorrect value

I’m currently working on a Suitelet script in SS2.0 and am encountering an issue with returned search values. I’ve seen the same issue before in SSP, assumed it was a bug and simply worked around it – but wouldn’t expect to see the same with a regular Suitescript release.

I have an item saved search set up in the UI, which includes the column “Name”. This works fine and returns our product’s item code.

If I load the same search in SS2.0, result.getValue(‘itemid’) is returning the value from storedisplayname instead.

I tried dumping a JSON.stringify on the search result and the raw search output displays the same issue – and doesn’t contain the item code anywhere.

Is there some quirk to item searches I need to know about?

dominicb Beginner Asked on November 29, 2019 in SuiteScript.

can you post your item saved search code? just tried in a demo account and am getting the expected result here.

on December 2, 2019.
Add Comment
4 Answers

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'
}); (result) {
itemName = result.getValue({
name: 'itemid'
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.

Rookie Answered on December 4, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.