Hi,
Has anyone discovered the magic scripting id for the built-in states table?
My scenario is like this:
It seems like every account I work in we want to do something based on ship to state. And so for years I've created a state record structure that contains the 2 character state upon which hooks can be hung. Or just have people enter the state codes directly. Not a big deal but something else to maintain.
Now there is a built in list of states complete with country and state codes. Great! I can build a custom record that references state and give a user the easy ability to configure some table based rules.
Huh! the Ship To state in an address is a two character field while the id of a built in state is numeric. Ok that makes sense. I'll just source in the short name and ... WTF!
Netsuite - Please complete this.