Hi All,
One of the main account Trial balance values are not matching with Profit and Loss report in Management reporter,
Tried restarting both the Management reporter services, still the values are not matching.
Management Reporter version : 2.12.13002.1 - CU13
Please advise us how we can resolve this issue.
Regards,
Akbar
We have reset the Data Mart and resolved the issue.
Thank you Trenton for your suggestion for upgrading MR version, we are planning to upgarde CU in AX and in MR.
Regards,
Akbar
Thank you very much Ludwig, after resetting Data Mart we are able to see correct values.
Thank you once again.
Regards,
Akbar
Hi Akbar,
Ensure that you have your building blocks exported, then try to follow the instructions from the post you shared.
In case you want to have another source, check out this post as well.
www.everythingdynamicsaxbi.com/.../
The content seems almost identical.
Best regards,
Ludwig
Thank very much Ludwig,
Just one thing, we are going to follow below link for Data Mart resetting, and one of the step is deleteing the MR Database, will it impact anything in report design or can I proceed following this link:
Or do you have any link to follow for reset data mart, please let me know.
Thanking in anticipation.
Regards,
Akbar
Hi Akbar,
I would recommend exporting all of your reports, row and column structures on a regular basis irrespective of whether you do a reset of the data mart or not.
To be absolutely sure that nothing goes wrong, you can simply export your building blocks and then reset the data mart.
The reset should not do any harm to your reports but just in case that something unexpected happens, you can easily and quickly import your existing building blocks again from the exported file.
Best regards,
Ludwig
Hi Ludwig,
Yes, account is there in MR and Trial balance.
If we reset the Data Mart. do we need to design th P/L report again in MR or it will come automatically after resetting the Data Mart.
Please let me know as I am new in MR.
Regards,
Akbar
Hi Akbar,
Have you checked that there are no accounts missing in your report?
If you have done that and the MR data and the GL data still don't match, then reset the data mart. The reset should fix any data related issues.
Best regards,
Ludwig
Hi Ludwig,
We just tried with the mentioned steps,Still the values are not matching for the perticular account.
Regards,
Akbar
Hello Akbar,
Please try making use of the following functionalities:
1. Check the missing account analysis to identify whether you forgot to include some revenue and cost accounts into your report.
2. Select 'refresh cached financial data' to ensure that even the most recent postings made in AX are included in the report.
Best regards,
Ludwig
Hi Ludwig,
We observed that, it is the transactions with the Commodity Financial Dimension '****' that isn't showing up in management reporter for 41050 *****.
I can't see any filters in management reporter that is preventing 41050-***** from being included
Please advise us how we can resolve this issue.
Regards,
Akbar
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
