Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How to get daily exchange rate into AX 2012?

Posted on by Microsoft Employee

In AX 2012 there are 3 service providers for daily exchange rate, but that requires the server to have internet access which currently disabled, also those service provider's currency pair is not as what we required.

How to setup the system to get daily exchange rate from Bloomberg? Shall AX get access to Internet, or take data downloaded from Bloomberg? We are thinking to build an fully automated process without manual download an import.

Thanks

Grace Dai

*This post is locked for comments

  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,261 User Group Leader on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Grace,

    Please check these link as well,

    Creating Exchange Rate Providers for Microsoft Dynamics AX 2012

    www.microsoft.com/.../details.aspx

    community.dynamics.com/.../101445.aspx

    www.dynamicsteaching.com/how-to-set-up-exchange-rate-in-ax-2012

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Andre,

    Thanks so much for following up on this one! Yes I got reply also from our colleague that we do use daily rate data/file from Bloomberg with charges.  It is the format and mechanism to get that info into AX the next challenge.

    Cheers

    Grace Dai

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Grace,

    I just talked with a colleague and indeed Bloomberg provides exchange rates. They have about all currency pairs, but the service is not free. I understood you have to pay per download.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Grace,

    I just talked with a collegue and indeed Bloomberg provides exchange rates. They have about all currency pairs, but the service is not free. I understood you have to pay per download.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get daily exchange rate into AX 2012?

    Thanks very much Andre and Venkatesh for your advice.

    I read the AX documents mentioned about the same solution per Andre's, condition is server need to have Internet.  Another solution would be as Venkatesh suggested: Get the file (xml) from service provider to our another server which has internet, then AX server write a custom program to pickup this file on that server within LAN.

    For Bloomberg - Yes think they do provide daily rate, subject to company's agreement.

    Will discuss these options with our Infra team, and hopefully we could build this in our AX.

    Cheers

    Grace Dai

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Grace,

    If you don't want AX to get access to Internet, then you could setup SFTP or other file transfer mechanism (outside of AX) to download FX rates file from Bloomberg to a network folder location. Then you can build a new provider in AX 2012 which will read the file from the network path and import rates into AX on a daily basis. The dependency could be FTP job should get completed before AX batch job start time.

    Apart from whitepaper link provided by Andre, you can refer an article by Munib about this topic. The file format could be CSV/XML.

    community.dynamics.com/.../import-exchange-rate-from-files-ax-2012.aspx  

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: How to get daily exchange rate into AX 2012?

    Hi Grace,

    If you need the Bloomberg rates, you first have to know if they provide a service (e.g. xml format) I'm not sure if they have one.

    If they do have it you can create a new exchange rate provider.

    A batch job can be scheduled to have the daily rates. The server where the batch is running, should have access to Internet then.

    There is a whitepaper how to develop new exchange rate providers. www.microsoft.com/.../details.aspx

    The rates and currency pairs are dependent on the exchange rate provider (source file). these can be different per provider. So probably if the Bloomberg service exists, you can get the required currency pairs.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans