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

Hey all, any suggestions for comparing shipcountry and a country field? Seems shipcountry uses a short code and country field returns internal id for country (which can't be looked up for further details from what I can see) or lookup as text returns the full country name so no direct comparison available.

I'd use NFT `geography` module to do a lookup.

you can of course swipe that module code by itself, without the rest of NFT  <https://github.com/ExploreConsulting/netsuite-fasttrack-toolkit-ss2/blob/master/geography.ts>

Interesting. I shall have a look thank you!