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

Cannot Reverse a payment due to Forex Gain/Loss

(0) Share

Report

Posted on by PaulRoots

Hi Guys,

May I ask if you have encountered this issues?

Thanks in advance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Olister Rumao 4,009 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Paul this issue is because you might have done a Forex transaction and the Currency Exchange Rate must have changed.

So Business Central will automatically post this entry to match with your Forex Currency and Local Currency as per the Exchange Rate.

What you can do is unapply this entry with the reconciled transaction and settle this payment by creating a Purchase Journal and settle with the current Payment.

Or you can create a reversing entry using General Journals and settle the Payment with this General Journal Entry.

Was this reply helpful? Yes No
Suggested answer

MichaelFurness 50 on at

Like (0)

Report
Copy link

Link copied!

Only time I've ever seen this message is when the Exchange Rate on the Document is different to the Exchange Rate on the Payment. It posts the application and the Realised Gain/loss at the same time. BC (and also NAV) can't just reverse this transaction for some reason when you want to reverse the entry but it will reverse the Gain/loss if you unapply the entries first. After that you can post new entries and apply the correct ones together.

Was this reply helpful? Yes No
joshtechsolutions 4,999 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I tried this method, but I was not able to unapply any of the entries and informed of the error below.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, just adding some information.
This major update (BC23) has the following feature. I'm not sure if it can solve your problem, but you can try again after upgrading to BC23.

Use realized gain or loss entries to reverse ledger entries

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/reverse-customer-vendor-ledger-entry-realized-gain-or-loss-entry?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No