Recording Realized Profit/Loss from Exchange rate fluctuations in Ax 2012

Before moving ahead let’s understand first what is Realized Profit/Loss.

The gain or loss is based on exchange rate fluctuations between the foreign (transaction) currency and the domestic (accounting) currency at the time the payment was received or issued.

Take an example where;

  • Company’s accounting currency is USD
  • Purchase order is created and invoiced in INR currency with the amount of Rs. 100
  • Exchange rate @ the time of PO invoicing; l USD = 10 INR

Make sure Realize gain and Realize loss account is selected @ General ledger -> Setup -> Ledger

Add new entry for exchange conversion to 1 USD = 12 INR in Exchange rate type form.

Navigate to Payment journal to make payment of above mentioned invoice.

Here we see that because of exchange rate conversion is changed from 1o to 12, system changes the cross rate to 1/12 = .08333 @ payment journal lines.


Journal Currency












Now to make payment of Rs. 100, company has to pay only USD 8.333 (8.3333*12 = 100 Approx.) instead of USD 10, so there will be realized profit of USD 1.67.

Profit Entry










The same logic goes with Realized loss if exchange rate would have been less than INR 10 = 1 USD.


Happy Learning!

Leave a comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.