Recently, in two separate announcements, Microsoft has stated that they will no longer develop their Forecaster budgeting tool and their Management Reporter financial report writer. How does this impact the almost 200,000 Dynamics AX, GP, SL and NAV customers out there? Well its not just going to go away, but it looks like it will not get too many more upgrades or new features.
Jet Reports has partnered with Microsoft to launch Jet Express for Excel for Dynamics GP, designed to help users create Excel-based reports tied to their ERP data. Jet Express for Excel with Microsoft Dynamics GP will be available free as a download in June of 2016 directly from the Jet Reports website, according to Jon Oesch, VP of Sales, Jet Reports.
Dynamics NAV. Management Reporter has not supported NAV for a while and most customers look to best-of-breed third party solutions with a live NAV integration, such as Excel-based report writers
When it comes to Dynamics SL (supported with live reporting by BI360, BizNet, etc.), Management Reporter (MR) will also leave a void, but I don’t think SL customers will feel deprived if they have to leave the proprietary row and column report design screens of MR and instead, design their reports with modern Excel add-ins and all the formatting and calculation functionality of Excel at their disposal.
In the case of Dynamics AX, there were a lot of database changes with AX2012 and later versions, and Management Reporter’s (MR) older, pre-dominantly FRx-based technology never really caught up to run smoothly, even with the introduction of MR’s staging database outside of AX.
With MR only offering General Ledger reporting, AX customers, often larger companies with complex reporting requirements, were left with the need to combine MR with the native AX report writer, SQL Reporting Services (SSRS), AX OLAP cubes, etc., to get a complete reporting solution.
Make no doubt about it – other AX competitors like Oracle and SAP are in the same boat with a plethora of reporting tools needed.
If this is the end of further MR development, AX customers must look to third party solutions to put in place a more unified, best of breed solution for their BI and CPM needs e.g. Prophix, Atlas, BI4Dynamics. With Power BI from Microsoft, (and Datazen) there are plenty of dashboard and visualization options, predominantly in the cloud, as well.
While it is nice for current Dynamics customers to get free or almost free financial reporting and budgeting software from Microsoft, it will never spur the innovation and focus that third party, best-of-breed solutions can offer.
Microsoft will now presumably focus on their core ERP offerings and ERP cloud initiatives, like AX7 and the upcoming Madeira solutions, and leave behind the complaints and noise around MR and Forecaster, while leaning on their community of partners and Independent Software Vendors to give their Dynamics customers a financial reporting and budgeting solution.
Business Intelligence and Corporate Performance Management are always red hot topics for organizations. These Microsoft announcements mean that Microsoft Dynamics customers need to explore third party, best-of-breed solutions to solve their reporting needs. We see it as difficult to claim to be an enterprise solution without such support, especially for financial consolidation but competitors generally seem t rely on specialist add on tools. MR may have its drawbacks but it was a winner with
However a BI/CPM roadmap to expand from just reporting to include integrated budgeting and forecasting, as well as financial consolidation , with dashboards and data warehousing to combine Dynamics data with other data sources, for rich planning and analysis, and ultimately, superior decision-making capabilities is still a big question with many partial answers.
We think Prophix CPM with Power BI is one of the better options to consider especially for the multi-company , multi-geography groups of companies that are addressed by Dynamics Ax