Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Nav 2017 - Trying to r...
Small and medium business | Business Central, N...
Suggested answer

Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

(0) ShareShare
ReportReport
Posted on by KCHAN301 5

Hi,

I made a batch payment in a foreign currency that I now want to reverse out of my vendor account and bank. I am get an error message about realized gain and loss when I select "reverse entry". I read everywhere this happens when a batch payment is made in foreign currency, and I would need to readjust the coding from the back end to bypass the message, or manual reversing entries by creating general JEs would be the only solution? The back end codings I found are for Nav 2013, so if anyone has a better or updated code format for Nav 2017/2018 please let me know. 

Any other suggestions would be greatly appreciated!

Thank you, 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

    Hello,

    Based on your reply to NorthW can you show us the images of the reverse transaction you are trying to post. I want to see the Posting Date, Document Date, and amounts. Also, can you send an image of the Currency Exchange Rate that will be used.

    Thanks,

    Steve

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

    Could be missing an entry or could be that the Currency amount and the LCY amounts are not correct.

    Can you share the lines in your journal?

  • MarisolC Profile Picture
    MarisolC 338 on at
    RE: Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

    Did you find a way to solve this? Just run into this same issue today and I don't know what to do?

  • KCHAN301 Profile Picture
    KCHAN301 5 on at
    RE: Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

    Thanks NorthW for your relpy. I tried to reverse the entries manually according to the listed "reverse entries" that I saw in my vendor action page. Unfortunately I cannot post them because I get an error message that says "I'm out of balance" by the exact converted foreign exchanged amount, even though there is no balance on the actually GJ page i.e. All 3 entries balance each other out. Am I missing an entry? Perhaps a entry in USD, the foreign currency I am trying to reverse? Thank you,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Nav 2017 - Trying to reverse vendor payment with realized gain and loss error message

    The recommended way to fix this is to reverse the transactions through manual journal entries.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans