TROUBLESHOOTING: Getting error “Invalid country reference key” when creating sales orders in NetSuite
Q. My import is designed to create a salesorder and a value for salesorder.shipcountry set to a valid three-letter ISO country code, such as HUN. That worked fine until my account was upgraded to integrator.io NetSuite Bundle v22.214.171.124, and now the import fails with the error Invalid country reference key <country name>.
I’ve noticed that the two-letter code doesn’t produce this error. Is some change to my settings or flow logic now required?
A. This error is generated within a unique circumstance:
- The flow was developed for an earlier NetSuite bundle that had the Address subrecord set by default.
- This Address as a subrecord default import setting was later removed in a bundle update.
- The sandbox or production environment’s bundle was upgraded to the latest version.
With the current bundle release, that missing Address subrecord then throws an error.
To re-enable Address subrecord and fix this error, hard-code the NetSuite destination field Use Address Subrecord to True in the import mappings.
Please sign in to leave a comment.