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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ledger data mismatchin...
Microsoft Dynamics AX (Archived)

Ledger data mismatching in financials reports

(0) ShareShare
ReportReport
Posted on by AHSAN MINHAS 50

We are facing one unusual issue and so far running after to solve it. While running Management Reporter (MR) we found inconsistency of data. We focused to resolved MR issue but lately we experiences very unusual thing in AX reports. With some accounts, Trial balance was not matching with Ledger statement Report.

Example:

My Trial showing value 7,579,644.60 whereas ledger report total is 7,559,644.6. While looking at Ledger statement report, I experienced the balance is coming in 2 section. Section one showing total of 20,000 which is actually the difference between trial balance total and ledger report total but this upper section headers are not showing account number or even account description

Reporting-Problem.png

I have checked the sub-ledger and other areas and they are showing balances all perfect. This 20,000 is the real difference between Trial balance and MR report and even Trial balance and Ledger statement Report. It seems something happens during entry post and some effects are missing.

I would welcome technical guidance.

Consistency check could not find any issue

Regards

Ahsan

AX 2012 R3 - CU6

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ahsan,

    There are a couple of reasons why you can get inconsistencies between MR and AX.

    A common issue is when developers implement some new features, restart the servers but forget to restart the MR services.

    Another common issue is when financial dimensions or main accounts are renamed.

    To check the consistency of the MR, you can follow the following instructions

    blogs.msdn.microsoft.com/.../sql-scripts-to-check-the-mr-integration

    Yet, very often the only Thing that helps is rebuilding the datamart

    The steps required for this are described here

    blogs.msdn.microsoft.com/.../resetting-the-management-reporter-data-mart-for-dynamics-365-for-operations

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    Hi Ludwig,

    Very nice to see your reply.

    I can understand financial dimensions set renaming but this had happend before and after that I rebuild the balances.

    For MR, we installed a new instance after all hits and trial but result is same. Do you still recommend to rebuild data mart even if it is new installation?

    Please advise

    Thanks

    Ahsan

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ahsan,

    You can try refreshing the MR cached data and to restart the MR services to see whether this resolves the issue.

    In Addition, you can check the data mart tables whether the specific record/voucher is included.

    If it is not there, your only chance is rebuilding the data mart in my opinion.

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    Ludwig,

    Services started many times even I disabled integration and run it again. For individual record/voucher, I will check it but my question remains same. How the difference between Trial balance and Ledger statement report will be solved as the ledger statement report appearing in 2 sections as mentioned above where section one showing the amount part of this difference and having no account or description appearing. How the financial dimension sets issue will be resolved because I believe if the data is consistent in AX then we would be able to resolve MR issue also.

    Thanks in advance

    Ahsan

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ahsan,

    Can you check and share the vouchers that are responsible for the $20000 difference?

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    No. I have assigned it to my technical team to check and will update accordingly

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    I rebuilt the datamart but many entries are not coming

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ahsan,

    In this case I would recommend that you contact the MS support.

    They have a specialised team for the MR and are the ones that can help you quickly with this integration.

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    Thanks Ludwig,

    Appreciate your support. We will open ticket with Microsoft now

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at

    We have gone through almost every possible way but one thing I could not understand. I generate one report in MR which gives me correct data and the same report I run it, it gives me different data. After couple of running, it gives data the one which was accurate.

    I also found time between full integration and integration is not parallel. Difference is more than five 10 minutes sometime full integration not working until restart the server. Is that could be the possibility of inconsistent data?

    Few months report are accurate and have no issue no matter how many time I generate.

    Please advise

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans