Articles in this section

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.

    1.png
    2.png
  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.

3.png

Salesforce Picklist configurations

  1. By default, prepackaged States and Countries match the Country label and Integration Value field.
    4.png
  2. Similarly, you need to configure the new entries.
    5.png
  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.

    6.png
Important: When syncing state/country for the flows originating from NetSuite, the integration app by default maps the codes from NetSuite to corresponding fields in the Salesforce. During this process you will face the below issues:
  • The codes in NetSuite may or may not match with Salesforce configured state/territory lists
  • The codes in NetSuite can be more than 10 characters, while Salesforce allows only 10 characters

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:

Existing mapping

New mapping

Label

billstate

_billingaddress_dropdownstate.name

Billing State/Province

billcountry

_billingaddress_country.name

Billing Country

shipstate

Shipping State/Province

_shippingaddress_dropdownstate.name

shipcountry

_shippingaddress_country.name

Shipping Country

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.

7.png
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.