205
Hi MS Dynamics NAV Community,
Please Help...
I would like to know if there is a way to reverse a customer payment transaction with a Realized Gain/Loss entry?
*This post is locked for comments
Hi there,
well. The reversal logic is doing a check for entries that are no issue. And it is missing checks that are an issue. With the proposed fix your reversal would post, as long as you don't have adjustments from the "Adjust Exchange Rates" batch.
with best regards
Jens
Hi there, is there anybody who can explain the procedure for doing this in layman's terms? I'm having the same issue and am running NAV 2013.
Hi,
this is a known bug in NAV2013 and higher. An analysis is here: www.mibuso.com/.../viewtopic.php There is also a proposed fix for it, it's working nicely.
with best regards
Jens
Hi Jiju,
If i unapply the payment to the sales invoice it still is reflected in the customer ledger entry and is considered as a payment made by a certain customer but not applied to an invoice. Both sales invoice and payment is floating in the customer ledger entry because there are no transaction made that closes it.
Thanks..
DDMDII,
You don't need to reverse..
Unapplying itself reverses the transaction
Hi Saurabh,
The Realized Gain/Loss entry is reflected due to the Invoice transaction date differ from the payment date by month and that the currency exchange rate setup is not the same on the invoice and payment dates. (example Sales Invoice date = January 1 with a currency exchange rate of 50 / Cash Receipt date = March 1 with a currency exchange rate of 55)
Yes.. I did unapply the entries on the customer ledger entries then when i am reversing the payment a message prompts "You cannot reverse the Cust. Ledger Entry No. --- because the entry has an associated Realized Gain/Loss entry.", meaning that the exchange currency rate of the invoice is different from the exchange currency rate of the payment and a realized gain/loss entry is reflected.
Thanks..
[quote user="Saurabh Shah"]
Hi,
It will get reverse on unapply entry. Please refer below link which is related discussion on other forum and might helpful to you.
dynamicsuser.net/.../400334.aspx
-Saurabh Shah
[/quote]
| Posting Date | Entry Type | Document Type | Document No. | Customer No. | Currency Code | Amount | Amount (LCY) | Initial Entry Due Date | Entry No. | |
| 15-12-14 | Initial Entry | Invoice | RF120070 | RC-10015 | USD | 10,000.00 | 500,000.00 | 15-12-14 | 105 | |
| 01-01-15 | Application | Payment | 13 | RC-10015 | USD | -10,000.00 | -500,000.00 | 15-12-14 | 108 | |
| 01-01-15 | Application | Payment | 13 | RC-10015 | USD | 10,000.00 | 500,000.00 | 15-12-14 | 110 | Reversal |
When you unapply, the transaction gets reversed. The third line indicates that
How did you unapply the payment?
Customer > Ledger Entries... path or someother way..
Works fine with me.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
