web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reversal of automatic ...
Microsoft Dynamics AX (Archived)

Reversal of automatic Exchange Gain/Loss transaction

(0) ShareShare
ReportReport
Posted on by Community Member

I settled an invoice with a customer payment with incorrect exchange rates. This resulted in incorrect exchange gain/loss transactions. Now i want to reverse the payment and create a new payment with correct exchange rate but i am unable to manually create the reversal entry, because this entry have 0 in the transaction currency but have value only in reporting currency. How to create reversal of this entry. I want to reverse the red colored transactions. 

Journal number Voucher Date Ledger account Currency Amount in transaction currency Amount Amount in reporting currency Posting type
IPA-059703 IPA-80000411 9/15/2017 57041002 PKR 0.00 0.00 -20,242.68 Exchange rate gain
IPA-059703 IPA-80000411 9/15/2017 57041002 PKR 0.00 0.00 -31,661.85 Exchange rate gain
IPA-059703 IPA-80000411 9/15/2017 57041002 PKR 0.00 -20,242.68 0.00 Exchange rate gain
IPA-059703 IPA-80000411 9/15/2017 57041002 PKR 0.00 -31,661.85 0.00 Exchange rate gain
IPA-059703 IPA-80000411 9/15/2017 15010001 PKR 606,900.03 57,717.75 57,717.75 Customer settlement
IPA-059703 IPA-80000411 9/15/2017 15010001 PKR 0.00 0.00 51,904.53 Customer balance
IPA-059703 IPA-80000411 9/15/2017 15010001 PKR 0.00 51,904.53 0.00 Customer balance
IPA-059703 IPA-80000411 9/15/2017 15010001 PKR -606,900.03 -57,717.75 -57,717.75 Customer settlement

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Mudassar Hassan,

    You can't do the reversal directly. Yet, there is a workaround or trick available that might help.

    - Create an ordinary journal where you debit and credit the accounts used.

    - Use a accounting currency amount of let's say plus $10000 and post it together with one of the accounts used in your voucher ...411

    - Convert this amount into your foreign currency in a way that a foreign curreny amount of 20424.68 is resulting.

    - Do the same for the line with the foreign currency amount of 31668.85

    - Use an offset account with an amount of minus $10000 so that in total nothing is posted in your accounting currency and apply the same conversions for the Offset account for example by making use of a split posting.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    The solution seems to be workable, can you help me in creating such an entry. Thanks

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Here is an example where a wrong exchange rate between the EUR and AUD of 0.65 is corrected and replaced with a new one of 0.70Please note that the amounts posted on my ledger accounts adds up to 0.00 EUR (in my case)

    1205.voucher.png

    You have to check the amount and exchange rate that is used for this correction and the ledger accounts that you have to use.

    Please test in a demo environment first.

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans