Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

How to cancel an exchange adjustment

There can be situations where you need to cancel an exchange adjustment. This could be because the wrong exch.rate was applied or because you in hindsight find out it would lead to reconciliation issues if you did not do the reevaluation from the ‘right’ module.

Here I will show an example of how to cancel an exchange adjustment when you by accident did in General Ledger, but actually needed to do it from Accounts Receivable

These are my exchange rates

Exch1

I post a freetext invoice on Feb 1st in USD

Exch2

My Summary account balance in my company currency is 19444.44

 

Exch3

I decide now that I want to do an exchange adjustment for my summary account 130100 to update the balance with the rate of March 1st

 

Exch4

After the exchange adjustment, my trial balance looks like this

Exch5

My summary account balance after the reevaluation is 19662.92

However, now I find out that I should actually have made an exchange adjustment from Accounts Receivable(AR) instead.

The problem now is how can I cancel this exchange adjustment so that I can do it from AR instead

The easiest way to do that is to change the exchange rate on March 1st to be equivalent to the one from Feb 1st

Exch6

90 for March 1st

Exch7

We can then rerun the exchange adjustment and note that my Trial balance shows that the balance on my summary account is back to 19444.44.

Exch8

The previous exchange adjustment has been cancelled out and I can update my exchange back to 89 and do the exchange adjustment from Accounts Receivable