Is this possible to create a consolidated MR report for Analytical accounting with multi-currency?

(0) Share

Report

Posted on by Manikandan

2,845

I tried to create a consolidated(Summation of all company AA dimension value) report for AA in MR. If I generate report for single company it is working fine. But, when I try to created report for multiple company which has different currency ID, I am getting error in the event viewer "Invalid column name TranslationDebitAmount". This is first time I am creating MR report with AA. I need to know is this possible or not? If anybody done similar report kindly share your experience.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Manikandan 2,845 on at

Like (0)

Report

RE: Is this possible to create a consolidated MR report for Analytical accounting with multi-currency?

Hi Maria,

Thanks for the reply. For example, I have company A with currency ID in $ and B with currency ID in Euro. If I print report what is the currency ID of summary value?

Thanks,

Mani

Was this reply helpful? Yes No
Suggested answer

Maria Carrero 150 on at

Like (0)

Report

RE: Is this possible to create a consolidated MR report for Analytical accounting with multi-currency?

Create the report showing one column by each company, and create a tree with the dimensions, In the last column sum all the companies, that is, all the columns

Was this reply helpful? Yes No