AvaTax SFDC ISO country codes

When the International Standards Organization (ISO) Country Code option is enabled in Intacct, the Sales Force Integration (SFDC) customer sync will require the country field to include the ISO country name. The country name must match the ISO name. Here is a validation rule that you can put in place in SFDC. This rule validates the value in the country field against the ISO country list.

To implement the validation rule in SFDC, follow these steps:

  1. Go to Setup > Customize > Accounts > Validation Rules, and click New.
  2. Enter Rule Name: Billing_ISO_Check
  3. Copy and paste the following information into the Error Condition Formula box:
Copy 
OR(
LEN( BillingCountry ) = 1,
NOT(
CONTAINS(
"Afghanistan:Åland Islands:Albania:Algeria:American Samoa:Andorra:Angola:Anguilla:Antarctica:Antigua and Barbuda:Argentina:" &
"Armenia:Aruba:Australia:Austria:Azerbaijan:Bahamas:Bahrain:Bangladesh:Barbados:Belarus:" &
"Belgium:Belize:Benin:Bermuda:Bhutan:Bolivia:Bosnia and Herzegovina:Botswana:Bouvet Island:Brazil:" &
"British Indian Ocean Territory:Brunei Darussalam:Bulgaria:Burkina Faso:Burundi:Cambodia:Cameroon:Canada:Cape Verde:Cayman Islands:" &
"Central African Republic:Chad:Chile:China:Christmas Island:Cocos Islands:Colombia:Comoros:Congo:Congo,The Democratic Republic of The Cd:Cook Islands:" &
"Costa Rica:Cote D'ivoire:Croatia:Cuba:Cyprus:Czech Republic:Denmark:Djibouti:Dominica:Dominican Republic:" &
"Ecuador:Egypt:El Salvador:Equatorial Guinea:Eritrea:Estonia:Ethiopia:Falkland Islands:Faroe Islands:Fiji:Finland:" &
"France:French Guiana:French Polynesia:French Southern Territories:Gabon:Gambia:Georgia:Germany:Ghana:Gibraltar:Greece:" &
"Greenland:Grenada:Guadeloupe:Guam:Guatemala:Guernsey:Guinea:Guinea-Bissau:Guyana:Haiti:Heard Island and Mcdonald Islands:" &
"Holy See (Vatican City State):Honduras:Hong Kong:Hungary:Iceland:India:Indonesia:Iran,Islamic Republic of Ir:Iraq:Ireland:Isle of Man:" &
"Israel:Italy:Jamaica:Japan:Jersey:Jordan:Kazakhstan:Kenya:Kiribati:Korea,Democratic People's Republic Of Kp:" &
"Korea,Republic of Kr:Kuwait:Kyrgyzstan:Lao People's Democratic Republic:Latvia:Lebanon:Lesotho:Liberia:Libyan Arab Jamahiriya:Liechtenstein:Lithuania:" &
"Luxembourg:Macao:Macedonia,The Former Yugoslav Republic of Mk:Madagascar:Malawi:Malaysia:Maldives:Mali:Malta:Marshall Islands:Martinique:" &
"Mauritania:Mauritius:Mayotte:Mexico:Micronesia,Federated States Of Fm:Moldova,Republic of Md:Monaco:Mongolia:Montenegro:Montserrat:Morocco:" &
"Mozambique:Myanmar:Namibia:Nauru:Nepal:Netherlands:Netherlands Antilles:New Caledonia:New Zealand:Nicaragua:Niger:" &
"Nigeria:Niue:Norfolk Island:Northern Mariana Islands:Norway:Oman:Pakistan:Palau:Palestinian Territory Occupied Ps:Panama:Papua New Guinea:" &
"Paraguay:Peru:Philippines:Pitcairn:Poland:Portugal:Puerto Rico:Qatar:Reunion:Romania:Russian Federation:" &
"Rwanda:Saint Barthélemy:Saint Helena:Saint Kitts and Nevis:Saint Lucia:Saint Martin:Saint Pierre and Miquelon:Saint Vincent and The Grenadines:Samoa:San Marino:Sao Tome and Principe:" &
"Senegal:Serbia:Seychelles:Sierra Leone:Singapore:Slovakia:Slovenia:Solomon Islands:Somalia:South Africa:South Georgia and The South Sandwich Islands:Spain:" &
"Sri Lanka:Sudan:Suriname:Svalbard and Jan Mayen:Swaziland:Sweden:Switzerland:Syrian Arab Republic:Taiwan, Province of China; Tw:Tajikistan:Tanzania,United Republic of Tz:Thailand:" &
"Timor-Leste:Togo:Tokelau:Tonga:Trinidad and Tobago:Tunisia:Turkey:Turkmenistan:Turks and Caicos Islands:" &
"Tuvalu:Uganda:Ukraine:United Arab Emirates:United Kingdom:United States:United States Minor Outlying Islands:Uruguay:Uzbekistan:Vanuatu:" &
"Venezuela:Viet Nam:Virgin Islands British;Vg:Virgin Islands,U.S.;Vi:Wallis and Futuna:Western Sahara:Yemen:Zambia:Zimbabwe:",
BillingCountry )))

