Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Adjust Exchange Rate - Reverse My Entry

(0) ShareShare
ReportReport
Posted on by 30

Hi

I believe i ran the adjust exchange rate incorrectly...  I now have a huge PL variance and the rates are still not correct.  Forum members said to leave the beginning date blank, and do "no adjustment" for the PL accounts.  

Is there a way of reversing the original entry?  

  • Suggested answer
    Francisco Bedolla Profile Picture
    Francisco Bedolla 1,117 on at
    RE: Adjust Exchange Rate - Reverse My Entry

    Sorry, but I put those links because im trying to show you how difficult is this and that microsoft doesnt have a real solution since nav2009.

    I Dont understand why the accounting people doesnt catch the wrong data in the closing month procederes.

    The bad news is, you cannot revert those entries

    The wrong news are, Even using a developer you cannot trace the change entries

    The not so bad news are, you can calculate manually the amount deviation and create an adjustment jornal every month till you finish to pay or receive those wrong invoices, I hope that only exists one wrong calculation run and the next ones are fine. That happens to a customer few years ago and that was rhe only solution, a jornal for fix the account balance and balance control per documento per customer/vendor.

    There is no other way.

    And yes, microsoft should create a reverse function in first place.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,909 Super User 2025 Season 1 on at
    RE: Adjust Exchange Rate - Reverse My Entry

    Hi, I believe no developer will choose the developer route you mentioned, it will be very difficult and affect data consistency.
    Sorry I'm not a financial professional, but why can't you just use the General Journal to adjust the difference directly to the current month? Did the auditor say it had to be adjusted to three months ago? Although not recommended, you can also reopen the accounting period that was three months ago and do Reverse.

    Hope this helps as well.

    Thanks

    ZHU

  • RE: Adjust Exchange Rate - Reverse My Entry

    Yes... I ran the adjust exchange rate.

    So it is either have a developer remove the entry from all the tables, or revert to a previous instance of the company?  The problem with the latter is, we didn't realize it was wrong until now.  It has been almost 3 months.  So I would have to redo all the entries from that point until now.

    For the developer route- how precarious is this?  is there a chance something can go wrong?

    Thanks

  • Verified answer
    Francisco Bedolla Profile Picture
    Francisco Bedolla 1,117 on at
    RE: Adjust Exchange Rate - Reverse My Entry

    did you use the currency - process - adjust exchange rate?

    pastedimage1658202286156v1.png

    then you will se the next image

    pastedimage1658202483977v2.png

    you cannot "reverse" this kind of entry. why? because this job create gl entries but also make changes in the customer or vendor registers abd banks

    you can see here the correct process How to Adjust Open Entries Exchange Rates in Dynamics 365 Business Central - Encore Business Solutions

    IrishPaul answer someting  in 2009 (+) How to Reverse Adjust Exchange Rate batch job? - Microsoft Dynamics NAV Forum Community Forum but isnt supported by microsoft

    and here is a document  about this problem, also 2009

    How Adjust Exchange Rates affects posted entries - Dynamics NAV | Microsoft Docs but this doc only provides you information about why thsi process is irreversible

    pastedimage1658202848015v3.png

    Sorry but is not that easy as "you just need to reverse entry", maybe you can restore the company to a previous point before the job run you can have an option

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,909 Super User 2025 Season 1 on at
    RE: Adjust Exchange Rate - Reverse My Entry

    Hi, There are two ways to try it out.

    1. Reverse Transaction... in General Ledger Entries.

    pastedimage1658191202957v1.png

    2. As Josh mentioned, Reverse Register... in G/L Registers

    pastedimage1658191251373v2.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: Adjust Exchange Rate - Reverse My Entry

    Try going to g/l register and locating the posting. From there you should find a reverse feature

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans