web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adjust exchange rate t...
Small and medium business | Business Central, N...
Suggested Answer

Adjust exchange rate to Additional report Currency

(3) ShareShare
ReportReport
Posted on by PM-27041506-0 41
Dear All ,

I have 1 question about the business central , My local currency (LCY) is MMK. And additional reporting currency is USD.
so i have MMK transaction , at the end of the month i have to adjust the ACY amount because usd exchange rate is different . So how do i adjust ACY in the case?

Example 
Exchange rate 1 usd =3200mmk, Month end rate 1usd=3500mmk
Purchase Invoice amount =100000 lcy , so that ACY is 31.25 
At the end of month i need to adj ACY amount because rate is 1usd=3500mmk

 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Mansi Soni Profile Picture
    Mansi Soni 8,951 Super User 2026 Season 1 on at
    Hello,

    If a purchase invoice of 100,000 MMK was originally recorded at a rate of 1 USD = 3200 MMK (resulting in an ACY amount of 31.25 USD), and the month-end rate changes to 1 USD = 3500 MMK, the ACY equivalent would now be 28.57 USD, creating an unrealized loss of 2.68 USD.
     
    To handle this adjustment, first, update the USD exchange rate in the Currency Exchange Rates page, entering the new rate (3500) with the applicable starting date (e.g., 31/05/2025).

    Then, run the "Adjust Exchange Rates" batch job from the search bar. In the adjustment window, specify the posting date range, select the adjustment type as "Adjust Additional-Currency Amounts," and enable adjustments for customers, vendors, G/L accounts, and bank accounts.

    Once executed, Business Central will automatically post the required adjustment entries to reflect the new ACY values based on the updated rate, ensuring your financial reports are accurate and comply with currency revaluation standards.

    Hope this answer will help you!

    Regards,
    Mansi Soni
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at
    Hi, There is only one way to adjust the exchange rate in BC.
    More details:
     
    The only thing you need to pay attention to is the exchange rate of the adjustment date.
    Generally, the real exchange rate for the day should be used, but you can also modify it to suit your needs.
     
    Hope this can give you some hints.
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans