ERP Data validation with data mart (CU9 Feature)

For Management Reporter CU9, we've introduced a new feature to proactively warn you if there is data in Microsoft Dynamics that will cause problems in Management Reporter. If you are using a data mart integration with Dynamics GP or Dynamics SL, the Configuration Console will now automatically review the data in your ERP for inconsistent or invalid data. The initial validation will start immediately after configuration, so you should resolve any issues found prior to enabling your integration.

Most of the customers we've talked to about invalid data found they had a few issues caused in prior versions of Dynamics, and there was a one-time cleanup effort to be done. The ERP teams have worked with us to identify issues the support team is seeing most often, so this should not be considered a comprehensive list of all known issues. Click below for detailed information on what issues are being checked for.

In addition to the initial validation, validation will continue to run on a nightly basis to check for any new issues.  If any invalid data is found, there will be an error in the Configuration Console integration log with a short description and link that will provide the suggested next steps. This feature works especially well with notifications, so you will receive an email automatically if an issue is found.

Watch this video to learn more about this feature.

Comments (3)
  1. Fahey9 says:

    Hi Ryan, I'm sure you don't recall but I met you at Convergence earlier this year, and appreciate the guidance you gave me in MR. I am trying to troubleshoot issues in my MR CU9 test environment with GP 2010. The budget data populates but the actual data does not populate. Also, the report definition states that SGD will be used as the Currency even though the company does not even have access to that currency and is set to Z-US$. I've tried practically everything I know to do without any success. Any ideas?



  2. Hi Adam,

    Typically we don't answer break/fix issues on our blog as we can't provide good suggestions without a lot of information. I'd suggest asking the question over in the community where several MVPs and others will offer up some suggestions.


  3. Fahey9 says:


    I actually figured out everything on my own by interpreting the Data Mart Integration log, which also provided me with the article to use. However, the article only includes the "select" script. For some reason it does not include a download link for the "update" scripts, which is not all that helpful.  All I need to make this work is the following SQL script: AA_DistCorrect_2010.sql, yet I cannot find it anywhere. Since we are a non-profit church organization, we do not have the resources or funds available to start a support ticket. Any help would be much obliged!



Comments are closed.

Skip to main content