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... / Currency Exchange Issue
Small and medium business | Business Central, N...
Suggested answer

Currency Exchange Issue

(1) ShareShare
ReportReport
Posted on by Jack Carter 110
Hi Community, We are facing an issue in our Business Central setup related to currency exchange rates. Our local currency is set as US Dollar (USD), and the additional currency is set as Canadian Dollar (CAD). To maintain the exchange rates, we update the currency exchange rates at the end of each month and then run the "Adjust Exchange Rates" functionality. However, after running the adjustment for this month, we noticed a discrepancy in one of our chart of accounts, specifically a G/L account for one of our banks. The issue is as follows:
1.The balance in the local currency (USD) shows as a positive amount.
2.The balance in the additional currency (CAD) shows as a negative amount.
3.The difference between the two balances is significant and appears to be incorrect.
We have checked and verified the exchange rates and their adjustments, but the discrepancy still persists. Could anyone help us identify the cause of this issue and suggest a way to resolve it?
 
Categories:
Dynamics 365 Business Central
Capture1.PNG
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 9,702 Super User 2025 Season 1 on at
    Currency Exchange Issue
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,799 Super User 2025 Season 1 on at
    Currency Exchange Issue
    When you ran Exchange Rates Adjustment function, did you select the option to adjust additional reporting currency?
     
     
    When you mentioned you checked the exchange rates used, did you check the adjustment column (highlighted yellow below):
     
     
     
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 1,434 on at
    Currency Exchange Issue
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,097 Super User 2025 Season 1 on at
    Currency Exchange Issue
    This is hard to tell, you can export all the details to compare.
    If the difference is large, the possibility of manual posting cannot be ruled out.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 15,635 Most Valuable Professional on at
    Currency Exchange Issue

    Hi, good day
    I hope this can help you, and give you some hints.

    Set up bank accounts - Business Central | Microsoft Learn

     With foreign currency bank accounts, direct posting results in differences that accumulate as you post more bank reconciliations. 

    Best Regards
    Gerardo

  • Jack Carter Profile Picture
    Jack Carter 110 on at
    Currency Exchange Issue
    @Yi Yong 
    Hi Community, We are facing an issue in our Business Central setup related to currency exchange rates. Our local currency is set as US Dollar (USD), and the additional currency is set as Canadian Dollar (CAD). To maintain the exchange rates, we update the currency exchange rates at the end of each month and then run the "Adjust Exchange Rates" functionality. However, after running the adjustment for this month, we noticed a discrepancy in one of our chart of accounts, specifically a G/L account for one of our banks. The issue is as follows:
    1.The balance in the local currency (USD) shows as a positive amount.
    2.The balance in the additional currency (CAD) shows as a negative amount.
    3.The difference between the two balances is significant and appears to be incorrect.
    We have checked and verified the exchange rates and their adjustments, but the discrepancy still persists. Could anyone help us identify the cause of this issue and suggest a way to resolve it?
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,917 Super User 2025 Season 1 on at
    Currency Exchange Issue
    Hello,
     
    Can you provide more information?
     
    You are showing the revenue G/L accounts and these are credit by nature.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans