Adjust Exchange Rate - Reverse My Entry

(0) Share

Report

Posted on by paul.asaro@equiteq.com

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?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

JAngle 119 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,445 Super User 2025 Season 2 on at

Like (0)

Report

RE: Adjust Exchange Rate - Reverse My Entry

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

Was this reply helpful? Yes No
Verified answer

Francisco Bedolla 1,119 on at

Like (1)

Report

RE: Adjust Exchange Rate - Reverse My Entry

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

Was this reply helpful? Yes No
paul.asaro@equiteq.com 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,445 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Francisco Bedolla 1,119 on at

Like (0)

Report

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.

Was this reply helpful? Yes No