Retreat, Retrench, or Replace: What To Do With Management Reporter

January 6 2016

In my last piece, I expressed my view that it was time to rethink Management Reporter (MR). Even if Microsoft decides to go that route, it is going to take a while to build a replacement. How should users deal with Management Reporter woes now?

Essentially, there are three strategies for Microsoft Dynamics ERP users to consider today: retreat, retrench, or replace. But be warned: none of them are perfect.

About Mark Polino

Mark Polino is a Certified Public Accountant (CPA) and a former Microsoft MVP (2007-2018) for Business Solutions. He is the author or coauthor of 5 books related to Microsoft Dynamics GP.  Mark also maintains the Dynamics GP focused website DynamicAccounting.net. He speaks and writes regularly about ERP related topics. Mark has been a controller and CFO for a division of a publicly traded company and he has  worked as a consultant implementing ERP solutions. Mark holds additional certifications including Certified Information Technology Professional (CITP), Certified in Financial Forensics (CFF) , Chartered Global Management Accountant (CGMA). Dynamics Credentialed Professional for Dynamics GP 2015 (Core Install and Core Financials), Xero Certified. He holds a bachelor's degree in accounting from the University of Central Florida and an MBA from Rollins College. Mark lives with his family in Florida.

More about Mark Polino

Comments

LesWrightCMA's picture

Another problem with 'Retreat' is that existing clients have been unable to purchase new FRx licenses for some time (i.e more than a few years); and I believe that new clients are not shipped FRx keys. Also, along with the cost of 'Replacing' comes more choice, as there are many alternatives and organizations need to review their needs and requirements carefully. My two cents. Les

heatherr's picture

I think the key to this is also the comment with replace that the options are broader. Most of our sites choosing BI360 do so because the reporting is nicer, it is Excel based, it reports on sub-ledgers and you can link in all the pretty graphics etc that you want. You can then step your way up to full data warehouse reporting from multiple systems if and when you choose. The budgeting feature is definitely also popular. I think the biggest problem with MR (aside from all the functionality ones), is that is simply does what FRx did (albeit, nowhere near as well) and that is straight GL reporting. Most businesses - even small ones - want more than that.

MikeLupro's picture

The cost of BI360, and the investment you need to place in (transient) employees, makes this option one of the most expensive available. It looks cool but I've had two clients who have seriously underutilized this offering. One client spent $5000 to $8000 training a guy who left two weeks later. Then they spent another $5,000+ to train another employee who left after about six months. Unless a principal in the company takes ownership of knowing how to make BI360 do its tricks its an option I suggest avoiding. Mike Lupro - MCP

svallarian's picture

We're managing about 50 MR installs right now, and MR "magically" doubling total lines on an income statement and balance sheet is about to drive me bonkers. Of course, completely rebuilding the datamart fixes it, but I need a way to be able to figure out when it's happening BEFORE the customer sees it.

MikeLupro's picture

Along with others, I agree that the DataMart is a terrible product. If you backup a database and restore it to a TEST company then the DataMart needs to be rebuilt. At least Microsoft should develop one of their FixIT apps that a regular person could run to drop the MR DB and repair/replace it with more ease than it currently takes. Mike Lupro - MCP

RScully's picture

We've most recently (within the last year) migrated over from Accpac to AX. Financial reporting wise we migrated from what was once known as Lex2000 and then Cognos Finance. It was not a well known program in the Cognos suite of applications and product support ended in 2010. Throughout the years though Cognos Finance continued to chug along with very few issues and the reporting was simple, fast, and effective. Even at the time it came out in the 90's, they had an Excel interface capability that would return values in seconds. Really an amazing technology at the time. Anyway, as we were replacing our ERP we would be moving our financial reporting to another platform and Management Reporter we were told was the answer. From the time we saw it until the time we decided it would not be the answer, we were extremely unimpressed with the lack of functionality. Not that we had ultra-complex reports but we did include a key KPI of our industry as one of the columns in the report but the thing that made this a challenge was the fact the denominator in this KPI changed depending on what could essentially be termed our product line. Products were intermingled throughout the report meaning the denominator on row 99 might be different than on row 100 and then again different on row 101. This was far from the only issue for us but one of the biggest challenges from a support perspective nonetheless. We instead decided to use the SSAS cubes that come with AX. While the contents in the cube were quite expansive (over 100+ dimensions) we were able to hone in on what we were looking for. We had to make some changes dimensional additions to the cube to accommodate our financial reporting needs but we are now using that in conjunction with Excel. Far from the desired solution but a temporary solution nonetheless until we could come up with a better one. We're still in search of a better solution at this time but am in the process of pursuing a potential solution using MDS (Master Data Services) with one or more of the Power BI products from Microsoft (Power BI, Power Query, Power Pivot). In my honest opinion, MR rates about a 4 out of 10 - tops.

globesoftware's picture

Atlas is being used by literally thousands of AX implementations worldwide with financial reporting extremely common. Atlas can report from every module of AX, including custom tables and has totally eliminated the need to key in figures into a spreadsheet, word document or powerpoint slide. This ensures you have accurate up to date results, directly from the source system, (Microsoft Dynamics AX) rather than a copy or external MR database. Make decisions on figures you can trust. Every figure presented by Atlas offers drill down to the source to see what is driving the numbers. If your data is within any of the following data sources, • Microsoft Dynamics AX 2009, 2012 and AX7 • Microsoft Dynamics CRM 2011+ • OLAP cubes • Internal databases Atlas can integrate the data into any custom report. There's no limit to report building, as Atlas uses the familiar Office environment. For a free trial, navigate to www.globesoftware.com

RScully's picture

Thanks - I'll check it out.

Scott W's picture

What are the other options out there for GP?

dkensmoe's picture

Anyone have a link to the magic fix for FRx. I have run into this issue before and am wondering what DLL you replace to keep FRx running on newer operating systems. It seems that as soon as you run the install for GP 2015 on a workstation then it breaks FRx. thanks