Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Payment Journal Entry Reversal with Foreign Currency

(0) ShareShare
ReportReport
Posted on by 427

Hi All,

I would like to reverse a Payment journal entry which is a foreign currency payment. I don't remember the exact steps.

I remember, we need to create a Cash Receipt journal to do the adjustment. 

Kindly request you all to provide some steps on achieving it.

Local Currency - SGD, Bank Account - SGD, Payment - USD.

*This post is locked for comments

  • Sarav Profile Picture
    Sarav 427 on at
    RE: Payment Journal Entry Reversal with Foreign Currency

    Thanks Hannes Holst,

    That's a great help which make me learn and understand the reversal of realization accounts and for foreign currency journals.

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Payment Journal Entry Reversal with Foreign Currency

    [quote user="Saravanan"]

    I would like to mention the steps here, so that you can correct me if anything need to be included:

    1. Unapply the Payment from the Invoice.

    [/quote]

    OK

    [quote user="Saravanan"]

    2. Go to Cash Receipt, create a refund entry and select the vendor  and then the balancing account as Bank Account. Also, make sure the posting date and the currency exchange rate is correct compared to the old payment journal.

    [/quote]

    OK. Cash Receipt, Payment Journal or General Journal

    [quote user="Saravanan"]

    3. Apply the incorrect Payment entry over the correction entry and post it.

    Here, I have a problem as well.  There is no Realization Gain/Loss shown while doing the Preview Posting.

    [/quote]

    That's correct. The revert of the FX Gain/Loss was posted as you unapplied the Payment from the Invoice. You should see it when you run Navigate on the Ledger Entry of the Invoice.

    The Posting Date of the Invoice is used to calculate the difference between the FX-rates.
    (FX Rate of Invoice Date - FX Rate of Payment Date = Gain or Loss)

  • Sarav Profile Picture
    Sarav 427 on at
    RE: Payment Journal Entry Reversal with Foreign Currency

    Hi Hannes Holst,

    Thanks for the reply.

    I unapplied and as it is involving foreign currency, couldn't reverse it.

    I would like to mention the steps here, so that you can correct me if anything need to be included:

    1. Unapply the Payment from the Invoice.

    2. Go to Cash Receipt, create a refund entry and select the vendor  and then the balancing account as Bank Account. Also, make sure the posting date and the currency exchange rate is correct compared to the old payment journal.

    3. Apply the incorrect Payment entry over the correction entry and post it.

    Here, I have a problem as well.  There is no Realization Gain/Loss shown while doing the Preview Posting.

    Can you guide whether i'm missing anything.

    Thanks in advance.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Payment Journal Entry Reversal with Foreign Currency

    hi,

    Unapply the payment from the invoice first.

    Then try to reverse the payment ("Reverse Transaction" in Ledger Entries).

    If this is not possible you must enter a corrective payment journal (Refund) against the Bank Account. Make sure the Posting Date is the same (for Currency Exchange Rate).

    When the balance is back on the bank account, you can create a new payment journal and apply it to the invoice.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans