Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : D8BaX9OlJ4j3T/jH71yJnw
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management reporter &q...
Finance | Project Operations, Human Resources, ...
Answered

Management reporter "Main account category"

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2020 10:28:46 by MEKSI-Anis 50

Hi All,

I m preparing a financial statement and I m trying to use main account category in the row definition, link to financial dimensions. when I generate the report and compare it to my trial balance. I noticed that its getting the wrong accounts all the total is incorrect. Example my main account category is called sales and its related to account 701100 to 701199.

The report that I get using management reporter is taking other accounts like 7012 ...

Even thought I made sure to add the main account category only for the account that I want to use all the other accounts have other categories.

Can you please help me with this issue?

Regards

  • Chris Quick Profile Picture
    Chris Quick 18 on 06 Feb 2024 at 23:22:43
    Management reporter "Main account category"
    I'll just add to this post in case others find it helpful.  I had a similar situation where I found a report that was supposed to show balances for a Main Account Category was missing one particular Main Account.  I found this through cross checking my numbers.
    No matter what I did in D365 to the main account around changing the Account Category on the Main Account (changing to a different category, changing back) I couldn't get the report to pick it up.
     
    To prove to myself that the issue was on the Management Reporter (Financial Reporting) side
    I created a new Row Definition
    Then press Edit, Insert Rows from Dimensions
    Make Main Account Category ALL &&&
    Press OK and it will fill the row definition
    Then you will start to see the relationship between Main Accounts and Main Account Categories.
     
     

     
    In my case, I could see the Main Account in question had a blank main account category.
     
    I found the only way to resolve this was to reset the datamart.  Nothing I could do in D365 triggered the update on the MR side.
    The trick was useful to confirm my suspicion that MR not seeing the relationship
     
  • MEKSI-Anis Profile Picture
    MEKSI-Anis 50 on 12 Nov 2020 at 16:25:06
    RE: Management reporter "Main account category"

    thanks a lot Dr Ludwig it worked

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on 09 Nov 2020 at 12:25:13
    RE: Management reporter "Main account category"

    Hi Anis,

    If you switch the account setup and assign different or new categories then it might be necessary to reset the datamart if those changes are not reflected when you run the report.

    Have you already tried doing that?

    Best regards,

    Ludwig

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,401 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,550 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans