Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

MR is not showing the correct balance as AX trail balance

Posted on by Microsoft Employee

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR is not showing the correct balance as AX trail balance

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

    Thanks,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: MR is not showing the correct balance as AX trail balance

    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

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: MR is not showing the correct balance as AX trail balance

    Hello Ray

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans