This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a straight forward way to find a single item record by the itemid/name?

Right now I'm using N/search and running essentially `search.create(...filters: ['name', 'is', 'myItemId']).run().getRange({start: 0, end: 10})[0].id;`

What exactly do you want the item record for?  search.lookupFields() is good for retrieving body level information if you know the id/type

Oh I just re-read, you don't know the internalid, and need to get it.

you probably want to be using the nameinternal filter instead

Thanks, copy/paste error. The field I'm searching on n this case is `itemid`

&gt; function findRecordIdByName(itemId) {
&gt;     var recordSearch = search.create({
&gt;         type: search.Type.ASSEMBLY_ITEM,
&gt;         columns: ['internalid'],
&gt;         filters: ['itemid', 'is', itemId],
&gt;     });
&gt;     var results = recordSearch.run()
&gt;         .getRange({ start: 0, end: 10 });
&gt;     if (results.length !== 1) {
&gt;         return null;
&gt;     }
&gt; 
&gt;     return results[0].id;
&gt; }

modify one of your items to have a value in the display name that matches another item

search for that items name using your code

Are you expecting it to return two results? I was wondering about that.

My item SKU's are tightly controlled, only my scripts are going to be managing item id's, user's are not able to set them up manually. So, I think this will be ok if that's what you're suggesting is a problem to watch out for.

itemid is the same as name, and they both look at multiple name related fields

nameinternal is the precise one that only looks at itemid

Oh, that's really good info. Thanks <@U5TF1GQ20>!