Small and medium business | Business Central, N...

Exchange rate service

(1) Share

Report

Posted on by Community member

Hi All

I am trying to setup an automated feed of exchange rates from ECB. It should be easy, there is even a video from Microsoft how to set it up, but I am totally stuck even before I start the field mapping - I have nothing to map the xml file to.

I have no attributes predefined in the system (called Captions in the table).

My currency exchange rate service page for the ECB source looks like this:

It is not as simple as clicking on the link and select from a popup. A popup opens, but the system doesn't save whatever I select there. The popup doesn't even all fields needed (e.g. Parent Node for currency code), so this needs to be defined elsewhere.

Can you please tell me how to get this populated:

I have GL settings - local CCY selected (CHF in our case), I have got several other currencies in the currency table, the link to ECB rates is correct.

I have got the same issue in Cronos company, and also in a new free trial - everything opens without the defined Captions.

Thanks in advance for any hint!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (0)

Report

Hello, i hope this can help something

https://www.youtube.com/watch?v=_WxMJJwbBEc

https://usedynamics.com/business-central/finance/exchange-rate-services/

best regards

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I have done a detailed test before and hope it can give you some tips.

Automate Currency Exchange Rate Updates (Currency Exchange Rate Services and Transformation Rules)

https://yzhums.com/7341/

Thanks

ZHU

Was this reply helpful? Yes No
Community member 4 on at

Like (0)

Report

Hi,

I have the same issue - the field caption doesn't not appear properly:

Was this reply helpful? Yes No
ML-21050529-0 2 on at

Like (0)

Report

have you tried

https://appsource.microsoft.com/nl-nl/product/dynamics-365-business-central/PUBID.bluacebv1606380518217%7CAID.bluace_ecb_exchange_rate_converter%7CPAPPID.3b238358-2c6e-49da-a13e-18f26de9310f?tab=DetailsAndSupport

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

This seems like a bug from Microsoft... I see that this was ok in version BC21, and starting from BC23 the field captions are not showing correctly.
But I think it still goes the same way:
Parent node

Currency code
Starting Date
Exchange rate amount
Relational Exchange rate amount

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (1)

Report

is it possible to use a 3rd party app to do the exchange service? it will be lot easier then manual setup.

Jun Wang

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

Starting with V23 you can simply ignore the Caption column/fields. Simply do everything in the Source column as before. That's all, the setup is still going to work. I would recommend setting up a service as its very simple rather than clutter your system with 3rd party apps.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
GL-16121042-0 6 on at

Like (0)

Report

Hi

Trying to follow this but its not clear for me as it wont let me leave the source in the 5th line blank in order to put 1 in the relational currency box. As shown below. Are Microsoft fixing this issue?

As such i dont get the 1 on the relational currency as below

Was this reply helpful? Yes No