Import Currency Exchange Rates Central Bank of Europe from site in Ax2012 R2

(0) Share

Report

Posted on by Aijaz

Hi,

when we tried to import using provider setup we facing following warning and exchange rate is not import

see following warning

" An exchange rate could not be found for ISO currency codes CNY and USD, on the following date: 8/3/2015. Verify the ISO currency codes that are supported by the provider and that are available for the requested date.

An exchange rate could not be found for ISO currency codes EUR and DKK, on the following date: 8/3/2015. Verify the ISO currency codes that are supported by the provider and that are available for the requested date.

The following number of exchange rates were imported: 0"

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

RamK 2,580 on at

Like (0)

Report

Refer community.dynamics.com/.../139307

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Muhammad,

Is the date 8/3 in this case 8 March or 3 August?

If it is March, it is related to having a date in a weekend. The exchange rate provider from the CEB does not have exchange rates.in a weekend.

It has been a while ago, but I thought all currency pairs that are in the exchange rate type, but noy in the provider will generate a warning, indicating that you have to review them manually. This is valid for CNY and USD.

For the EUR and DKK you need to check if the date was March or August. If it was August, you need to verify if e.g. a proxy server or firewall is blocking traffic.

Otherwise you can try to download the file with exchange rates manually and check if there might be an entry missing for DKK. Never experienced missing entries before.

Was this reply helpful? Yes No
Aijaz on at

Like (0)

Report

Hi André,

Thanks for reply it's 3 August 2015.What about your suggestion in this link ?https://community.dynamics.com/ax/f/33/t/139307

on thing How i can check proxy and firewall traffic could you please guide me?

Regards,

OxyAsol2013

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Muhammad,

If it never worked at this location before, it is likely related to the proxy settings. When we found out it was not working I asked a network engineer to monitor this traffic. I don't know which tools were used, we then only got the result that it was blocked by the proxy as AX did not add the user information when starting the communication.

You can ask someone at the customer or in your organization to do some monitoring on network traffic.

Probably SysInternals tools can help you. technet.microsoft.com/.../default

Was this reply helpful? Yes No
Aijaz on at

Like (0)

Report

Hi André ,

I have checked proxy and firewall it's block that site so how i can fixed this issue?

Regards,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Muhammad,

First you can check if you are able to access the xml file on the internet yourself, by copying the URL from the data provider.

If this is working, you can create a new empty exchange rate type and try to use the provider including the setting to create currency pairs. Try to set a date range so it can try to find rates for several days. (The maximum is 30 or 31 days, but 4-5 days would be sufficient).

If this is not working, for sure the internet connection is blocked somewhere... If you can access it yourself but AX won't retrieve anything it should be related to proxy or firewall settings. Probably anti virus software can also block network traffic.

Was this reply helpful? Yes No
Aijaz on at

Like (0)

Report

Hi André,

I have checked on my dev as well as on Test it's work fine but on production it's give me above issue on all server's have standared code no customization involve we have checked on production sites are not block.

Regards,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Muhammad,

I think the best you can do is work together with a network engineer to find out why it is not getting the information from the internet on the production machine(s). The network is the only reason. The data provider should work without issues if the internet is accessible.

Was this reply helpful? Yes No
Verified answer

Aijaz on at

Like (0)

Report

Hi All,

Thanks for reply André,

Issue is solve. Issue was data due to wrong currency setup that's why exchange rate not imported in Ax.

Regards,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Muhammad,

Interesting.... can you elaborate on the details what exactly was wrong?

Was this reply helpful? Yes No