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

Problem with currencies.

(0) Share

Report

Posted on by AntonioKD

418

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?

I have the same question (0)

All responses (3)

Answers (0)

Gavin 2,508 on at

Like (1)

Report

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

Was this reply helpful? Yes No
AntonioKD 418 on at

Like (0)

Report

Thank ypu so much! It works :)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No