News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Is this possible to cr...

Microsoft Dynamics GP (Archived)

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

(0) Share

Report

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

All responses Img

All responses (2)

Answers Img

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
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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans