Country Region Code Updation AX 2012

(0) Share

Report

Posted on by PANKAJ

500

We have renamed the 3 digit country region code with corresponding 2 digit country region code in ax 2012. After databse synchronization we had 3 digit as well as 2 digit country region code in the system. If we delete those 3 digit code and do databse synchronisation then still we get both country code(2 digit and 3 digit). If anybody can tell us that how we can prevent to create those 3 digit country region code during database synchronize, it will be appreciated.Tables are - LogisticsAddressCountryRegion and LogisticsAddressCountryRegionTranslation

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Pankaj

When you install AX2012 and initialize the system, AX will create about 260 country/region codes with a mark in the field "IsImmutable". This field indicates that you should not touch these records. The standard AX logic prevents you from changing these records.

AX2012 is shipped with these countries because of a reason. Microsoft has chosen for the 3-digit ISO coding for the countries.

You have to know that some country specific features in AX depend on this table and the 3-digit codes.

So please use the country codes shipped with AX2012. It is not possible to use the 2-digit. The ISO-2 code is available as a field as well, so for integration with other systems it is not a problem.

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

"If it ain't broke, don't fix it"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Unfortunately... Country codes are not static because humans are so fond of killing each other, so labeling ANYTHING like a country code as Immutable is dumb. While I don't see the point of attempting to override the use of a 3-byte (not 3 digit) country code, I see the advantage of providing a proper and correct list of ISO Country Codes in AX. Specifically, the ANT country code "Netherlands Antilles" no longer exists having been replaced by non-Dutch entities. This table has records in it that should be removed allowing the ANT Country code to be removed. Otherwise, some unsuspecting user will attempt to use it, and then we'll find that the shipping application won't ship it since that country code doesn't exist.

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

The country list already contains the proper ISO 2-byte code for each of the countries, and it is still possible to add new countries if necessary.

Indeed, it is not possible to delete existing countries, which is a flaw, but personally I found this flaw to be offset by the fact that I get, out of the box, a comprehensive list of countries, rather than having to waste time creating them in each instance from scratch.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Zvika -- the word "comprehensive" is inaccurate once you compare to the official ISO sources. I found several differences; specifically ANT doesn't exist anymore, and the following country codes were missing: BES, CUW, ESH, SSD and SXM. I also found errors in Canadian province codes and Mexican state codes compared against their respective postal websites -- another 10+ errors. And, finally at least it's an issue in the US, they were missing the 3 Armed Forces state codes. I appreciate the record sets being provided, however we need to be responsible to validate the values and correct them.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tim,

At time of developing AX2012 it is possible that the ISO source had other contents. I have not checked this. We all know we are living in a world with changes. The missing countries and states can be added if needed.

If you decide to have an old country code deleted, you can also use XDS for restricting this value.

then you don't have to bypass intended AX logic.

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

I also suspect that the countries of BES, CUW, ESH, SSD and SXM are only relevant to 0,000001% of AX implementations.

On the other hand, the fact that there is a pre-loaded list of countries, is valuable for 99% of implementations.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Zvika -- I'm happy with the pre-loaded list of countries, but not with the restriction that I can't delete one if it's a "deceased parrot" (montypython.50webs.com/scripts/Series_1/53.htm). These SQL statements will allow the specified country code to be deleted -- though you should delete the country code using the AX Client to assure that any existing references are properly maintained (cascade/delete).

update LogisticsAddressCountryRegion

set IsImmutable = 0

where IsImmutable <> 0

delete from LogisticsAddressCountryRegionTranslation

where CountryRegionID = 'XXX'

and LanguageID <> 'yyyyy'

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tim,

Please read all previous remarks above again carefully. The field IsImmutable has a name with a meaning. Immutable means "do NOT touch it". Other solutions were provided. Why do you ignore warnings? If you will encounter problems because of deleting the countries anyway, it is at your own risk.

I think it is not a wise decision to bypass intended functionality. For sure not if the field has a meaningful name.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Andre -- I'd noticed that when I add new countries (there are several) using the proper AX interface, that the IsImmutable flag wasn't being set. That means I could delete the countries that I add, but not the ones that MS added. Why is that? Why is their data special? It's just data (assuming all referential integrity rules are followed). Just because someone at MS assumed that countries would never, ever go away doesn't mean they won't. I appreciate MS's IsImmutable assumption, but it's incorrect as a rule.

This webpage (geography.about.com/od/politicalgeography/a/missingcountry.htm) shows that lots of countries have ended their existence, such as – Burma (now Myanmar), Ceylon (now Sri Lanka), East and West Germany (now Germany), East Pakistan (now Bangladesh), Hawaii (now a US state), Persia (now Iran), Rhodesia (now Zimbabwe), Siam (now Thailand), North and South Vietnam (now Vietnam), Texas (now a US state), Tibet (now part of China unfortunately), USSR (broken up into 15 countries), Zaire (now DROC) and way, way more examples…

Question: At what point are we allowed to use REALITY as a guide to the world around us, and ignore the line in the sand that some misguided DBA pulled out of his a$$?

Just imagine keeping East and West Germany in the table for the users to choose (because there isn’t an inactive flag in this table). Which would they choose? East Germany, West German, or plain old Germany? Are your users smarter than a 5th grader? Mine aren’t. I choose science.

My apologies if I offend.

Best regards,

Tim

Was this reply helpful? Yes No

Community site session details

Country Region Code Updation AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Country Region Code Updation AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates