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.
Hi Ludwig,
I have rebuild the data mart and now data is matching with reports.
Thanks A lot!
Looking forward for the same support :)
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,317
André Arnaud de Cal... 918 Super User 2025 Season 2
Sohaib Cheema 656 User Group Leader