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

HMRC currency exchange rate service

(0) Share

Report

Posted on by AntonioKD

410

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)

pwamenear 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Dirk on at

Like (0)

Report

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

Was this reply helpful? Yes No
AntonioKD 410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: HMRC currency exchange rate service

David,

Here is my handout on setting up Float Rates.

7750.FloatRate-Setup.docx

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

Dirk on at

Like (0)

Report

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

Was this reply helpful? Yes No