Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Return full state names in a saved search for bill and ship address
Are there any functions that will return the full state names for addresses of companies from a saved search?
I saw the {statedisplayname} field, but I need it for billstate and for shipstate.
I was actually surprised I couldn't find an easy way to do this, so I'm probably missing something.
I thought maybe a decode function, but the length of the formula would be much too long for Canada and the US.
Any ideas would be appreciated. A user asked for this since they said one of our partners needed the long form names for a salesforce import, even though I'm doubtful that salesforce requires the long form name.
0