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?
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.
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
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
did you use the currency - process - adjust exchange rate?
then you will se the next image
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
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
Hi, There are two ways to try it out.
1. Reverse Transaction... in General Ledger Entries.
2. As Josh mentioned, Reverse Register... in G/L Registers
Hope this helps as well.
Thanks.
ZHU
Try going to g/l register and locating the posting. From there you should find a reverse feature
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156