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

HMRC currency exchange rate service

(0) Share

Report

Posted on by AntonioKD

432

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 :(

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

David,

Here is my handout on setting up Float Rates.

7750.FloatRate-Setup.docx

Thanks,

Steve

Was this reply helpful? Yes No
AntonioKD 432 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 ...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
pwamenear 5 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No