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

Problem with currencies.

(0) Share

Report

Posted on by AntonioKD

322

Hello!

I work on BC with UK localization and I have a problem with currencies that I download from HMRC. For example, Exchange Rates for PLN is 5.352 what is compatible with exchange rates from HMRC:

But when I post an invoice in PLN in UK where local currency is GBP, the calculed amount from 1000PLN is 5352GBP! It should be 188,9GBP. The system does not calculate and think that 1PLN is 5.352GBP instead of 0.186GBP.

WHere should I correct the setup?

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Problem with currencies.

David,

You want the Exchange Rates to appear like this:

In the Currency Exch Rate Service I have mine with Float Rates.com:

Hope this helps.

Thanks,

Steve
AntonioKD 322 on at

Like (0)

Report

RE: Problem with currencies.

Thank ypu so much! It works :)
Gavin 2,341 on at

Like (1)

Report

RE: Problem with currencies.

Hi,

For the amounts to calculate as you describe you need to have the GBP of 1 in the "Relational Exch. Rate Amount" and the rate of 5.352 in the "Exchange Rate Amount". (so basically swop those columns around)

This article I wrote gives my take on how the exchange works:

http://thedynamicsexplorer.com/2021/02/26/dynamics-365-business-central-making-sense-of-the-currency-exchange-rates-page-when-setting-exchange-rates/

I hope this helps.

Thanks

Gavin