an exchange rate could not be found for iso currency code usd and cad on the following date

(0) Share

Report

Posted on by Community Member

I try to import new exchange rates but I get a long list of warnings/errors, an d at the end it says no exchange rates have been imported.

i will post some screenshots of how my exchange setup looks like.

When I try to open the ServiceURL in my browser I get an error 404. (www.nationalbanken.dk/.../valutakurser.xml)

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

If you try to import data from invalid URL, it's no surprise that it doesn't work. Change the URL to a valid address.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin

I have corrected the URL, but I still get the same error.

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

Like (0)

Report

Hi Mahyar,

Please check if some traffic is blocked by a firewall or proxy settings. This was a reason at some customers where I have faced the same problem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André I think you are right. I will talk to the Operation department tomorrow and I will let you know.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André

It seems that the URL is open and no firewall is blocking it, when I try to open the url on the server. But I still get the same error in AX. Should I create a new "Inbound port" in AX maybe?

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

Inbound ports are used for exposing AX services to other applications, which is completely opposite to what the import does. It can't help you in any way.

Instead, ensure yourself that the service returns correct data (namely rates for USD and CAD). If not, they obviously can't be imported. If they're there, debug the code that import it to AX.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin

the service returns the correct exchange rates when I try it in the browser. But it seems that AX doesnt read them correctly.

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

Like (0)

Report

Hi Mahyar,

Or you try to import exchange rates on a date in a weekend or the service cannot connect to the internet. At a customer we had the same experience where a user on the AOS was able to open the web URL, but still the service raised an error. It appeared that the AOS service account did not have internet access due to proxy settings. AX is not proxy aware. We modified the coding of the exchange rate provider to provide login details so it could pass the proxy server.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can I ask you which class/form you did modify to solve the problem?

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

Like (0)

Report

Hi Mahyar,

The change was done in Visual Studio as the problem was related to the ECB provider which was built in .NET. Is your provider created in x++ or using .NET?

Was this reply helpful? Yes No