Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Exchange rate service

Posted on by 2
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!
 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,726 Super User 2024 Season 2 on at
    Exchange rate service
    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.
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 6,881 Super User 2024 Season 2 on at
    Exchange rate service
    is it possible to use a 3rd party app to do the exchange service? it will be lot easier then manual setup.
     
    Jun Wang
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,660 Super User 2024 Season 2 on at
    Exchange rate service
    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
  • ML-21050529-0 Profile Picture
    ML-21050529-0 2 on at
  • Exchange rate service
    Hi,
     
    I have the same issue - the field caption doesn't not appear properly:
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,533 Super User 2024 Season 2 on at
    Exchange rate service
    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)
     
     
    Thanks
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 8,734 Most Valuable Professional on at

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,126 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans