Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
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!
 
Categories:
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 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 7,443 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,934 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 73,696 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 12,183 Most Valuable Professional on at

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans