Reporting Solutions

Management Reporter (MR) Error #3660431 After Starting the DataMart Integration

Posted by David Gigear, Senior Consultant on November 1, 2016

Error 3660431 – “Sequence contains no elements” I’ve seen this error happen a couple times now with both MR2012 CU13 and most recently, with CU15.  The error occurs after starting the DataMart Integration.  So, always make sure to go check the log after you start…

Read More

Build a SQL Report from SharePoint Data

Posted by Mike Giuffre on October 10, 2016

Did you know that if you use Microsoft SharePoint, it’s possible to create reports from your SharePoint data?  For example, I use SharePoint to keep track of everything related to different projects I’m working on.  Maybe I need to pull specific pieces of project…

Read More

The Hierarchy of Microsoft Dynamics GP Reporting

Posted by Mike Giuffre on September 13, 2016

Using Microsoft Dynamics GP as your ERP system provides for a wealth of data that you can analyze to help make good business choices.  In order to report on this data, Dynamics GP comes with several tools; however, there are many other available tools out there, too many to…

Read More

ERP & CRM - How Much Integration Do I Really Need?

Posted by Jen Bieker on September 13, 2016

By:  Tim Thompson, Crestwood Co-founder & Partner One question that comes up often when talking about using CRM systems centers around integrating that CRM solution with your back office ERP system.  We’ve found that sometimes the word “integration” is used very broadly, and may…

Read More

Just a Click Away – Excel Dashboards in Microsoft Dynamics GP

Posted by Jason Barton, Project Manager on July 7, 2016

If you have Dynamics GP 2013 R2 or a newer version and you haven’t seen the built-in Excel dashboard reports, you need to read this!  These dashboards show you key information at a glance and have drill-down capabilities embedded in them.  There are dashboards available in the…

Read More

Users and Administrators Can No Longer Log into Management Reporter:

Posted by Tiffany Bennett, Senior Consultant on July 6, 2016

How to Fix Management Reporter (MR) After an Administrator User’s Password Changes in Windows Problem: MR users cannot access the Report Designer from their workstations and the administrator can no longer log into the Configuration Console.  This is due to an issue where the Administrator user…

Read More

Management Reporter 2012 Not Connecting to Microsoft Dynamics GP & SQL Server 2016

Posted by Brandon Richards, Implementation Manager on July 1, 2016

Problem: While working on a recent customer project, we ran into an error trying to get MR 2012 CU15 working with Dynamics GP 2016 and SQL Server 2016.  "Couldn’t retrieve the list of available databases.  The connection attempt failed." This occurred after MR services were installed and working, and…

Read More

MR Configuration Console Error

Posted by Tiffany Bennett, Senior Consultant on June 21, 2016

You receive an “Object reference not set to an instance of an object” error in the Management Reporter Configuration Console for a Dynamics SL Data Mart: Here are the steps to correct the error: 1.  Run the MRDiagnostic Scripts found here in the file 2.  Correct…

Read More

Assigning Security Roles in Management Reporter (MR)

Posted by Jen Bieker on May 31, 2016

Are you just setting up Management Reporter for the first time, or adding new users? You will want to learn the basics around security roles.  There are three basic areas for security in MR: Company access: accessed using your Dynamics GP credentials Management Reporter access: controls which functions you…

Read More

Customizing Microsoft Dynamics GP Reports

Posted by Jen Bieker on May 24, 2016

It’s great that Dynamics GP comes with so many built-in reports, report options, and even report building tools.  But have you ever run into a situation where you hit a wall?  You just can’t seem to get what you want on the report? …

Read More