Mary Lenehan

Don’t Miss GPUG Amplify – March 20-21, 2018 | Chicago, IL

I’m excited and honored to be presenting “Explore Your GP Reporting Options” session at the upcoming GPUG Amplify conference in Chicago on March 20, 2018. I invite you to join hundreds of other leaders and learn more about Reporting, Functional, and Executive Leadership with Dynamics GP at its focus. Amplify is the annual conference sponsored … Read more

Read More…

Brandon Richards

Crashing and Connection Errors with Management Reporter Console, Dynamics GP, and SQL

Error and fix when your Management Reporter console crashes. This one is great!  My client was having issues with the Management Reporter (MR) Configuration Console crashing as soon as you tried to open it, and the MR Process Service kept stopping after you would start it. I was also getting errors in the Windows Application … Read more

Read More…

Brandon Richards

Management Reporter (MR) and Dynamics GP Legacy Connection – Caution When Importing a New Company

CAUTION – If you’re using MR with the Legacy connection to Microsoft Dynamics GP, when importing a NEW company to MR, be careful.  You want to make sure you check the boxes for “Skip Import” for all the existing companies that are setup if you are using multiple Building Block Groups (also known as Specification … Read more

Read More…

Jen Jerzak

Microsoft Power BI Training Resources

Microsoft Power BI – it’s been the buzz for a while now, but maybe you haven’t found the time to dig through all that information and try it out yet. We get it; there is so much out there that it can be overwhelming. Download our free Power BI Training Resources,  packed full of links … Read more

Read More…

Gary Korby

Variance Presentation in Management Reporter

In your Management Reporter (MR) reports, have you experienced an issue where the favorable or unfavorable variance amounts between actuals and budgets in an income statement aren’t presented correctly?  A favorable sales variance may be incorrectly presented as a negative amount and the expense may be presented correctly or vice versa. A way to overcome … Read more

Read More…

Tiffany Bennett

Dimension Not Found Error in Management Reporter MR

If you use Management Reporter (MR) with multiple companies, you might get an error while generating reports if your companies have different: Subaccount segment descriptions in Dynamics SL Account Formats Segment Names in Dynamics GP Unlike FRx, MR uses the account segment names in the Row and Tree Definition Financial Dimension mapping fields.  Let’s take … Read more

Read More…

Tiffany Bennett

Understanding Security Hierarchies in Management Reporter MR

Management Reporter (MR) has many different levels of security, to restrict users to specific companies and reports.  Understanding how they work will make it easier for setting up users and distributing reports. User Security – To get started, set up users and assign them company access under the Security menu item in the bottom left corner … Read more

Read More…

Tiffany Bennett

Divide by 0 Error in FRx

Have you ever gotten the “Divide by 0 Error” when you go to run a report in FRx Report Designer?  And to top if off, then the report does not print.  Other users can print FRx reports just fine, but for you, it happens on all reports.  This error appears if you print to the … Read more

Read More…

Georgia Stewart

Save Time Exporting Dynamics GP SmartLists to Excel: How-to Create an Export Solution

Many of our clients like to export their Microsoft Dynamics GP SmartLists to Excel.  Why?  In Excel, you can easily add things like: Summary Totals Pivot Tables Charts And more However, it can become a tedious and time-consuming process if you export many SmartLists. How to Automate your exports Wouldn’t it be nice if you … Read more

Read More…

Tiffany Bennett

How to Get a New Dynamics GP Budget ID to Show Up in Management Reporter MR

It’s very common for our customers to add new budgets to Microsoft Dynamics GP.  With the Legacy Provider in Management Reporter (MR), the new Budget ID would show in the Column Definition “Book Code/Attribute Category” field automatically.  With the MR Data Mart, there are a couple of steps below that need to be followed first. … Read more

Read More…

Georgia Stewart

Oh My, How You Have Grown! Excessive File Size Growth in Management Reporter (MR) Database

Has your MR database gotten so big it’s out of hand? I recently encountered issues relating to the excessively large size of Management Reporter (MR). So, I wanted to remind everyone of the importance of maintenance of your MR system, and associated data sets. Here are my recommendations for MR maintenance: Have a current backup … Read more

Read More…

Tiffany Bennett

Multiple Companies Report Not Pulling Data in MR

Imagine the following scenario in Management Reporter (MR).  A report runs fine when running it individually, for separate companies, with no tree.  However, when adding a tree that crosses multiple companies from different Dynamics SL application databases, the report gives no data.  How can this be? The cause of this is due to different CURYIDs … Read more

Read More…