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

Hi All, Has anyone had a issue where a Standard NS Field `restricttolocations` (of type location on Advance Boms) has Location ID when I do a getFieldValue returns ID but on the search getValue returns location TEXT... Search is of type `bom` does not have location Field access as well :disappointed: any ideas how I can get the ID on the search.

usually getValue returns the internal id and getText returns the text of select fields

yeah but on a search this field `restricttolocations` on GetValue it returns text

i havent seen an advanced bom, but you can try using a formula column and use {restricttolocations.id}

{restricttolocations.id} returns the location TEXT sigh

But I know that would work for normal LIST fields its this record thats the issue ... but good idea

you can do another search on locations to get the matching names

Yeah that what I am doing.. using a search Mapping to Name so I can get the IDs in ..