For the Shipping address, add another validation rule, and copy/paste the following:

Copy 
OR(
LEN( ShippingCountry ) = 1,
NOT(
CONTAINS(
"Afghanistan:Åland Islands:Albania:Algeria:American Samoa:Andorra:Angola:Anguilla:Antarctica:Antigua and Barbuda:Argentina:" &
"Armenia:Aruba:Australia:Austria:Azerbaijan:Bahamas:Bahrain:Bangladesh:Barbados:Belarus:" &
"Belgium:Belize:Benin:Bermuda:Bhutan:Bolivia:Bosnia and Herzegovina:Botswana:Bouvet Island:Brazil:" &
"British Indian Ocean Territory:Brunei Darussalam:Bulgaria:Burkina Faso:Burundi:Cambodia:Cameroon:Canada:Cape Verde:Cayman Islands:" &
"Central African Republic:Chad:Chile:China:Christmas Island:Cocos Islands:Colombia:Comoros:Congo:Congo,The Democratic Republic of The Cd:Cook Islands:" &
"Costa Rica:Cote D'ivoire:Croatia:Cuba:Cyprus:Czech Republic:Denmark:Djibouti:Dominica:Dominican Republic:" &
"Ecuador:Egypt:El Salvador:Equatorial Guinea:Eritrea:Estonia:Ethiopia:Falkland Islands:Faroe Islands:Fiji:Finland:" &
"France:French Guiana:French Polynesia:French Southern Territories:Gabon:Gambia:Georgia:Germany:Ghana:Gibraltar:Greece:" &
"Greenland:Grenada:Guadeloupe:Guam:Guatemala:Guernsey:Guinea:Guinea-Bissau:Guyana:Haiti:Heard Island and Mcdonald Islands:" &
"Holy See (Vatican City State):Honduras:Hong Kong:Hungary:Iceland:India:Indonesia:Iran,Islamic Republic of Ir:Iraq:Ireland:Isle of Man:" &
"Israel:Italy:Jamaica:Japan:Jersey:Jordan:Kazakhstan:Kenya:Kiribati:Korea,Democratic People's Republic Of Kp:" &
"Korea,Republic of Kr:Kuwait:Kyrgyzstan:Lao People's Democratic Republic:Latvia:Lebanon:Lesotho:Liberia:Libyan Arab Jamahiriya:Liechtenstein:Lithuania:" &
"Luxembourg:Macao:Macedonia,The Former Yugoslav Republic of Mk:Madagascar:Malawi:Malaysia:Maldives:Mali:Malta:Marshall Islands:Martinique:" &
"Mauritania:Mauritius:Mayotte:Mexico:Micronesia,Federated States Of Fm:Moldova,Republic of Md:Monaco:Mongolia:Montenegro:Montserrat:Morocco:" &
"Mozambique:Myanmar:Namibia:Nauru:Nepal:Netherlands:Netherlands Antilles:New Caledonia:New Zealand:Nicaragua:Niger:" &
"Nigeria:Niue:Norfolk Island:Northern Mariana Islands:Norway:Oman:Pakistan:Palau:Palestinian Territory Occupied Ps:Panama:Papua New Guinea:" &
"Paraguay:Peru:Philippines:Pitcairn:Poland:Portugal:Puerto Rico:Qatar:Reunion:Romania:Russian Federation:" &
"Rwanda:Saint Barthélemy:Saint Helena:Saint Kitts and Nevis:Saint Lucia:Saint Martin:Saint Pierre and Miquelon:Saint Vincent and The Grenadines:Samoa:San Marino:Sao Tome and Principe:" &
"Senegal:Serbia:Seychelles:Sierra Leone:Singapore:Slovakia:Slovenia:Solomon Islands:Somalia:South Africa:South Georgia and The South Sandwich Islands:Spain:" &
"Sri Lanka:Sudan:Suriname:Svalbard and Jan Mayen:Swaziland:Sweden:Switzerland:Syrian Arab Republic:Taiwan, Province of China; Tw:Tajikistan:Tanzania,United Republic of Tz:Thailand:" &
"Timor-Leste:Togo:Tokelau:Tonga:Trinidad and Tobago:Tunisia:Turkey:Turkmenistan:Turks and Caicos Islands:" &
"Tuvalu:Uganda:Ukraine:United Arab Emirates:United Kingdom:United States:United States Minor Outlying Islands:Uruguay:Uzbekistan:Vanuatu:" &
"Venezuela:Viet Nam:Virgin Islands British;Vg:Virgin Islands,U.S.;Vi:Wallis and Futuna:Western Sahara:Yemen:Zambia:Zimbabwe:",
ShippingCountry )))

For existing SFDC accounts, the customer can use the Salesforce data loader to update country names.