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
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
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
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.
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.
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
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
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
