web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Adding a non-ISO curre...
Microsoft Dynamics AX (Archived)

Adding a non-ISO currency to AX 2012 RTM

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All,

I am looking to add a non-iso Currency to AX 2012 RTM, but am running into a slight issue.

I have followed the step here https://technet.microsoft.com/en-us/library/hh351822.aspx, but am running into an issue at step 4 where I need to enter a name and symbol for this code.

If I try to enter and Non-ISO code into the Currency Code: field (Currency.CurrencyCodeISO), I get an error saying "The value 'xxx' in the field 'Currency Code' is not found in the related table 'ISO currency codes'. The currency code field is also required on this form.

This leads me to believe that the only way for me to enter an non-ISO currency into AX, is to insert a record into the ISOCurrencyCode table. Is this correct, or is there another way I can enter in a non-ISO currency code?

Also, if the only way is to insert another record into the ISOCurrencyCode table, are there any potential issues I could run into?

Thanks,

Phil

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Phil,

    Can you provide some additional information on why you need a new non-ISO currency for? What is your scenario / business process?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hello Ludwig,

    I am still untangling exactly why we need this, but my understanding is that we have a non-iso currency tied to a specific investment type for reporting purposes.

    The transactions for the investments are created in another system(with the non-iso currency), and we are just integrating into AX from that system.

    We are going to need to leave the transactions in the non-iso currency though, but have them be able to be converted for consolidation and such.

    Hopefully this makes my requirements a little clearer.

    -Phil

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Phil,

    I saw systems where people tried setting up non-ISO currencies for specific purposes such as fixed exchange rate / financial hedging scenarios. Those setups often cause some trouble especially with  automatic posting functionalities, currency revaluations and alike. For that reason I would suggest that you try getting a very clear picture why this non-ISO currency is required and whether no other way of bringing those transactions into AX is possible (e.g. overwriting/specificying the exchange rate in the ledger journal that overwrites the default AX Exchange rates). Please try to do an "extra round" (talk/discussion) with your colleagues and try to find out what and why they really Need this. If you can avoid it e.g. by using a Workaround try to avoid brining in another currency.

    All the best,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans