
Hi,
I am doing consolidation in Management reporter and facing issue in currency translation for opening balances translation.
I have parent co. in INR and 2 A and B subsidiaries in EUR currency. Consolidation will be in INR therefore need to convert EUR TB in to INR. As per Indian consolidation rules I need to translate
S.capital - Historical rates
Reserves - Closing rate
Investments - Historical rates
Fixed assets - Historical rates
Other Balance sheets items - Closing rate
P&L item - Average rate
Now I am facing issue in using historical rates for opening balance taken from legacy system - AX is live from 31st march 2015. I have uploaded the opening balance TB as on 31st march in AX 2012 from legacy system.
My chart of account is shared across all the companies. I have defined for share capital main account
- exchange rate type = default and
- method = transaction date.
Now Historical rate for s. capital of company A is 60 $ as it was done in April 2012, Company B historical rate for s. capital is 62$ as it was done in June 2012.
On 31st march 2015 when I uploaded the TB my rate is 61.50.
In management reporter translation for share capital happens at 61.50 where as it needs to be for company A at 60 and company B at 62.
*This post is locked for comments
I have the same question (0)Couldn't get solution for this in management reporter. Now going back traditional way of consolidation through AX where foreign currency involvement is there. In AX hard consolidation I can choose exchange rate company wise and account wise...