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.