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 382

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

  • pwamenear Profile Picture
    pwamenear 5 on at
    RE: HMRC currency exchange rate service

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

  • Community Member Profile Picture
    Community Member on at
    RE: HMRC currency exchange rate service

    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?

  • Suggested answer
    Dirk Profile Picture
    Dirk on at
    RE: HMRC currency exchange rate service

    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

  • AntonioKD Profile Picture
    AntonioKD 382 on at
    RE: HMRC currency exchange rate service

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: HMRC currency exchange rate service

    David,

    Here is my handout on setting up Float Rates.

    7750.FloatRate-Setup.docx

    Thanks,

    Steve

  • Suggested answer
    Dirk Profile Picture
    Dirk on at
    RE: HMRC currency exchange rate service

    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2025 Season 1

#2
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 249

#3
Mansi Soni Profile Picture

Mansi Soni 247

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans