local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
close
Message Boards
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Noah.Moseley

Moderator
Registered:
Posts: 117
Reply with quote  #1 

With Microsoft's introduction of the Management Reporter Datamart database, many improvements have been made to Management Reporter performance when generating reports. There are instances, however, when the MR Datamart database does not correctly copy and summarize all of the account balances and transaction details from the Dynamics General Ledger database. In those instances, reports will generate with erroneous results with missing account balances or missing transaction details. There have even been duplication of balances and details. The easiest and best way to correct this issue is to delete and recreate the Management Reporter Datamart database. Here are general guidelines for completing this process but always refer to the latest Microsoft documentation for official information. Before completing any of the following steps, make SQL backups of the Management Reporter database and of the Management Reporter Datamart database.

1.) In Management Reporter Configuration Cosole, open the ERP Integration window (see left-hand menu).

2.) Select the integration in question. Usually there is only one defined. Click the “Disable Integration” button.

3.) At the top right, click “Remove ERP Integration".

4.) Stop the two Management Reporter Services.

5.) Using SQL Server Management Studio, delete the Management Reporter Datamart database (Do NOT delete the Management Reporter database).

6.) Start the two Management Reporter Services.

7.) In Management Reporter Configuration Console, reconfigure (File>Configure) the Datamart Database.

8.) On the ERP Integration window, click the "Enable Integration” button.

9.) Once the integration is complete, generate the reports in Management Reporter Report Designer to verify that the incorrect balances have been corrected.



If I can be of additional assistance with training or support for Management Reporter, contact me at Noah.Moseley@MSXGroup.com

__________________
Noah C. Moseley
MSX Group Senior Consultant and Certified Instructor
Noah.Moseley@MSXGroup.com
http://www.MSXGroup.com

Email me if you need help installing, implementing or just need training on Microsoft Forecaster, Management Reporter or FRx. Plus, Prospero for Financial Reporting and Budgeting is now available. See our introductory video at http://msxgroup.com/prospero_video_introduction

Management Reporter | Prospero | Forecaster | FRx
Training | Consulting Services | Software Support
Noah.Moseley

Moderator
Registered:
Posts: 117
Reply with quote  #2 

Microsoft is dedicating substantial efforts in correcting any problems with the Management Reporter Datamart Integration with Microsoft Dynamics AX, GP and SL. With the release of CU9, Management Reporter now has an option to check for possible data problems even before enabling an integration. This new option is located in the ERP Integration window of the Management Reporter Configuration Console. Details on this new addition have been posted online by Microsoft at http://blogs.msdn.com/b/dynamics_financial_reporting/archive/2014/05/16/erp-data-validation-with-data-mart-cu9-feature.aspx 


__________________
Noah C. Moseley
MSX Group Senior Consultant and Certified Instructor
Noah.Moseley@MSXGroup.com
http://www.MSXGroup.com

Email me if you need help installing, implementing or just need training on Microsoft Forecaster, Management Reporter or FRx. Plus, Prospero for Financial Reporting and Budgeting is now available. See our introductory video at http://msxgroup.com/prospero_video_introduction

Management Reporter | Prospero | Forecaster | FRx
Training | Consulting Services | Software Support
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.