Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Country Code Change

Country Code Change

(0) Share

Report

Posted on by Community Member Microsoft Employee

Our source for currency rates has notified us that they are changing the codes for some of the countries that we get currency feeds on. One of these is Romania (changing from ROM to ROU).

We do have invoices already processed with the ROM code. The business user is thinking that they want to keep both codes on the country table - even though they reference the same country. We do not have any type of effective date or status on the country table so that current records that may come in with the old code could be flagged and changed.

Has anyone done anything similar to this before? We recognize that any reporting we do would need to handle the two different codes - any suggestions or comments on how others may handle this type of thing would be appreciated.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

TWBlaisdell on at

Like (0)

Report

Re: Country Code Change

Hello HSB-Tech1,

Thank you for posting on the Forum.

With the relational database in NAV, you could just rename the code from ROM to ROU and it will be used everywhere going forward. I think the greater challenge may be to try to maintain the two separate codes yet keep a relationship between the two codes.

I hope this guidance helps.

Best Regards

Tom