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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / ECB Exchange Rate Serv...
Small and medium business | Business Central, N...
Suggested Answer

ECB Exchange Rate Service: only imports first rate

(0) ShareShare
ReportReport
Posted on by intelligo 40

I have followed the steps in the video on https://docs.microsoft.com/en-us/dynamics365/business-central/finance-how-update-currencies

to setup the ECB service. See below. 

But when running the job, it only imports the first exchange rate, in this case USD. Not any other rate in the xml https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml

Any clue what might be wrong?

pastedimage1600946122911v1.png

I have the same question (0)
  • Suggested answer
    Dirk Profile Picture
    Dirk Microsoft Employee on at

    Hi Maarten,

    Which local version and which product version do you work with?

    Did you try with a work date as per today ?

    Thanks

     Dirk

  • intelligo Profile Picture
    intelligo 40 on at

    Dirk, I am using a BC insider 17 inside a docker with 'Base' as localization, because that default has company 'Cronus Internationl Ltd.' in it.

    Version: W1 17.1 (Platform 17.0.16960.0 + Application 17.1.16985.0)

    Azure AD tenant: (blank), Environment: Sandbox (Sandbox)

    What do you mean with 'work date as per today'?

  • Suggested answer
    Dirk Profile Picture
    Dirk Microsoft Employee on at

    Hi Maarten,

    From looking at your initial screenshot I see the comment ... work date is 24th October 2030.

    Maybe there are no ex.rates to be expected using that date as workign date.

    If you change the working date to TODAY ... Do you get a better result?

  • intelligo Profile Picture
    intelligo 40 on at

    Hi Dirk,

    Changing the workdate to today does not make any difference.

    It seems like there is a filter somewhere, but I can't find any in the Data Exchange settings.

  • Dirk Profile Picture
    Dirk Microsoft Employee on at

    Hi Marten,

    I do get:

    pastedimage1601412644868v1.png

    For the parent node I used:

      /gesmes:Envelope/Cube/Cube/Cube

  • intelligo Profile Picture
    intelligo 40 on at

    Thanks Dirk. That did the trick!

    I will ask MS to update their video on: https://docs.microsoft.com/en-us/dynamics365/business-central/finance-how-update-currencies

  • achilles1988 Profile Picture
    achilles1988 30 on at

    How do you tell BC what currencies you actually want to map in? Let's say I only want to map in EUR, GBP and USD currencies for example.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,772 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,056 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 662 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans