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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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 10,184 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 102,031 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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,690 Super User 2026 Season 1

#2
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,091 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,047 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans