web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter - Reports Amount Incorrect

(0) ShareShare
ReportReport
Posted on by 50

We encountered issue in Management Reporter whereby reports show triple of the actual amount when the user who is assigned to organizational structure generates the reports.

Has anyone encountered this issue before? Or any suggestion solution for this?

Categories:
I have the same question (0)
  • Greg Byer Profile Picture
    2,586 on at

    Do the report use a tree?  If it does, remove the tree and generate the report.  Do you get the correct amount then?  If you do, something in the tree is causing the amount to triple.  You'll want to check that you don't have the same dimension, or a range of dimensions, listed more than once.  Check the summary levels and see if they are using dimensions.  If they are, is that dimension listed in the children below it?

    Also check that the same dimension is not listed in the tree and the row.

  • lly Profile Picture
    50 on at

    We have try to create a report that just select one account code in row definition and without reporting tree but the amount still show triple.

  • Greg Byer Profile Picture
    2,586 on at

    If you created a simple report with just the one account in the row definition, and no reporting tree, and the amount is still triple, the next step would be to rebuild the data mart.  

    If you set the detail level to Financial, Account, & Transaction and then drill down to the transaction level on this test, report, do you see the same transaction listed 3 times?  If you do, then a rebuild would be the next step.  

  • lly Profile Picture
    50 on at

    Yes, see the same transaction listed 3 times.

    We using legacy.

    We have try to delete company and import again but the amount still show triple.

  • lly Profile Picture
    50 on at

    When we remove organizational structure assignment from the user ID or grant user access to all accounts, user able to generate the reports with correct amount.

    Has anyone encountered this issue before? Or any suggestion solution for this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 586 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 311

#3
Diego Mancassola Profile Picture

Diego Mancassola 271

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans