Cloud-based ERP systems and Corporate Performance Management (CPM) solutions are two directly related business applications experiencing rapid growth in the 2020s. In part because companies and organizations seek to automate the Office of Finance and help their managers make faster and better decisions.
Replacing legacy ERPs and old, home-grown Excel reporting and budgeting models, however, takes both time and money. Especially for smaller and mid-sized businesses, this investment can delay their migration to the Dynamics 365 Finance (D365 Finance) cloud ERP for several years.
To aid a customer’s move to the cloud, companies like Microsoft and their key ERP implementation partners have developed various cloud migration tools and processes to ease the pain. At the same time, Independent Software Vendors (ISVs), or ERP add-ons as they are often called, have been busy at work over the past few years creating cloud-based bolt-on or add-in solutions that help automate specific areas that compliment D365 Finance and maximize the return on investment (ROI) for its customers. Solver is an example of such an ISV with a best-of-breed corporate performance management (CPM) solution that comes pre-integrated to Dynamics 365 Finance.
The rest of this blog will focus on how new cloud technologies enable Dynamics 365 customers to automate their planning, reporting and analyses using modern CPM functionality at a lower cost and with much quicker time to value than what has been available in previous years.
Why Use Best-of-Breed CPM to Compliment the Native Planning and Reporting Tools in Dynamics 365 Finance?
Like most ERPs, D365 Finance includes basic reporting, budgeting and dashboard functionality. Much like other leading ERPs, such as Sage Intacct, Netsuite and Acumatica, packing these three core feature sets into an ERP application and its corresponding database tables means that a lot of compromises have been made. Some of these shortcomings include lack of modeling, minimal workflow for approvals, inflexible input form design, weak formula capabilities, and lack of tables for detailed sub-ledger budgeting. In short, that is why the best-of-breed CPM software segment exists and the reason it is growing at a healthy clip.
From a user perspective, many of the smaller Dynamics 365 customers don’t have or don’t want to spend funds on additional business software applications that provide the advanced report formatting, consolidations, budgeting and forecasting they need for business oversight. As a result, Excel is typically used as a “do it yourself†band aid and it remains the world’s most popular reporting and planning tool. What normally happens is that customers will export data to Excel to build much-needed custom models specific to their businesses.
However, innovations in affordable, rapid deployment and out-of-the box templates from leading CPM cloud vendors have put top notch CPM functionality well within reach for most organizations to use. In fact, here is a showcase that displays more than 500 examples of budgeting, forecasting, reporting and dashboard layouts. This gives you an idea of the breadth and depth of features professional CPM tools like Solver offer to deliver world-class planning and analysis processes that drive better, faster business decisions. You can also find ideas for data visualization from the powerful dashboard functionality available when you connect Microsoft’s Power BI tool to a best-of-breed CPM solution that combines your Dynamics 365 Finance data with planning data and other important information sources. Learn more by checking out these interactive dashboards.
When it comes to supporting a user’s graphical analysis needs, many Dynamics 365 Finance customers also rely on Excel. Why? Because they already own it and know how to use the product. Not to mention that the spreadsheet interface is easy and flexible for building and maintaining the underlying calculations and charts. There is, however, a rapidly growing demand for cloud-based, best-of-breed CPM tools that integrate deeply with both Dynamics 365 and Power BI for a dynamic and secure user experience that delivers rich, interactive charting and drill-down for real-time, self-service reporting and analysis process.
How to Pick the Right CPM Solution for Dynamics 365 Finance
Traditionally, the top CPM solutions–found on user feedback websites like G2 and in analyst reports from firms like Dresner Advisory Services–can handle most organizations’ reporting and planning needs. However, when it comes to integration capabilities, data modeling and template design, there can be a big difference in time to value, amount of effort required to implement and cost.
While popular CPM tools may look similar in capabilities, some go much further than others in simplifying the ERP integration and in delivering rapid return on investment (ROI) with template-driven implementations. These other components include:
- Pre-built and pre-mapped integration to Dynamics 365 Finance that works out-of-the box with a few clicks and without the need to manually set up endpoints in the D365 API nor manually map dimension and transaction fields to the CPM solution.
- Financial reporting templates like profit & loss reports and balance sheets that can be downloaded from the vendor’s marketplace and that immediately work without having to edit accounts and other formulas.
- Budgeting and forecasting templates with pre-defined versions and top-down and bottom-up input options.
- Dashboards templates with trends, variances and other analyses. As with the reporting and planning templates, these should work out-of-the-box without the need to manipulate Power BI’s DAX formulas (i.e., underlying formula language).
We will not go into details in this blog but, if you want some ideas, this document highlights key areas to look at, while this interactive tool provides a simple way to compare and score vendors, and includes an ROI calculator to analyze the cost and benefit of alternative tools versus your current solution.
In short, progressive executive and finance teams of the 2020s want flexible financial reporting, budgeting and forecasting functionality closely integrated with Dynamics 365 Finance that provides quick time to value.
What Is Considered a Quick Start with a CPM Solution?
Most Microsoft Dynamics customers want their connected apps, including CPM tools and dashboards, to be Azure cloud based. Key questions that quickly come up include: How hard is it to integrate to the ERP? How much cost and effort does it take to get up and running?
The typical answer: Weeks or months of effort and tens of thousands of dollars in services. However, Microsoft Dynamics ISV software partners, like Solver, that work very closely with the Dynamics 365 Finance ERP solution and Microsoft’s partner channel, have developed pre-built integrations as well as out-of-the-box financial reports, planning input templates and Power BI dashboards. For example, Solver’s QuickStart integration to Dynamics 365 Finance can have a company up and running in a single day with more than 50 pre-built Power BI financial dashboards, in addition to financial reports and budget input templates. All these ready-to-use forms and templates can be selected and downloaded at no additional cost from a continuously growing Template Marketplace.
A note about tools that offer integrations to Dynamics 365 Finance:
While a number of CPM vendors can claim to offer integration to an ERP like Dynamics 365 Finance, there can be big differences in the skill and effort involved to make such integrations ready with your financial data loaded into the reporting and planning tool.
Generally, there are three categories of integrations, each with its own effort level for implementation:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for D365 Finance, but do not include an app that configures dimensions and views in Dynamics nor pre-maps to popular fields to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for D365 Finance that include an app or script(s) that properly and automatically configure dimensions and views in Dynamics and expose them to its API. You can see an example of this type of integration here.
What Is a Template Marketplace and Why Is It Important to Your Business?
While you receive a set of basic, embedded Power BI dashboards with Dynamics 365 Finance and it is likely you can survive with its native reporting tool and homegrown Excel budget models, the leading cloud CPM tools of the 2020s offer many advantages to drive faster and better decisions.
As an illustration, many vendors are catching on to the popularity of app marketplaces after years of watching companies like Apple and Microsoft deliver easy-to-access solutions in this fashion. CPM companies like Anaplan and Solver are now offering Template and Data Connector Marketplaces specifically built for planning and reporting needs. The main benefit for the customer: it typically only involves a few clicks to install and to incorporate your own data, compared with weeks or months of setup in legacy applications that don’t offer out-of-the-box templates.
In Solver’s Marketplace (see screenshot below), for example, users can download more than 50 pre-built financial dashboards that plug right into your Power BI web service, in addition to Profit & Loss Reports, Balance Sheets and other financial statements and planning input templates.
How to Quickly Get Started with Corporate Performance Management for Microsoft Dynamics 365 Finance
With true marketplace templates you should be able to provide your managers with professional dashboards, financial reports and budget templates the same day you install the CPM tool, and with no upfront data modeling or formula design!
Summary
The 2020s is already shaping up to be a decade with a lot of exciting automations and insights companies can gain by implementing modern ERPs like Dynamics 365 Finance with CPM solutions like Solver that have embraced deep Dynamics 365 and Power BI integrations. Benefits include “quick start†implementation wizards, and ready-to-use, downloadable templates from a marketplace. Picking the right solution, with planning and financial reporting considerations, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
Dynamics 365 Finance (D365 Finance) and Power BI are both rapidly growing cloud software applications from Microsoft. Although these technologies can be used independently, customers are increasingly using them together as an integrated platform.
As executives drive their accounting teams to migrate to a modern cloud ERP system like D365 Finance, senior leaders are at the same time expecting to gain the ability to perform world-class analyses with their new ERP. For that reason, evaluation teams not only have to review core ERP functionality to make sure current and future needs are met, but they also must determine the tools to use for dashboards, reporting, and planning.
Power BI has become the world’s most popular business intelligence (BI) solution and it is the natural data visualization dashboard choice for financial data from Dynamics 365. It is typically deployed as a stand-alone web service from Microsoft with companies often including other kinds of non-financial data as well. As with any flexible dashboard software, however, developing Power BI models can be complex, time-consuming, and costly, especially when building numerous dashboards and tailoring them to your D365 Finance business dimensions and data. What’s more, if the Power BI models are not wisely built it can be a daunting task to maintain them when your chart of accounts grows or when you make other changes or additions in Dynamics 365.
Most people that have implemented dashboard models for financial data know that it can take hundreds of hours of integration and design time before managers can enjoy their “shiny†dashboard gadgets.
This blog will focus on rapid deployment of Power BI dashboards for Dynamics 365 Finance, as well as several factors you may want to think about to ensure your executives’ expectations are met or exceeded when it comes to providing them with:
- Revenue Dashboards
- Expense Dashboards
- Variance Dashboards
- Exception Dashboards
- Trend Dashboards
- Balance Sheet Dashboards
- KPI Dashboards
- Benchmarking Dashboards
Why Use Stand-alone Power BI Dashboards to Compliment the Native Tools in Dynamics 365?
D365 Finance provides a limited version of Power BI that has been embedded with the ERP user interface. This format offers “native†dashboards and comes with a few simple, pre-built financial templates, but much like almost any other cloud ERP system’s native or embedded dashboard options, it lacks the complete flexibility that a management team usually requires when producing highly professional, automated graphical dashboards that can combine their ERP data with other important data sources.
Here is a link to a showcase that features more than a hundred dashboard examples. It provides a general idea of the capabilities in both breadth and depth that many professional reporting and analysis tools offer. It can also help you improve and democratize analyses for better, faster decisions in your business. Additional ideas can be found by trying these interactive Power BI dashboards.
Solver QuickStart – Power BI Dashboard Templates for Dynamics 365 Finance
Many Dynamics 365 customers support their graphical analysis needs through Excel because the software is already owned, users already know how to use it, and the interface is easy and flexible to build while maintaining the underlying formulas. However, there is a rapidly growing demand for cloud-based, best-of-breed dashboard tools like Power BI that offer a dynamic and secure user experience with rich, interactive charting and drill-down and that provides real-time, self-service reporting and analysis processes.
How to Pick the Right Dashboard Solution for Dynamics 365 Finance
Much can be written about the best and most affordable way to deploy Power BI. Most organizations find that delivering a rich and sustainable dashboard experience to their business and Office of Finance users does require more than just a Power BI license. These other components include:
- Pre-built financial dashboard templates that work out-of-the box, and that can be changed or copied to support special custom needs.
- Financial reporting and planning that complement Power BI graphical dashboards. Here is more information about things to look for in professional reporting and planning
- A data warehouse or staging database to organize key Dynamics 365 data and dimensions, with the added capability to include non-ERP data in order to deliver a comprehensive, clean data model to Power BI. Read more about pre-built financial data warehouses here.
We will not go into details about dashboard software evaluation in this blog but, if you want some ideas, this other blog highlights key areas many people want in a dashboard, while this interactive tool provides a simple way to compare and score vendors. It also includes an ROI calculator to analyze the cost and benefit of alternative tools versus your current solution.
In short, progressive executive and finance teams of the 2020s want dashboard solutions that are flexible; that are closely integrated with financial reporting, budgeting and forecasting functionality; and that provide quick time to value through template-based deployment.
What Is Considered a Quick Start with a Power BI Dashboard Solution for Dynamics 365 Finance?
Most Dynamics 365 customers want their connected apps, including dashboards, to be cloud based. The questions that quickly come up include: How hard is it to go beyond the native visualization tools that already come with D365 Finance, and to integrate a best-of-breed tool like Power BI with their ERP? How much cost and effort does it take to get key financial dashboards up and running?
The typical answer: Weeks or months of effort and tens of thousands of dollars in services. Sometimes, the completed integration is static and the ability to maintain data models is complicated and hard. This often results in disappointing outcomes. However, Microsoft software partners like Solver, that work very closely with the Dynamics 365 Finance solution and its partner channel, have developed pre-built integrations, a data warehouse and out-of-the-box dashboards to solve these challenges. For example, Solver’s QuickStart integration to Dynamics 365 Finance helps a company get up and running in a single day, providing access to more than 50 pre-built Power BI financial dashboards, as well as, additional financial reports and budget input templates. All these turn-key options are available from a marketplace that continuously expands with new templates.
A note about tools that offer integrations to Dynamics 365 Finance:
While almost all dashboard vendors can claim to offer integrations to popular ERPs like D365 Finance, there can be big differences in the skill and effort involved to get such integrations ready and your financial data loaded into the visualization tool.
Generally, there are three categories of integrations, each with its own level of effort during implementation:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for D365 Finance, but do not include an app that configures dimensions and views in D365 Finance nor pre-maps to popular fields to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for D365 Finance that include an app or script(s) that properly and automatically configure dimensions and views in D365 and expose them to its API. This results in a “clean†data model that Power BI can easily consume. You can see an example of this type of integration here.
What Is a Cloud Dashboard Marketplace and Why Is It Important to Your Business?
While you are given a set of basic, embedded Power BI dashboards with Dynamics 365 Finance, most companies end up designing their own graphical reports using the stand-alone Power BI license. However, offering modern and flexible functionality that quickly delivers the dashboards your managers and executives need is often a pipe dream. There is at least one challenge that must be overcome: Somebody must design all those dashboards and learn the underlying formula language referred to as “DAXâ€. This can be painful, especially when you consider the time and cost involved. More so if your leaders are eager and want their dashboards sooner rather than later and without a big consulting bill attached.
These days there is a growing trend for cloud business solutions to offer pre-built financial dashboards that are downloadable and ready-to-use from each vendor’s marketplace. Typically, this involves a few clicks to install and refresh the report with your own data. The process is not that different from apps you download to your iPhone or Samsung phone. For example, in Solver’s Marketplace, users can download more than 50 pre-built financial dashboards that plug right into your Power BI web service in addition to Profit & Loss Reports, Balance Sheets and other financial statements and planning input templates.
In other words, with true marketplace templates, you should be able to provide your managers with professional dashboards and reports the same day you install the reporting tool–and with no upfront formula design or Power BI model building! Now that’s a quick deployment!
Summary
For new or existing Dynamics 365 Finance customers, the 2020s hold a lot of promise. Microsoft is continuously improving and updating their ERP system, while a rapidly growing Appsource marketplace of third-party apps further enhances the benefits of D365 Finance. Picking the right solutions, like data visualization tools for dashboards as an example, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
A rapidly increasing number of mid-market organizations are implementing Microsoft Dynamics 365 Finance (D365 Finance) as their new cloud ERP system. If you are considering a migration to D365 Finance, there are a few key things to do: make sure the solution fits your needs; and determine if your company should also consider any best-of-breed add-on solutions to automate certain processes key to your business.
When companies consider migrating their accounting solution from on-premise servers to the cloud, the decision usually relies on the solution’s ability to automate and streamline accounting and finance processes. To ensure this occurs, companies not only have to review core ERP functionality to make sure it meets their current and future needs but must also determine the tools to use for reporting, planning, and analyses. Some of these functions can be found natively in Dynamics 365 Finance while others, like dashboards for data visualization, are embedded or connected apps.
This blog will focus on best-of-breed budgeting and forecasting apps that are pre-integrated with D365 Finance. The information below includes some tips you may want to consider to ensure your ROI and Dynamics 365 experiences are optimized when it comes to producing:
- Annual budgets
- Monthly or quarterly forecasts
- What-if analysis and scenario modeling
- Strategic goals to drive your planning process
Why Use Planning Apps Instead of the Native Budgeting Features in Dynamics 365 Finance?
D365 Finance’s budgeting functionality enables basic budget input. However, as with almost any other cloud ERP system’s native planning tools, this inherent functionality is not the typical tool budgeting managers prefer to use to oversee a complete annual budget process or to produce a forecast. This showcase of planning input forms and report templates includes several hundred budgeting, forecasting and report examples. The sheer volume of options gives you an idea of the breadth and depth of capabilities found with professional corporate performance management (CPM) tools. Tools that can help you optimize planning processes and related decision-making in your business.
While many Microsoft Dynamics 365 customers supplement their budgeting and forecasting tasks with home-grown Excel models, it becomes obvious when manual Excel models no longer are the right tools for your planning processes. Typical signs of Excel pain include problems like:
- Errors with formulas and links
- No workflow
- Lack of elegant versioning (separating budget versions)
- Long duration (often 2+ months) of the budget process due to lack of automation
- Lack of user security (especially for salary budgets, etc.)
- Inability to perform web-based input so files need to be shared and collected
- Painfully slow and inflexible budget consolidation and reporting options
These types of common issues leave an opening for the market’s best-of-breed budgeting and forecasting solutions to offer a purpose-built and professional planning experience that also can automate and streamline your budgeting and forecasting processes.
How to Pick the Right Planning Solution for Dynamics 365 Finance
Much can be written about evaluation and selection of budgeting and forecasting solutions. We will not go into details in this blog, but if you would like some ideas, this document highlights key areas to consider. This interactive evaluation tool also provides a simple way to compare and score planning tools. It includes an ROI calculator to analyze the cost and benefit of alternative tools versus your current solution.
In short, progressive Financial, Planning and Analysis (FP&A) departments of the 2020s want planning solutions that are flexible; closely integrated with their ERP as well as financial reporting (for variance analysis, etc.) and dashboard functionality; and that provide quick time to value.
What Is Considered a Quick Start with a New Planning Solution and How Is It Deployed?
These days, most Microsoft Dynamics customers want their connected apps, including budgeting and forecasting tools, to be cloud based and often Azure is the preferred cloud platform. Questions that quickly come up include: how complex might be an integration of a best-of-breed planning solution with D365 Finance, and how much cost and effort will it take to get key budget input forms up and running in it? Input forms such as:
- Employee payroll (with taxes and benefits)
- Capital expenses (with calculation of depreciation)
- Sales budget (by salesperson and/or customer, product/service)
- Profit & Loss (revenues and operating expenses)
- Balance sheet with automated or semi-automated Cash Flow budgets
The typical answer: months of effort and tens of thousands of dollars in consulting services. However, some Dynamics 365 independent software vendors (ISVs), like Solver, that work very closely with Microsoft and its partner channel, have developed pre-built ERP integrations as well as out-of-the-box budget templates. For example, Solver’s QuickStart integration to Dynamics 365 Finance can have a company up and running in a single day, with pre-built and customizable input planning forms, reports and Microsoft Power BI dashboards. All these forms, reports and visualization tools are available in a continuously growing template Marketplace.
A note about tools that offer integrations to Dynamics 365 Finance:
While almost several CPM vendors can claim to offer integrations to an ERP like Dynamics 365, there can be big differences in the skills and effort involved in having these integrations complete and ready to go with your financial data loaded into the planning and reporting tool.
Generally, there are three categories of integrations, each with its own effort level required to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for Dynamics 365 Finance, but do not include an app that configures dimensions and views in Dynamics nor pre-maps to popular fields to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for Dynamics 365 Finance and that include an app or script(s) that properly and automatically configure dimensions and views in Dynamics. Then it exposes them to its API, including pre-mapped popular dimensions and data. You can see an example of this type of integration here.
What Is a Template Marketplace and Why Is It Important to Your Business?
By now, most best-of-breed planning solutions have followed D365 Finance and other popular ERPs to the cloud. They offer modern and flexible functionality to collect the budget and forecast data that your executives need. However, they still have at least one big deficiency: Somebody must design those input forms and adapt them to your Dynamics chart of accounts and other key dimensions. This can be very painful when you include the time and cost involved, especially if you still remember the effort it took to get all required templates and reports up and running in your old legacy on-premise ERP system.
These days, there is a growing trend for cloud business solutions to offer pre-built apps such as reports, input forms, connectors, and more in their own Marketplaces. Typically, app installations only involve a few clicks to install from a marketplace. This is not that different from apps you are used to downloading to your iPhone or Samsung phone. For example, in Solver’s Marketplace (see screenshot below), users can download planning input templates, financial reports and more than 50 pre-built financial dashboards that plug right into your Power BI web service.
Rapid deployment of Budgeting and Forecasting Tools for Microsoft Dynamics 365 Finance
In other words, with true marketplace templates you should be able to provide your managers with at least a set of General Ledger account-level budgeting and forecasting templates the same day you install the planning tool! Now that’s a quick deployment!
Summary
For new or existing Dynamics 365 Finance customers, the 2020s hold a lot of promise. Microsoft is continuously improving and updating their ERP system, and there is a rapidly growing ecosystem of third-party apps that further enhance the benefits of D365 Finance. Picking the right solutions, for planning as an example, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
Microsoft Dynamics 365 Finance (D365 Finance) was born from the widely known on-premise product known as Dynamics AX. In recent years D365 Finance has become a significant player in the cloud-based ERP market segment, quickly gaining popularity worldwide as Offices of Finance within organizations began to migrate to cloud applications. If you are considering a move to D365 Finance, the first thing to do is make sure the solution fits your needs.
As large numbers of companies plan to migrate their legacy accounting solutions from on-premise servers to the cloud, they not only have to review core ERP functionality to make sure it meets their current and future needs, but they have to also review the tools they will use for reporting, planning, and analyses. Some reporting, planning and analysis tools are native to Dynamics 365. While some others, like the Solver financial reporting and consolidations application, are approved and preferred Microsoft apps because they are considered a best-of-breed complimentary solution in a particular area.
This blog will focus on financial reporting for Dynamics 365 Finance and will look at some of the things you may want to think about to ensure you optimize your experience with Dynamics when it comes to producing:
- Profit & Loss Reports
- Balance Sheets
- Cash Flow Statements
- Operational Reports
Why Use Third-Party Reporting Apps Instead of the Native Tools in Dynamics 365 Finance?
D365 Finance’s native report writer for financial statements and other GL summary data was previously called Management Reporter. Now it is typically just referred to as “Financial Reportingâ€. It is an upgraded, web-based version of FRx, which was a popular legacy reporting tool that launched in the 1990s. However, much like almost any other cloud ERP system’s built-in reporting options, the native Financial Reporting tool is not usually the preferred application finance teams use to produce highly professional reports with custom formulas and advanced layout or when they want to consolidate financials across companies. This showcase of forms, templates and reports provides several hundred report examples that show the breadth and depth of capabilities a best-of-breed reporting tool can offer to improve reporting processes and analyses in your business.
While many Dynamics customers supplement their reporting tasks with manual Excel files, SQL Reporting Services (SSRS) and dashboard tools like Power BI, there is still a spot for best-of-breed financial reporting tools to offer a single, purpose-built and professional reporting experience that also helps to automate the month-end reporting process.
How to Pick the Right Reporting Solution for Dynamics 365 Finance
Much can be written about evaluation and selection of financial reporting tools. We will not go into details in this blog, but if you want some ideas, this blog highlights key areas to look at. This interactive tool will also provide a simple way to compare and score vendors. It includes an ROI calculator to analyze the cost and benefit of alternative tools versus your current solution.
In short, progressive finance and accounting teams of the 2020s want financial reporting solutions that are flexible, closely integrated with budgeting and forecasting functionality, and that provide quick time to value during implementation.
What Is Considered a Quick Start with a New Reporting Solution and How Is It Deployed?
Most Dynamics 365 Finance customers want their connected apps, including reporting tools, to be cloud based. Questions that quickly come up include: how hard is it to integrate a best-of-breed reporting solution with Dynamics, and how much cost and effort does it take to get key financials up and running, such as Trial Balances, Profit & Loss Reports, and Balance Sheets?
The typical answer: Weeks or months of effort and tens of thousands of dollars in services. However, some best-of-breed software companies like Solver, that work very closely with Microsoft and its Dynamics partner channel, have developed pre-built GL and sub-ledger integrations as well as out-of-the-box reports. For example, Solver’s QuickStart integration to D365 Finance can set a company up and running in a single day with ready-to-go, pre-built financial reports and Power BI dashboards, as well as, optional budget and forecast templates. All of these can be selected from a Marketplace that grows continuously with new templates.
A note about tools that offer integrations to Dynamics 365 Finance:
While several financial reporting vendors can claim to offer integrations to an ERP system like D365 Finance, there can be big differences in the skill and effort involved to get such integrations ready with your financial data loaded into the reporting tool.
Generally, there are three categories of integrations. Each integration requires its own effort level to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for Dynamics 365 Finance, but do not include an app that configures dimensions and views in Dynamics nor pre-maps to popular fields to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for Dynamics 365 Finance and that include an app or script(s) that properly and automatically configure dimensions and views in Dynamics. Then it exposes them to its API, including pre-mapped popular dimensions and data. You can see an example of this type of integration here.
What Is a Cloud Reporting Marketplace and Why Is It Important to Your Business?
Most best-of-breed financial reporting tools have by now followed Dynamics 365 Finance and other popular ERPs to the cloud. Many also offer modern and flexible functionality to deliver reports your managers and executives need, however they still have [at least] one problem: Somebody has to write those reports. This can feel very painful, especially when you factor in the time and cost involved. Just remember the effort it took to get all required reports up and running in your old legacy on-premises ERP system.
Nowadays there is a growing trend for cloud business solutions to offer pre-built apps (e.g., reports, connectors, etc.) in their own Marketplaces. Typically, this involves a few clicks to install, not that different from apps you download to your iPhone or Samsung phone. For example, in Solver’s Marketplace (see screenshot below), users can download Profit & Loss Reports and other financial statements, planning input templates, and more than 50 pre-built financial dashboards that plug right into your Power BI web service.
Rapid implementation of financial reports and CPM for Dynamics 365 Finance with pre-built templates from Solver Marketplace
In other words, with true Marketplace templates you should be able to provide your managers with professional reports and dashboards the same day you install the reporting tool! Now that’s a quick deployment!
Summary
For new or existing Microsoft Dynamics 365 customers, the 2020s hold a lot of promise as Dynamics 365 Finance continuously improves and expands their ERP system. Customers are also able to tap into its flourishing ecosystem of third-party apps that further enhance the benefits of a Dynamics ERP system. Picking the right solutions, including one for reporting, can significantly improve your processes, save you time, and drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
Microsoft Dynamics 365 Business Central (D365 BC) is one of the fastest-growing cloud-based ERP systems on the market, and it is quickly gaining in popularity worldwide. If you are considering a migration to D365 BC, the first thing you have to do is make sure the solution fits your needs.
As large numbers of companies are planning to migrate their accounting solution from their on-premises servers to the cloud, they not only have to review core ERP functionality to make sure it meets their current and future needs, but they also have to review which tools to use for reporting, planning, and analysis. Some of these solutions are native to D365 BC and some, like Power BI dashboards, are connected apps from the Microsoft cloud stack. Still other apps are third-party best-of-breed solutions in one particular area.
This blog will focus on financial reporting for Dynamic 365 Business Central and some of the things you may want to think about to help ensure that your experience with D365 BC is maximized when it comes to producing:
- Profit & Loss Reports
- Balance Sheets
- Cash Flow Statements
- Operational Reports
Why Use Third-Party Reporting Apps Instead of the Native Tools in Dynamics 365?
D365 BC’s Account Schedules tool enables basic reports but, similar to almost any other cloud ERP system’s native reporting options, it is not the preferred place for a finance team to produce highly professional, automated reports or to consolidate financials across companies. Here is a showcase with several hundred report examples to provide an idea of the breadth and depth in capabilities that many professional reporting tools offer to help you improve reporting processes and analysis in your business.
While many D365 BC customers supplement their reporting tasks with Excel and Power BI, this still leaves an open space for the best-of-breed reporting tools on the market to offer a purpose-built and professional reporting experience that also helps to automate the month-end reporting process.
How to Pick the Right Reporting Solution for Dynamics 365 Business Central
Much can be written about evaluation and selection of financial reporting tools. We will not go into details in this blog but, if you want some ideas, this blog highlights key areas to look at – and this interactive tool provides a simple way to compare and score vendors and includes an ROI calculator to analyze the cost/benefit of alternative tools versus your current solution.
In short, the progressive finance and accounting teams of the 2020s want reporting solutions that are flexible, closely integrated with budgeting and forecasting functionality, and that provide quick time to value.
What Is Considered a Quick Start with a New Reporting Solution and How Is It Deployed?
Most D365 BC customers want their connected apps, including reporting tools, to be cloud based. The questions that quickly come up are: how hard is it to integrate a best-of-breed reporting solution with D365 BC and how much cost and effort does it take to get key financials up and running, such as Trial Balances, Profit & Loss Reports, and Balance Sheets?
The answer typically is: Weeks or months of effort and tens of thousands of dollars in services. However, Microsoft software partners like Solver that work very closely with Dynamics 365 Business Central and its partner channel, have developed pre-built integrations as well as out-of-the-box reports. For example, Solver’s QuickStart integration to D365 BC gets a company up and running in a single day with ready-to-go, pre-built financial reports and Power BI dashboards as well as optional budgets and forecast templates. All of these are selected from a Marketplace that continuously grows with new templates.
A note about tools that offer integrations to D365 BC:
While almost all reporting vendors can claim to offer integration to an ERP like D365 BC, there can be big differences in the skill and effort involved to get such integrations ready and your financial data loaded into the reporting tool.
Generally, there are three categories of integrations, each with its own effort level to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure
- Works but often with limitations: Connectors specifically built for D365 BC, but not pre-mapped to popular fields with an app that configures dimensions and views in D365 BC to “light them up†for its API
- Quickest and easiest: Connectors specifically built for D365 BC that include an app or scripts that properly and automatically configures dimensions and views in D365 BC and exposes them to its API. You can see an example of this type of integration here
What Is a Cloud Reporting Marketplace and Why Is It Important to Your Business?
While most best-of-breed financial reporting tools by now have followed D365 BC and other popular ERPs to the cloud, offering modern and flexible functionality to get you the reports your managers and executives need, they still have [at least] one problem: Somebody has to write those reports. This can feel very painful (including the time and cost involved), especially if you still remember the effort it took to get all required reports up and running in your old legacy on-premises ERP system.
However, there is a growing trend for cloud business solutions to offer pre-built apps (e.g. reports, connectors, etc.) in their own Marketplaces. Typically, this involves a few clicks to install; not that different from apps you download to your iPhone or Samsung phone. For example, in Solver’s Marketplace (see screenshot below), users can download Profit & Loss Reports and other financial statements, planning input templates, and more than 50 pre-built financial dashboards that plug right into your Power BI web-service.
In other words, with true Marketplace templates you should be able to provide your managers with professional reports and dashboards the same day you installed the reporting tool! In other words; a very quick time-to-value!
Summary
For new or existing Dynamics 365 Business Central customers, the 2020s hold a lot of promise, with Microsoft continuously improving and updating the ERP system and a rapidly growing Marketplace of third-party apps that further enhance the benefits of D365 BC. Picking the right solutions, including for reporting, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
A rapidly increasing number of mid-market organizations are implementing Microsoft Dynamics 365 Business Central (D365 BC). If you are considering a migration to D365 BC, the first thing to do is make sure the solution fits your needs and if you should consider any third party connected apps to automate certain processes that are key to your business.
When companies consider migrating their accounting solution from on-premise servers to the cloud, a key factor in the decision is the ability to automate and streamline accounting and finance processes. To ensure this occurs, companies not only have to review core ERP functionality to make sure it meets their current and future needs, but they must also review which tools to use for reporting, planning, and analysis. Some of these solutions are native to D365 BC while others, like Power BI dashboards data visualization tools, are embedded or connected apps from the Microsoft cloud stack. Still other apps are third-party best-of-breed solutions covering specific business processes.
This blog will focus on budgeting and forecasting integrated with Dynamic 365 Business Central and includes some elements you may want to think about to help ensure that your experience with D365 BC is maximized when it comes to producing:
- Annual budgets
- Monthly or quarterly forecasts
- What-if analysis and scenario modelling
- Strategic goals to drive your planning process
Why Use Planning Apps Instead of the Native Budgeting Features in Dynamics 365 BC?
D365 BC’s budgeting functionality enables basic budget input, but similar to almost any other cloud ERP system’s native planning tools, this inherent functionality is not the preferred place where a budgeting manager would want to oversee an annual budget process or produce a forecast. Here is a showcase that includes several hundred budgeting, forecasting and report examples that can provide an idea of the breadth and depth of capabilities typical for professional corporate performance management (CPM) tools. Tools that can help you optimize planning processes and related decision-making in your business.
While many D365 BC customers supplement their budgeting and forecasting tasks with home-grown Excel models, it usually becomes quite obvious when Excel no longer is the right platform for your planning models. Typical signs of pain include problems like:
- Errors with formulas and links
- No workflow
- Long duration (often 2+ months) of budget process due to lack of automation
- Lack of user security (especially for salary budgets, etc.)
- Inability to perform web-based input so files need to be shared and collected
- Painfully slow and inflexible budget consolidation and reporting options
These types of common issues leave an opening for the market’s best-of-breed budgeting and forecasting solutions to offer a purpose-built and professional planning experience that also can automate and streamline your budgeting and forecasting processes.
How to Pick the Right Planning Solution for Dynamics 365 Business Central
Much can be written about evaluation and selection of budgeting and forecasting solutions. We will not go into details in this blog, but if you would like some ideas, this document highlights key areas to consider. This interactive app also provides a simple way to compare and score planning tools. It includes an ROI calculator to analyze the cost/benefit of alternative tools versus your current solution.
In short, progressive Financial, Planning and Analysis (FP&A) departments of the 2020s want planning solutions that are flexible; closely integrated with their ERP as well as financial reporting (for variance analysis, etc.) and dashboard functionality; and that provide quick time to value.
What Is Considered a Quick Start with a New Planning Solution and How Is It Deployed?
These days, most D365 BC customers want their connected apps, including budgeting and forecasting tools, to be cloud based. The questions that quickly come up include: how complex integration of a best-of-breed planning solution with D365 BC might be and how much cost and effort will it take to get key budget input forms up and running in it. Forms such as:
- Employee payroll (with taxes and benefits)
- Capital expenses (with calculation of depreciation)
- Sales budget (by sales person and/or customer, product/service)
- Profit & Loss (revenues and operating expenses)
- Balance sheet with automated or semi-automated Cash Flow budgets
The typical answer: months of effort and tens of thousands of dollars in consulting services. However, some Microsoft software partners like Solver, that work very closely with Dynamics 365 Business Central and its partner channel, have developed pre-built ERP integrations as well as out-of-the-box budget templates. For example, Solver’s QuickStart integration to D365 BC can get a company up and running in a single day, with pre-built and customizable input planning forms, reports and Power BI dashboards. All of these forms, reports and visualization tools are available in a continuously growing template Marketplace.
A note about tools that offer integrations to D365 BC:
While almost all reporting vendors can claim to offer integrations to an ERP like Dynamics 365 Business Central, there can be big differences in the skill and effort involved to get such integrations ready and your financial data loaded into the planning and reporting tool.
Generally, there are three categories of integrations, each with its own effort level required to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for D365 BC, but not pre-mapped to popular fields with an app that configures dimensions and views in D365 BC to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for D365 BC and that include an app or script(s) that properly and automatically configure dimensions and views in D365 BC. Then it exposes them to its API, including pre-mapped popular dimensions and data. You can see an example of this type of integration here.
What Is a Template Marketplace and Why Is It Important to Your Business?
By now, most best-of-breed planning solutions have followed D365 BC and other popular ERPs to the cloud. They offer modern and flexible functionality to collect the budget and forecast data that your executives need. However, they still have at least one big deficiency: Somebody has to design those input forms and adapt them to your D365 chart of accounts and other key dimensions. This can be very painful when you include the time and cost involved, especially if you still remember the effort it took to get all required reports up and running in your old legacy on-premise ERP system.
These days, there is a growing trend for cloud business solutions to offer pre-built apps such as reports, input forms, connectors, etc. in their own Marketplaces. Typically, app installations only involve a few clicks to install from a marketplace. This is not that different from apps you are used to downloading to your iPhone or Samsung phone. For example, in Solver’s Marketplace (see screenshot below), users can download planning input templates, financial reports and more than 50 pre-built financial dashboards that plug right into your Power BI web service.
In other words, with true marketplace templates you should be able to provide your managers with at least a set of General Ledger account-level budgeting and forecasting templates the same day you install the planning tool! Now that’s a quick deployment!
Summary
For new or existing Dynamics 365 Business Central customers, the 2020s hold a lot of promise, with Microsoft continuously improving and updating their ERP system. You’ll also find a rapidly growing eco-system of third-party apps that further enhance the benefits of D365 BC. Picking the right solutions, including for planning, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
Cloud-based ERPÂ systems and Corporate Performance Management (CPM) solutions are two directly related business applications that are seeing rapid growth in the 2020s as companies and organizations seek to automate the office of finance and help their managers make faster and better decisions.
Replacing legacy ERPs and old, home-grown Excel reporting and budgeting models, however, takes both time and money. Especially for smaller and mid-sized businesses, this investment can delay their migration to Dynamics 365 Business Central (D365 BC) cloud for several years.
To aid a customer’s move to the cloud, companies like Microsoft and key ERP implementation partners like Armanino, BKD, Enavate, RSM, and Velosio have developed various cloud migration tools and processes to ease the pain. At the same time, Independent Software Vendors (ISVs), or ERP add-ons as they are often called, have been busy at work over the past few years creating bolt-on or add-in solutions that help automate specific areas related to D365 BC. Examples of ISVs offering these types of solutions include Binary Stream (multi-entity management and subscription management), Gorilla Expense (paperless expense reporting), Progressus (professional services automation), Integrity Data (payroll), Sana (eCommerce), and Solver (corporate performance management).
The rest of this blog will focus on how new cloud technologies enable D365 BC customers to automate their planning, reporting and analysis using modern Corporate Performance Management functionality at a lower cost and with much quicker time-to-value than what has been available in previous years.
Why Use Best-of-Breed CPM instead of the Native Tools in Dynamics 365?
Like most ERPs, D365 BC includes reporting, budgeting and dashboard functionality. Much like the other leading ERPs, like Sage Intacct, Netsuite and Acumatica, packing these three core feature sets into an ERP application and its corresponding database tables means that a lot of compromises have been made. Some of these shortcomings include lack of modelling, minimal workflow for approvals, inflexible input form design and weak formula capabilities, and lack of tables for detailed sub-ledger budgeting. In short, that is why the best-of-breed CPM software segment exists and the reason it is growing at a healthy clip.
From the user perspective, many of the smaller Dynamics 365 Business Central customers don’t have or don’t want to spend funds on additional business software applications that can provide more professional report formatting, consolidations, budgeting and forecasting they need for business oversight. As a result, Excel is used and still remains the world’s most popular reporting and planning tool. What typically happens is that customers will export data to Excel to build much-needed custom models specific to their businesses.
However, innovations in deployment and out-of-the box templates from leading CPM cloud vendors have put top notch CPM functionality well within reach for most organizations to use. In fact, here is a showcase that displays more than 500 examples of budgeting, forecasting, reporting and dashboard layouts just to give an idea of the breadth and depth professional CPM tools like Solver offer for deploying world-class planning and analysis processes that drive better, faster business decisions. You can also find ideas for visualization from the powerful dashboard functionality available when you connect Power BI to a best-of-breed CPM solution that combines your D365 data with planning data and other important information sources. Learn more by checking out these interactive dashboards.
When it comes to supporting a user’s graphical analysis needs, many D365 BC customers also rely on Excel. Why? Because they already own and know how to use it. Not to mention the interface is easy and flexible for building and maintaining the underlying calculations and charts. There is, however, a rapidly growing demand for cloud-based, best-of-breed CPM tools that integrate deeply with both D365 and Power BI for a dynamic and secure user experience that delivers rich, interactive charting and drill-down for a real-time and self-service reporting and analysis process.
How to Pick the Right CPM Solution for Dynamics 365 Business Central
Traditionally, the top CPM solutions–found in user feedback sites like G2 and in analyst reports from firms like Dresner Advisory Services–can handle most organizations’ reporting and planning needs. However, when it comes to integration capabilities, data modelling and template design, there can be a big difference in time to value, effort and cost.
While popular CPM tools may look similar in capabilities, some are going much further than others in simplifying the ERP integration and in delivering rapid return on investment with template-driven implementations. These other components include:
- Pre-built and pre-mapped integration to D365 BC that work out-of-the box with a few clicks and without the need to manually set up end-points in the D365 BC API nor manually map dimension and transaction fields to the CPM solution.
- Financial reporting templates like profit & loss reports and balance sheets that can be downloaded from the vendor’s marketplace and that immediately works without having to edit accounts and other formulas.
- Budgeting and forecasting templates with pre-defined versions and top-down and bottom-up input options.
- Dashboards templates with trends, variances and other analysis. As with the reporting and planning templates, these should work out-of-the-box without any manipulation of Power BI’s DAX formulas.
We will not go into details in this blog but, if you want some ideas, this document highlights key areas to look at, while this interactive tool provides a simple way to compare and score vendors, and includes an ROI calculator to analyze the cost/benefit of alternative tools versus your current solution.
In short, the progressive executive and finance teams of the 2020s want flexible financial reporting, budgeting and forecasting functionality closely integrated with D365 BC that provides quick time to value.
What Is Considered a Quick Start with a CPM Solution?
Most D365 BC customers want their connected apps, including CPM tools and dashboards, to be cloud based. Key questions that quickly come up are: how hard is it to integrate to the ERP and how much cost and effort does it take to get up and running?
The answer typically is weeks or months of effort and tens of thousands of dollars in services. However, Microsoft software partners, like Solver, that work very closely with Microsoft Dynamics 365 Business Central and its partner channel, have developed pre-built integrations as well as out-of-the-box financial reports, planning input templates and Power BI dashboards. For example, Solver’s QuickStart integration to Dynamics 365 Business Central can get a company up and running in a single day with 50+ pre-built Power BI financial dashboards, including optional financial reports and budget input templates. All of these ready-to-use forms and templates can be selected and downloaded at no additional cost from a continuously growing Template Marketplace.
A note about tools that offer integrations to D365 BC:
While almost all CPM vendors can claim to offer integration to an ERP like D365 BC, there can be big differences in the skill and effort involved to make such integrations ready and your financial data loaded into the reporting and planning tool.
Generally, there are three categories of integrations, each with its own effort level to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure
- Works but often with limitations:
- Quickest and easiest: Connectors specifically built for D365 BC that include an app or script(s) that properly and automatically configure dimensions and views in D365 BC and exposes them to its API. You can see an example of this type of integration here.
What Is a Template Marketplace and Why Is It Important to Your Business?
While you get a set of basic embedded Power BI dashboards with D365 BC and you can survive with its native reporting tool and homegrown Excel budget models, the leading cloud CPM tools of the 2020s offer many advantages to drive faster and better decisions.
In particular, some vendors are catching on to the popularity of app marketplaces after years of watching companies like Apple and Microsoft deliver easy-to-access solutions this way. CPM companies like Anaplan and Solver are now offering Template and Data Connector Marketplaces specifically built for planning and reporting needs. The main benefit to the customer is that this typically only involves a few clicks to install and incorporate your own data, compared with weeks or months of setup in legacy applications that don’t offer out-of-the-box templates.
For example, in Solver’s Marketplace (see screenshot below), users can download more than 50 pre-built financial dashboards that plug right into your Power BI web –service, in addition to Profit & Loss Reports, Balance Sheets and other financial statements and planning input templates.
With true marketplace templates you should be able to provide your managers with professional dashboards, financial reports and budget templates the same day you install the CPM tool, and with no upfront data modelling or formula design!
Summary
The 2020s is already shaping up to be a decade with a lot of exciting automations and insights companies can gain by implementing modern ERPs like Dynamics 365 Business Central with CPM solutions like Solver that have embraced deep D365 BC and Power BI integrations, that include “quick start†implementation wizards , and ready-to-use, downloadable templates from marketplaces. Picking the right solution, with planning and financial reporting considerations, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
Microsoft Dynamics 365 Business Central (D365 BC) and Power BI are both rapidly growing cloud solutions. Although these solutions can be used separately, they are very often used together as an integrated platform.
As executives drive their accounting teams to migrate to a modern cloud ERP system like D365 BC, senior leaders are, at the same time, hoping and expecting to gain world-class analysis with their new ERP. For that reason, evaluation teams not only have to review core ERP functionality to make sure their current and future needs are met, but they also must review which tools to use for dashboards, reporting, and planning.
Power BI is the natural data visualization dashboard choice for Dynamics 365 ERP customers. It comes both as an embedded option inside D365 BC and, with a full license, it can be used as a stand-alone web service that includes all kinds of other data as well. As with all flexible dashboard software, however, it can be complex, time-consuming and costly to develop Power BI report models with numerous dashboards and then tailor them to your business dimensions, including your chart of accounts.
This blog will focus on rapid deployment of Power BI dashboards for Dynamic 365 Business Central data, as well as several factors you may want to think about to ensure your executive’s expectations are met or exceeded when it comes to providing them with:
- Revenue Dashboards
- Expense Dashboards
- Variance Dashboards
- Exception Dashboards
- Trend Dashboards
- Balance Sheet Dashboards
- KPI Dashboards
- Benchmarking Dashboards
Why Use Stand-alone Power BI Dashboards to Compliment the Native Tools in Dynamics 365?
D365 BC’s embedded Power BI dashboards offer a few simple, pre-built templates, but, similar to almost any other cloud ERP system’s native or embedded dashboard options, it lacks the full flexibility a finance team usually requires when producing highly professional, automated graphical dashboards.
Here is a showcase that features more than a hundred dashboard examples, and which provides a general idea of the breadth and depth of capabilities many professional reporting tools offer to help you improve and democratize analysis for better, faster decisions in your business. You can also find additional ideas by trying these interactive Power BI dashboards.
Many D365 BC customers support a user’s graphical analysis needs through Excel because the software is already owned, users already know how to use it, and the interface is easy and flexible to build while maintaining the underlying formulas. However, there is a rapidly growing demand for cloud-based, best-of-breed dashboard tools like Power BI that offer a dynamic and secure user experience with rich, interactive charting and drill-down that provides a real-time and self-service reporting and analysis process.
How to Pick the Right Dashboard Solution for Dynamics 365 Business Central
Much can be written about the best and most affordable way to deploy Power BI. Most organizations find that delivering a rich and sustainable dashboard experience to their business and office of finance users requires more than just a Power BI license. These other components include:
- Pre-built financial dashboard templates that work out-of-the box, and that can be changed or copied to support special custom needs.
- Financial reporting and planning that compliments Power BI graphical dashboards. Here is more information about things to look for in professional reporting and planning
- A data warehouse or staging database to organize key D365 BC data and dimensions, with the added capability to include non-ERP data, which delivers a clean data model to Power BI. Read more about pre-built financial data warehouses here.
We will not go into details about dashboard software evaluation in this blog but, if you want some ideas, this blog highlights key areas many people want in a dashboard, while this interactive tool provides a simple way to compare and score vendors It also includes an ROI calculator to analyze the cost/benefit of alternative tools versus your current solution.
In short, the progressive executive and finance teams of the 2020s want dashboard solutions that are flexible; that are closely integrated with financial reporting, budgeting and forecasting functionality; and that provide quick time-to-value through template-based deployment.
What Is Considered a Quick Start with a Power BI Dashboard Solution?
Most D365 BC customers want their connected apps, including dashboards, to be cloud based. The questions that quickly come up include: how hard is it to go beyond the embedded Power BI version that already comes with D365BC, and integrate the full-blown Power BI solution with the ERP? How much cost and effort does it take to get key financial dashboards up and running?
The typical answer is weeks or months of effort and tens of thousands of dollars in services. Sometimes, the end result is static or the ability to maintain models is complicated and hard. This results in disappointing outcomes. However, Microsoft software partners like Solver, that work very closely with the Dynamics 365 Business Central solution and its partner channel, have developed pre-built integrations, as well as, out-of-the-box dashboards to resolve these challenges. For example, Solver’s QuickStart integration to Dynamics 365 Business Central helps a company get up and running in a single day, providing access to 50+ pre-built Power BI financial dashboards, as well as, optional financial reports and budget input templates. All of these turn-key options are available from a marketplace that continuously grows with new templates.
A note about tools that offer integrations to D365 BC:
While almost all dashboard vendors can claim to offer integration to popular ERPs like D365 BC, there can be big differences in the skill and effort involved to get such integrations ready and your financial data loaded into the reporting tool.
Generally, there are three categories of integrations, each with its own level of effort to get going:
- Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
- Works but often with limitations: Connectors specifically built for D365 BC, but does not include an app to pre-map popular fields nor automatically configures dimensions and views in D365 BC to “light them up†for its API.
- Quickest and easiest: Connectors specifically built for D365 BC that include an app or script(s) that properly and automatically configures dimensions and views in D365 BC and exposes them to its API. This results in a “clean†data model that Power BI can easily consume. You can see an example of this type of integration here.
What Is a Cloud Dashboard Marketplace and Why Is It Important to Your Business?
While you are given a set of basic embedded Power BI dashboards with D365 BC, most companies end up designing their own graphical reports using the full Power BI license. However, offering modern and flexible functionality that quickly delivers the dashboards your managers and executives need is often a pipe dream. There is at least one problem: Somebody has to design all those dashboards and learn the underlying formula language (referred to as “DAXâ€). This can seem painful (including the time and cost involved), especially if your leaders are eager to get their dashboards sooner rather than later and without a big consulting bill attached.
However, there is a growing trend for cloud business solutions to offer pre-built financial dashboards that are downloadable and ready-to-use from each vendor’s marketplace. Typically, this involves a few clicks in order to install and refresh the report with your own data. The process is not that different from apps you download to your iPhone or Samsung phone. For example, in Solver’s Marketplace, users can download more than 50 pre-built financial dashboards that plug right into your Power BI web-service in addition to Profit & Loss Reports, Balance Sheets and other financial statements and planning input templates.
In other words, with true marketplace templates, you should be able to provide your managers with professional dashboards and reports the same day you install the reporting tool–and with no upfront formula design or Power BI model building! Now that’s a quick deployment!
Summary
For new or existing Dynamics 365 Business Central customers, the 2020s hold a lot of promise. Microsoft is continuously improving and updating their ERP system, while a rapidly growing Marketplace of third-party apps further enhances the benefits of D365 BC. Picking the right solutions, including for dashboards, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.
