Skip to main content

Notifications

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

adjust GL account exchange rates in Business Central

(1) ShareShare
ReportReport
Posted on by 2

I understand that you can adjust exchange rates for Customer, Vendor & Bank accounts. How can i adjust GL account with the exchange rate? Does it have to be done manually?

  • Suggested answer
    Gavin Profile Picture
    Gavin 2,350 on at
    adjust GL account exchange rates in Business Central
    Hi,
     
    Currently you can only revalue Customer, Vendor and Bank Account ledger entries. You can't revalue GL entries as the foreign currency amounts aren't held on the GL entries. However looking at the release plan this is set to change in the next release (2024 wave 1)
     
    With regards additional reporting currency, you can set one reporting currency in the GL setup. This will be recorded, along with the local currency, in the GL entries. You can revalue it using the option you mention in the "Adjust Exchange Rates" batch job.
     
    Hope this helps
     
    Thanks
    Gavin
  • CU26112018-0 Profile Picture
    CU26112018-0 20 on at
    adjust GL account exchange rates in Business Central
    I have a Client that has never ran the exchange rate adjustment and the year is closed.  Can you tell me how to adjust GL Entries.  On the Adjust Exchange Rate batch job there is a field for Adjust G/L Accounts for Add.-Reporting Currency what does this accomplish?
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 995 Super User 2024 Season 1 on at
    RE: adjust GL account exchange rates in Business Central

    As Gavin says it is only some balance accounts that are adjusted by the procedures in Business Central. Income and expense accounts are typically never adjusted for currency fluctuation.

    Here are a link to the some documentation around the process:

    learn.microsoft.com/.../

  • Verified answer
    Gavin Profile Picture
    Gavin 2,350 on at
    RE: adjust GL account exchange rates in Business Central

    Hi,

    Yes, you can adjust exchange rates for Customer, Vendor and Bank Account ledger entries. I recently wrote this blog post that walks through the process

    https://thedynamicsexplorer.com/2022/12/14/dynamics-365-business-central-walking-through-an-adjust-exchange-rates-revaluation-scenario-in-business-central/

    With regards GL accounts, there is currently no functionality to revalue a GL account. This is because the foreign currency amounts aren't stored in the General Ledger Entries. Therefore you can only revalue Customer, Vendor and Bank Accounts.

    Hope this helps.

    Thanks

    Gavin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans