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

Community site session details

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

Management reporter data not matching from AX in trial balance reports

(0) ShareShare
ReportReport
Posted on by 192

The data in reports is not matching with the data in AX Trial balance under GL Module.

I am specifying Base period 1 and year 2020..means I am fetching data for April 2019(since fiscal year is from April to March) but its not matching with real data in AX. What could be the reason behind it?  Please help.

I have the same question (0)
  • JasdeepSingh Profile Picture
    192 on at
    RE: Management reporter data not matching from AX in trial balance reports

    Hi Ludwig,

    I have rebuild the data mart and now data is matching with reports.

    Thanks A lot!

    Looking forward for the same support :)

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Management reporter data not matching from AX in trial balance reports

    Good morning Jasdeep,

    There can be a couple of reasons if the MR data and the AX data don't match. Please check the following:

    - Have you applied filters somewhere?

    - Can you quickly create a simple MR report and compare if this new report gives you the right outcome?

    - Is it possible that the MR data mart has not been updated and has old and inconsistent data inside? If this is the case then you have to reset the MR datamart to get this fixed.

    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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,317

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 656 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans