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

Notifications

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... / HMRC currency exchange...
Small and medium business | Business Central, N...
Suggested Answer

HMRC currency exchange rate service

(0) ShareShare
ReportReport
Posted on by AntonioKD 416

Hello everyone! 

I want setup monthly currency exchange rate service from HMRC in UK. Is anyone able to tell me what I,m doing wrong :( 

pastedimage1628150651627v1.png

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

    Hello David,

    I don't see the date in that xml, only the period and wonder if we can get this to work.
    Or do you use a single rate for the entire month.

    Or could floatrate be an option for you?
    XML Daily Foreign Exchange Rates for U.K. Pound Sterling (GBP) (floatrates.com)

    Thanks
      Dirk

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    David,

    Here is my handout on setting up Float Rates.

    7750.FloatRate-Setup.docx

    Thanks,

    Steve

  • AntonioKD Profile Picture
    AntonioKD 416 on at

    Dirk, I want to use a single rate for entire month. But I don't know how to set up this.

  • Suggested answer
    Dirk Profile Picture
    Dirk on at

    Hi David

    hmmm ... I think most customers would than rather do it manually instead using the service.

    However with the setup below ( I left the date/period blank) I do get the rates ... as per today ...

    pastedimage1628681133838v1.png

    pastedimage1628681162687v2.png

  • Community Member Profile Picture
    Community Member on at

    I manage to make it work, importing and running the service all fine. But when check the orders in foreign currency I find that the exchange rates is inverted. So is there a way to invert the exchange rates without coding?

  • pwamenear Profile Picture
    pwamenear 5 on at

    Either apply a transformation rule, or perhaps try flipping the source for Exchange Rate Service and Relational Exch. Rate Amount.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans