FAQ: Resolve data mismatch issues when the picklist feature is enabled in Salesforce

Prerequisite: In your Salesforce account, on the “State and Country/Territory Picklists” page, configure the following:

1. Configure state and country/territory picklists
2. Scan your organisation
3. Convert your data
4. Turn on state and country/territory picklists 
5. Rescan and fix customisations

For more information, see Let Users Select State and Country from Picklists.

Configure settings

1. When you enable this picklist feature in Salesforce, the State and Country fields on the salesforce objects are changed to picklist type.
2. Salesforce packages 239 countries with its states and provinces, out of which, 9 countries have picklists available.
3. Each of the records (countries and state/territory) have three fields:
1. Name: Display label
2. Code: An internal ISO code
3. Integration value: This is used for integration purpose
4. You can configure Name and Integration value for the countries and states for the prepackaged records.

   Note: Code can’t be changed for prepackaged records.

   
    

5. For countries other than available picklisted states, the state list needs to be configured by entering the values for name, code and integration value fields.

Note: The code field has a limit of 10 characters.

Important: For smoother integration and to avoid data mismatches, you should provide the value for Integration value field that matches with the value in your NetSuite.

Salesforce Picklist configurations

1. By default, prepackaged States and Countries match the Country label and Integration Value field.
   
2. Similarly, you need to configure the new entries.
   
3. The Integration Value is used by the Integration app to populate the record. Integration Value should match with the Name field of the State/Country record in NetSuite.

   Note: Salesforce has a limit on code length to 10 characters, so you might not have a matching entry in Salesforce, but you should make sure that the name and integration value matches in the Salesforce.

   

Mappings to be configured on your Integration App

In order to fix the above issues you need to edit the mappings Flows > Account and “NetSuite Customer to Salesforce Account Add/Update” like below:

In order to use the above changed mappings “_billingadress”, you have to select Address in Sublists to include fields by settings in the export adapter.