Attention Dynamics SL Users: You’ll notice a lot of “Dynamics GP” language used below – that’s only because we used Dynamics GP for our presentation. Management Reporter works exactly the same in Dynamics SL! Maybe you have heard that Microsoft will no longer be releasing updates to Management Reporter. This does not mean, however, … Read more
Recently, we have received a handful of calls on how to add a new user to Management Reporter (MR). So, I thought this would be a good time to revisit the process. First, you must be an MR administrator to add users. Also, the user you are adding must have access to the company in … Read more
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
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
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
Problem: I ran into a unique issue today. A client had reset their SA password, and after doing so, they could no longer login to Dynamics GP or SQL with the SA password. The SQL SA account kept getting locked out. We determined this was being caused by the Management Reporter (MR) services. When trying to … Read more
Have you recently performed a company import in your Dynamics system? Did your MR report definitions disappear? Don’t worry, here’s the fix. Follow these steps to bring back your report definitions. Log in to Report Designer and click on Company in the menu ribbon and select companies. In this window, highlight a company and click … Read more
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
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
Setting Your Default Company in Management Reporter (MR) The first time you login into Management Reporter Designer as a new user, or the first time you login after an upgrade, you may notice that you are missing all of your report options on the left hand side. You might find yourself looking at the Security … Read more
Have you ever noticed that when you download Management Reporter (MR) reports into Excel, the headers don’t show up at all in the Normal View, or the headers only show up in the Page Layout View? If the Page Layout View in Excel is not to your liking, this can present a problem. Example 1 … Read more
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
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
The Crestwood Support Team receives a lot questions about creating Statements of Cash Flow in Management Reporter (MR). I’d like to provide to you answers to some of the most commonly asked questions about Cash Flows, and show you some tips along the way. Default Cash Flow Report I recommend starting with the Default Report … Read more
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
Using logos on your Management Reporter (MR) reports can make your reports look more formal and professional. Luckily, it’s super easy to do! Save a copy of your company’s logo anywhere on your local computer or network. It must be in the format of a “jpg,” “bmp,” or “png” file. Then open the report in … Read more
Many Dynamics SL users have been confused by Microsoft’s messaging around Management Reporter (MR). Here’s a question I’ve heard a few times lately: “I’m planning my Dynamics SL 2015 upgrade from Dynamics SL 2011, is it worth migrating to MR if it’s going away?” Here’s the low-down: MR is being sunset – meaning no new service packs (or cumulative updates … Read more
In Management Reporter (MR), when printing a report with a Long Date header, the date shows the day of the week in both the Report Viewer and the Web Viewer as shown here: However, most clients I work with do not want the day of the week in the header. Here are the steps needed … Read more
Error I was installing Management Reporter 2012 CU15 and got the following error: “Management Reporter Setup has ended prematurely” or it might state .NET 4.6 is not installed. Resolution: The fix is to run the Windows Server updates to update the server. This will then allow you to install Management Reporter successfully. The update that … Read more