MR is not showing the correct balance as AX trail balance

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 14,849 on at

Like (0)

Report

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?