Management Reporter do not match the General Ledger Trial Balance.

(0) Share

Report

Posted on by Community Member

Hello To all

I'm facing an issue Are summarized any design Financial Reports from Management Reporter do not match the General Ledger Trial Balance.

Does anyone know how the issue can be fixed?

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

Have you tried refreshing the Management Reporter data by selecting "Tools-Refresh cashed financial data?

Has somebody recently updated something on your AX System and restartet all Servers including the MR Service processes? Please double check if the MR application and process Services are running.

Can you identify what data are missing? Maybe it is just an issue that somebody posted a Transaction that has not been transferred to MR when you run the MR report?!

If nothing helps, you might have to rebuild the MR Datamart.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

already try Refreshing Management Reporter data but Without any effect.

That issue is big problem because of the lack of trust in the any financial statement.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

I can imagine that there might be a current lack of trust in any financial statement.

If restarting the MR services does not help you might have to rebuild the complete MR Datamart.

Very often this is the only option to get the data that you get in MR correct again.

Probably talk to one of your System admins first and check whether restarting the MR Services helps.

Otherwise completele rebuild the MR Datamart.

All the best,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hello Ludwig

we're experiment with all of that, but The result was as, we need any positive solutions.

Was this reply helpful? Yes No
Suggested answer

Pranav Kumar on at

Like (0)

Report

Hi Mohamed,

FRom the screen shots, I think its couple of account where balance is not matching. Can you please check if those account are related to subledgers like postings are coming from discount or some other type of transaction?

We had same issue with some ledger account, one of them was cash discount account. Due to a bug, the tables were not updating correctly and we had to take MS help to fix bug and data.

Also, what is the ledger balance showing up? In our case Ledger balance matched up with MR but trial balance was showing incorrect balance, so might be trial balance is broken.

For the two ledger transactions, can you check the transaction through voucher transactions form (in GL Inquiry) and see if something is fishy with the dimension update in the transactions? I suspect some of the transactions didn't hit some tables properly leading to mismatch.

Pranav

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

Is that right that you still see the difference even after rebuilding the Datamart? What version of Management Reporter do you run? If nothing else helps try to upgrade to the latest Management Reporter version (currently CU15). This should fix the problem.

All the best,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Mr. Ludwig,

I am installed CU15 and also rebuilding the datamart. but in trail balance not update the correct balance, total number of accounts is 78 but only 4 account not shown the correct balance.

further in management reporter have 5 company only 3 company shown a correct data and 2 company not shown the correct data, there are difference in 4 ledger account other are shown the correct balance.

Was this reply helpful? Yes No
Mohammed Rayyan 1 on at

Like (0)

Report

Dear Professionals,

I have the same issue " Miss match between AX TB and MR TB"

I found it is a bug!

we restarted the services, re build the balances with no luck.

I checked voucher by voucher level and I found there is missing voucher which is similar for another voucher, both vouchers has the same :voucher number, Journal number, Document Number, Transaction Date but with different amount; and this case is standard correct business case in AX and could be happened any time.

I would be appreciated if anybody come across this case and advice.

Thanks

Was this reply helpful? Yes No
Sreekanthxlnc 122 on at

Like (0)

Report

Dear Rayyan,

Any further feedback on how you fixed this? Is this relating to MR version/hotfix? PLease further throw light, as I have also landed in this scenario.

Regards,

Sree

Was this reply helpful? Yes No
Mohammed Rayyan 1 on at

Like (0)

Report

Dear Sreekanth,

I am still having the same problem and still trying to find a solution

thnaks

Was this reply helpful? Yes No