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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Import Currency Exchan...
Microsoft Dynamics AX (Archived)

Import Currency Exchange Rates from Reserve Bank of Australia

(0) ShareShare
ReportReport
Posted on by nokko 145

Hi,

I'm trying to import currency exchange rates from Reserve Bank of Australia but i'm encountering warning messages "An exchange rate could not be found for ISO currency codes AUD and EUR, on the following date: 4/09/2014. Verify the ISO currency codes that are supported by the provider and that are available for the requested date.", the warning message repeats for AUD vs GBP, AUD vs NZD and AUD vs USD, and then followed by "The following number of exchange rates were imported: 0".

Background :

I am using AX 2012.

1. GL -> Setup -> Currency -> Configure Exchange Rate Providers, i've added Reserve Bank of Australia, the preset Key/URL is http://www.rba.gov.au/rss/rss-cb-exchange-rates.xml

2. GL -> Setup -> Currency -> Currency Exchange Rates, Exchange Rate Type of Default, i have setup 4 Exchange Rate Pairs, From AUD to USD, From AUD to NZD, From AUD to EUR and From AUD to GBP.

3. GL -> Periodic -> Import Currency Exchange Rates, I choose Default for Exchange Rate Type, Reserve Bank of Australia for Exchange Rate Provider, leave "Import as at" as Today's date.  Did not tick both Create Necessary Currency Pairs and Override Existing Exchange Rates.

I then hit OK, and i get the above warning messages, and i go back to Currency Exchange Rates under Setup, nothing is being imported.

Has anyone performed the above and encountered the same results as me but manage to find a solution after?  My consultant told me something else needed to be setup and it will cost us, but i've read blog after blog on the internet, apparently that's all we need to setup above.

Cheers

Nokko

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,704 Super User 2025 Season 2 on at
    RE: Import Currency Exchange Rates from Reserve Bank of Australia

    Hi Nokko,

    I believe the Bank of Australia is not a standard provider in AX. It might be related to this object.

    Also check the currency pairs. Are they already setup? Probably the service requires it in reversed order. You can try to create a new exchange rate type and don't specify exchange rates or pairs in advance. Then import the rates for this new exchange rate type. Then see if you still can't import the rates.

    It is also possible that a proxy setting will block internet traffic to the xml file with the exchange rate information. Than you can also expect this similar error.

  • nokko Profile Picture
    nokko 145 on at
    RE: Import Currency Exchange Rates from Reserve Bank of Australia

    Thanks Andre for pointing the possible causes.  I have since dug out a little bit more and found that currently proxy is not setup to allow AX to talk to the outside world, and highly unlikely that it will ever be setup in the future due to security reason, therefore the import from the RBA (Reserve Bank of Aust) external website method will no longer be an option :(

    The website does provide a csv file for me to download (www.rba.gov.au/.../historical-data.html, where it says "Exchange Rates - Daily - 2014 to Current

    " ) but is there a way to load this file into AX or is this not an out of the box feature and require a script to be written by the developer to do so?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,704 Super User 2025 Season 2 on at
    RE: Import Currency Exchange Rates from Reserve Bank of Australia

    Hi Nokko,

    Indeed AX exchange rate providers are not proxy aware. If you are able to create an exception, this would be the preferred solution.

    Otherwise you can change the exchange rate provider. We got a code suggestion from Microsoft on the Central Bank of Europe provider. This is a .net variant of the provider. A similar method could be used with x++ providers.

    Please locate in AX AOT: \visual studio projects\c sharp projects\exchangerateprovider and open this in VS2010.

    In project there is folder “providers” and inside Class “CentralBankOfEuropeProvider” and I would start with following modification:

    In method:

      private bool TryForUrl(ExchangeRateRequest request, ExchangeRateResponse external, bool useCurrentUrl)

           {

               DateTime dateValue = DateTime.Now;

               string dateString = null;

               string rateString;

               decimal rateValue;

               string currency;

               ExchangeRateResponseCurrencyPair currencyPair;

               ExchangeRateResponseExchangeRate exchangeRate;

               HttpWebRequest webRequest;

               HttpWebResponse webResponse;

               bool foundDate = false;

               string urlToUse;

               if (useCurrentUrl)

               {

                   urlToUse = serviceUrl;

               }

               else

               {

                   urlToUse = historicalServiceUrl;

               }

               // Request and read the data from the web server

               webRequest = (HttpWebRequest)HttpWebRequest.Create(urlToUse);

               webRequest.Proxy = new WebProxy("address", true, null, new NetworkCredential("user", "password", "domain"));

               webRequest.Timeout = timeout;

    You can create a paramter somewhere to store the credentials and encrypt the password, otherwise you have to hardcode it.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans