Skip to main content

Notifications

Business Central forum
Suggested answer

Problem with currencies.

Posted on by 312

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:

pastedimage1632811635322v1.png

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?

pastedimage1632811884180v2.png

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with currencies.

    David,

    You want the Exchange Rates to appear like this:

    pastedimage1632853309067v1.png

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

    pastedimage1632853388657v2.png

    Hope this helps.

    Thanks,

    Steve

  • AntonioKD Profile Picture
    AntonioKD 312 on at
    RE: Problem with currencies.

    Thank ypu so much! It works :)

  • Gavin Profile Picture
    Gavin 2,333 on at
    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

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,969 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans