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

Notifications

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 8
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,909 Super User 2025 Season 2 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 95,729 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans