Articles

financial planning analysis blog

The rapid growth of Microsoft’s Dynamics 365 Business Central (D365 BC) cloud ERP system comes with investments in add-on app solutions by independent software vendors (ISVs). For example, Progressus is a company as described above and has a project solution for D365 BC. With Progressus, small and mid-sized companies receive easy-to-configure and advanced project accounting functionality in the cloud. 

However, as all project-centric business managers know, good transactional systems also need proper financial planning and analysis tools. In today’s highly competitive market, this can be the difference between success and failure.  As successful project-based companies invest in new cloud-based ERP systems like D365 BC and add advanced project apps like Progressus, a natural next step after the implementation is to look for an integrated and flexible reporting and planning solution. A reporting and planning software like Solver can operate down to the detailed field and dimension level in the Progressus tables inside the ERP system.  

Project Reports for D365 and the Progressus App

Lately, most companies prefer pre-integrated solutions. Due to this, Solver partnered with Progressus and now the corporate performance management solution delivers an out-of-the box integration to both Dynamics 365 Business Central and Progressus. Solver not only provides D365 BC customers with a strong financial reporting and budgeting software for general ledger and sub-ledger data, but it also now extends this functionality into all the project detail provided by Progressus. 

Customer Benefits:

  • Pre-built integration to Dynamics 365 and Progressus tables
  • Pre-built Progressus Project reports
  • Full report writer with Excel design
  • Optional Budgeting module
  • Multi-tenant Azure Cloud Platform
  • Pre-built Power BI integration for interactive Dashboards

However, as with any reporting solution, pre-built report templates speed up deployment when can be used as a starting point. 

Solver offers a number of project-focused reports for Progressus including:  

  • Benchmarking
  • Project Manager Benchmarking
  • Project Capacity by
    • Customer Group and Resource
    • Department and Resource
    • Customer Group and Resource
  • Project Detail by Customer
  • Project List
  • Resource Detail
  • Actual vs Budget Variance

 

project capacity

project 2

Both solutions are independently integrated to Microsoft Dynamics 365 Business Central. After the partnership between the two companies, they decided to configure a joint integration. With the rapid growth in popularity of cloud ERP software like D365 BC, one of the next big cloud drivers is that ISVs, such as Progressus and Solver, work together to give customers elegant integrations across both standard ERP data as well as transactions originating from ISV add-ins to the ERP systems. This eliminates many of the custom integrations that are configured in the old on-premise platforms.

Technology is driving major industry changes into the next decade. Project managers and executives will need and demand complete insight to their data to drive faster and better decisions. Cloud-based ERP vendors and ISVs are making good strides to make this happen!

This article explores the popular Dynamics 365 Business Central cloud ERP system and how you can achieve advanced reporting and budgeting.
After Microsoft’s highly anticipated release of Dynamics 365 Business Central (D365 BC) a few years ago companies evaluating the solution has, as expected, quickly zoomed in on reporting, budgeting and business intelligence (BI) capabilities.

But, let’s zoom out for a moment
after 25 years in the software industry, I have yet to see an ERP system with fantastic reporting, budgeting and BI capabilities built into the ERP. Alas, the world’s most used tool in this area remains the ever popular Microsoft Excel spreadsheet! There is actually a good reason for ERPs failing in this area with their native functionality, and that is that the demands for advanced calculations and formatting, currency conversion, consolidations, budget workflow, custom budget input forms, and charts simply are too much for the otherwise controlled and accounting-focused ERP applications. That is also a main reason why there is a flourishing corporate performance management (CPM) and BI industry out there that plugs these and other planning and decision-making related holes in ERP systems. It has become a symbiotic relationship in many ways with a sometimes elegant dance, especially when there are solid integrations that exist between ERPs, CPM solutions, and BI tools.

So, where does Dynamics 365 Business Central (D365 BC) land in terms of advanced reporting and budgeting? Well, as expected, it has native reporting and budgeting at the typical level where most modern ERPs have it. So
if ERP history is any indication, that means that 90-95% of all D365 BC customers will at least partially be using their beloved Excel spreadsheets for some of their reporting and a lot of their budgeting and forecasting. That is, unless they are ready to step up the CPM game and look at CPM tools like Solver for full blown cloud budgeting, reporting and consolidations that are pre-integrated and also running on Microsoft Azure as a multi-tenant solution.

But wait a minute, that was CPM, but what about BI? Actually, here Microsoft seems to have achieved a home-run in the past few years with Power BI. Not only did Power BI recently become the leader in the Gartner BI Quadrant, but Microsoft has done an excellent job integrating it to D365 BC and many other transaction systems.

So, if you work for an organization that plans to evaluate Dynamics 365 Business Central, between Power BI from Microsoft and advanced CPM solutions like Solver, you should be in good shape to turbo-charge your organization’s decision-making abilities in the years ahead.

Good luck and enjoy your ERP, BI, and CPM journey!

Solver enables world-class decisions with the Solver cloud based CPM suite made up of budgeting, reporting, dashboards, and data warehousing, delivered through a web portal. Solver is reinventing CPM with its next generation user-friendly solution. Solver empowers business users with modern features including innovative use of cloud-connected Excel in the report and budget form design process. If you’re interested in learning more, our team is excited to hear about your organizational needs and goals.