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 any way to get State Internal ID by its name? Like: Internal ID: 1010 Name: Alabama AL

Not sure if the native state field has an internal id. When I use getValue, I get the two letter state code, getText give the full state name

When I create a custom field that use State, when I getValue it returns it internal id, got it?

Yes but you can't use that internal id to set a value in the native state field you can only use that to use in setting your custom state field.  If you want to get the name use getText.

If you want to set your custom field and you only can use setText, if you only have the name value.

Yes, thats true, I can get and set the field with the name value

But in my case, I have a custom record with this custom field and I need to search this record by the state value, got it?

you should be able to use that field as a filter when you create a search for the custom record

I can perform the search only with internal id

I'm had to create another custom record to map id/value and that sucks

Can you know me what you have tried so far, code.