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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

MR is not showing the correct balance as AX trail balance

(0) ShareShare
ReportReport
Posted on by

We are getting wrong values for some ledger accounts in Management report related in Trial Balance.

In AX the trial balance is showing correct values but in management reporter it showing wrong values for some ledger accounts. We have observed that the report is working fine for previous months but it is showing wrong values for current month in Management reporter.

We have MR CU 14

Deleted and Created the MR DataMart and rebuild  and still the same issue.

What is wrong here.

*This post is locked for comments

I have the same question (0)
  • Abdo Khoury Profile Picture
    14,855 on at

    Hello Ray

    can you kindly have a closer look at the event viewer and advise to find out what is happening?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Ray,

    In Addition, can you verify that the reason for your difference is not caused by a time lag? Meaning that people continuously enter records in AX while you retrieve the data that are e.g. some minutes older? Probably try running the report at the end of the business day to see whether the difference that you observe for the current month really exists.

    Hope this helps,

    Ludwig

  • Verified answer
    Community Member Profile Picture
    on at

    It was an issue with our custom demission once we ignore it and rebuild the DataMart it works now.

    Thanks,

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans