Posts

How to Quickly Get Started with Corporate Performance Management for Microsoft Dynamics 365 Finance

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

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.

Rapid budgeting and forecasting implementation for Acumatica with pre-built templates from Solver Marketplace

How to Quickly Deploy the Best Budgeting and Forecasting Tools for Acumatica

A rapidly increasing number of mid-market organizations are implementing Acumatica as their new cloud ERP system. If you are considering a migration to Acumatica, 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 in Acumatica 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 Acumatica. The information below includes some tips you may want to consider to ensure your ROI and Acumatica 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 Acumatica?

Acumatica’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 an annual budget process or produce a forecast. This showcase of forms and 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 Acumatica 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 Acumatica

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 Acumatica customers want their connected apps, including budgeting and forecasting tools, to be cloud based. Questions that quickly come up include: how complex might be an integration of a best-of-breed planning solution with Acumatica, 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 Acumatica software partners like Solver, that work very closely with Acumatica 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 Acumatica 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 Acumatica:

While almost all reporting vendors can claim to offer integrations to an ERP like Acumatica, there can be big differences in the skills and effort involved in having these integrations ready 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 Acumatica, but do not include an app that configures dimensions and views in Acumatica nor pre-maps to popular fields to “light them up” for its API.
  • Quickest and easiest: Connectors specifically built for Acumatica and that include an app or script(s) that properly and automatically configure dimensions and views in Acumatica. 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 Acumatica 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 Acumatica 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, 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 budgeting and forecasting implementation for Acumatica with pre-built templates from Solver Marketplace

Rapid budgeting and forecasting implementation for Acumatica with pre-built templates from Solver Marketplace

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 Acumatica customers, the 2020s hold a lot of promise. Acumatica is continuously improving and updating their ERP system, and there is a rapidly growing eco-system of third-party apps that further enhance the benefits of Acumatica. 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.

LOS ANGELES, CA. – August 20, 2020 – Solver, a global leader in cloud and web-based Corporate Performance Management (CPM) for mid-market ERP systems, today announced their recognition as an Experience Leader and a Trust Leader in Enterprise Performance Management in Dresner Advisory Services’ 2020 Industry Excellence Awards, based upon vendor ratings from the Customer Experience and Vendor Credibility models in their annual series of flagship Wisdom of Crowds® Market Studies.

“We are excited to receive this recognition from Dresner Advisory Services and it is a great motivation for our global teams to keep enhancing customer experiences in any area we see opportunities to excel,” says Nils Rasmussen, CEO at Solver.

“Our hallmark research, and by extension the Industry Excellence  awards, are based solely on the input of customers with first hand experience using the technology and interacting with suppliers on a regular basis,” said Howard Dresner, founder and chief research officer at Dresner Advisory Services. “We recognize the organizations who are highly regarded by their customers and offer our congratulations to Solver on their first year of inclusion in our annual award program”.

The annual Industry Excellence Awards go to vendors who have achieved a leadership position in the Dresner Advisory Services 2020 Wisdom of Crowds Business Intelligence (BI), Enterprise Performance Management (EPM), and/or Analytical Data Infrastructure (ADI) Market Studies.  The reports are based on data collected from end users and provide a broad assessment of each market including current usage, key drivers, technology priorities, and future intentions, as well as performance ratings of relevant vendors.

The Customer Experience model considers the real-world experience of customers as they work with a vendor’s technology solution on a daily basis, plotting the various customer touch points against sentiment surrounding product and technology. The Vendor Credibility Model considers a vendor’s relationship with customers, plotting perceived value for price paid against a calculated “confidence” score. Vendor ratings are based solely on voice of the customer.

Overall, Solver demonstrated high levels of sales and service as well as product/technology while Solver customers reflected a high level of confidence and sense of value for price paid.

 

About Solver

With a quickly growing community of thousands of global customers and hundreds of partners worldwide, Solver provides a leading cloud Corporate Performance Management suite for Microsoft Dynamics 365 Finance and Operations and Business Central, Acumatica, SAP Business One, SAP ByDesign, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, NetSuite and other ERPs. Solver is ranked in the leader quadrant in the Corporate Performance Management (CPM) Software Grid on G2, and as a Microsoft Gold ISV Partner, Solver has won countless awards, including Enterprise Performance Management 2020 Dresner Industry Excellence Award, Microsoft BI Partner of Year Award, recognition on the Gartner Group CPM Magic Quadrant, and Best Places to Work for a workplace culture that celebrates customer service, integrity, and innovation. Solver is sold through its 12 global offices and a worldwide network of partners. For any questions, visit www.solverglobal.com or contact Solver at info@solverglobal.com.

 

About Dresner Advisory Services

Dresner Advisory Services was formed by Howard Dresner, an independent analyst, author, lecturer, and business adviser. Dresner Advisory Services, LLC focuses on creating and sharing thought leadership for Business Intelligence (BI) and related areas.