Changing reporting currency in AX 2012 R2

Finance and Operations/AX User Forum
1

Hi,

Is there any way to change the reporting currency assigned in the Ledger? I cannot edit it since it is grayed out. See below screenshot.

Regards,

Kristine

2

Since the transactions are posted, you cannot change main currency or reporting currency.

On General ledger, Click Periodic → Currency conversion → Ledger reporting currency conversion. This feature allow you to change the reporting currency but you need to change it thoroughly specially from reporting perspective. I believe system will convert the currency and adjust the value as per exchange rate for the historical transactions and new transaction will have take new reporting currency for transactions.

Pranav…

3

Hi Pranav,

Thank you so much for the reply. Do I still need to revert forex revaluation on customer and vendor then close previous fiscal years for changing the reporting currency?

Regards,

Kristine

4

Hi Kristine,

I don’t think that will be required, system asks for conversion rate for the new currency, i think system will convert the transactions at ledger level. Please test this in any test environment before doing this in PROD.

Pranav…

5

Hi Pranav,

Okay, thanks for the answer! Will test it.

Regards,

Kristine

6

hi,
In CustAccountStatement Report i want to show Reporting currency as INR …but if i have transaction in INR its working fine but when i have transaction in USD its showing result in USD only…it means report is showing value in transaction currency but i want it in INR…can you please help for this scenario

Thanks,
Manali

7

In customer account statement it will show in transaction currency only. With small customization you show in your specific currency (if the transaction currency & reporting currency have a relation)

8

Thanks for reply…
Can you please suggest me how to go through customisation like transaction in USD and INR so how to show result in INR in report

9

First you need to analyze

  1. How report data is coming. After finding customize the classes and write your logic for currency conversion
    If USD & INR are related.
  2. If INR is the setup as accounting currency or reporting currency , then the transaction currency(USD /EUR…etc) & INR are related with a exchange rate factor for all the transactions.
    Note: It would take time & need to do yourself or hire a developer.