Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Differences between the Default currency and the foreign currency in trial balance

Posted on by 16
I have a Client who has never adjusted exchange rates since 2016.  What is the best way to adjust these on the balance sheet from 2016 to 2023?
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,152 Super User 2024 Season 2 on at
    Differences between the Default currency and the foreign currency in trial balance
    you could set up correct exchange rates for the closed year and run the batch job to test in a sandbox, post to see if issue could be fixed. if this doesn't work, then they may need to figure out other ways to fix the financials in other ways. 
  • Community member Profile Picture
    Community member 16 on at
    Differences between the Default currency and the foreign currency in trial balance
    Since the Client closed 2016-2023 should they run the adjust exchange rates for 2024 for all years and use the end date 12/31/24 this year end?  Or just forget about the closed years and start with the current year and run the adjust exchange rates going forward?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 70,059 Super User 2024 Season 2 on at
    Differences between the Default currency and the foreign currency in trial balance
    Hi, unfortunately, as far as I know this cannot be done.
    Even if you correct, the posting date can only be set for an unclosed fiscal year, such as this year.
    And if the past financial statements have been closed, I personally do not recommend adjusting to the previous date....All reports need revision....
     
     
    Thanks.
    ZHU
  • Community member Profile Picture
    Community member 16 on at
    Differences between the Default currency and the foreign currency in trial balance
    The Client has closed all fiscal years through 2023, but never ran the adjust exchange rates.  Is it possible to correct now with a JE
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 70,059 Super User 2024 Season 2 on at
    Differences between the Default currency and the foreign currency in trial balance
    Hi, if you have never closed a fiscal year, you can run the Adjust Exchange Rates report on the system going back to 2016. Generally this needs to be run once a month and all financial statements in your finance will need to be adjusted.
    If you have closed a fiscal year before 2023, this cannot be adjusted in the closed year.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 9,676 Most Valuable Professional on at
    Differences between the Default currency and the foreign currency in trial balance
    Hi
    You can execute the process for the years that have not been executed, you must take into consideration some premises, also verify if you have closed periods, currently the functionality allows you to preview the registration, so you could analyze the impact.
    I'll give you some links so you can review it, I hope it helps you a little.
     
    best regards
    Gerardo

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans