Posts

While mid-market and enterprise resource planning (ERP) vendors offer native financial consolidation software, their limitations often leave users still in search of a solution that can produce.

Here are a few reasons why it has been difficult for ERP vendors to deliver the financial consolidation functionality inside the ERPs itself.

Common Limitations in Current Financial Consolidation ERPs

  • Problematic to consolidate across subsidiaries with different ERPs
  • Clunky consolidation process with too many steps
  • Manual consolidation adjustments, which can be tedious to post
  • Inability to handle different chart of accounts
  • Weak auto-elimination functionality
  • Limited currency conversion functionality
  • Weak financial report writer to produce the consolidated reports
  • Lack of dynamic pro-forma consolidations
  • Inability to consolidate across subsidiaries with different fiscal calendars

Overall, consolidating within your ERP system remains a clunky process with too many steps. As a result, an organization’s finance team ends up carrying out the process in Excel, where they are likely comfortable using formulas.

Your ERP’s Current Consolidation Solution

Even with many popular ERP systems such as Microsoft’s Dynamics 365 Finance and Operations (D365 FO), SAP, Oracle or Workday, customers with significant consolidations and related financial reporting needs often end up depending on Excel, especially in the final steps of the process.

While ERP systems typically contain many consolidation features, and might even have a native Management Reporter that is an above-the-average report writer, it is increasingly normal that customers add on a “best-of-breed” corporate performance management (CPM) solution to simplify their financial consolidation and reporting software.

Modern cloud-based CPM solutions

Solver is an example of a CPM solution that comes with several added advantages, especially for Microsoft customers.

Advantages of Solver CPM for Financial Consolidation

  • Solution is cloud-based Azure
  • It’s configurable to general ledgers as well as sub-ledgers
  • It has a pre-built connector to Power BI for visualization

PowerBI_Dashboard_01

 

Some cloud-based CPM vendors like Solver now also offer an Excel add-in to give power users more flexible and familiar report design.  Additionally, in some CPM solutions, end users can still run the same reports in the cloud using their web browsers. They could do the same using their local Excel on the desktop connected to the CPM database in the cloud.

Additionally, modern cloud-based CPM solutions typically house advanced budgeting and workflow capabilities. This allows for a single solution and a single report/form designer for financial reporting, consolidations and budgeting.

Upgrade Your ERP System With Solver

To learn more about how modern CPM solutions integrate with popular ERP systems like D365 F&O and Business Central, Sage Intacct, SAP and Accumatica, click here.

LOS ANGELES, CA. – February 18, 2020 – Solver, a global leader in cloud and web-based Corporate Performance Management (CPM) for mid-market ERP systems, today announced the launch of its new Hybrid Cloud Connector for the Microsoft Dynamics GP ERP system.  Solver’s Hybrid Cloud Connector is a unique cloud-based solution which enables Dynamics GP users to run real-time financial reports in Solver’s cloud by directly connecting to their hosted or on-premise GP database.  With no intermediate loading and storing of data like the majority of cloud-based reporting solutions, Solver’s Hybrid Cloud Connector offers a flexible solution to Microsoft Dynamics GP users.

Solver’s Hybrid Cloud Connector consists of two unique technologies:

  • A pre-built integration to both general ledger (GL) and sub-ledger data with friendly field names users are familiar with from within Dynamics GP — instead of technical SQL table names.
  • A Gateway that securely connects reports run from the Solver Cloud Portal directly to the on-premise or hosted Dynamics GP database.

Solver is also excited to launch the Hybrid Cloud Connector for Dynamics GP in part because very few cloud-based reporting solutions today are capable of doing real-time reporting for an on-premise ERP system.  Beyond reporting, the Solver Hybrid Cloud Connector is also ideal for organizations looking for a General Ledger (GL) budgeting and forecasting solution which can save budget and forecast updates directly into Dynamics GP. With this new connector, Solver adds more flexibility and functionality to its CPM solution.

“In some ways, for customers using Dynamics GP, this is what almost all accountants want, which is a modern reporting solution with real-time connection to their GL and sub-ledger data” says Nils Rasmussen, CEO at Solver. He continues “And because the Solver solution is cloud-based, there is no software installation required for the end-user, just a web browser. This means that users can now run their GP reports from any web browser and drill down to detail from anywhere at anytime without VPN, Terminal Server or Excel add-ins. Anyone tired of Management Reporter/FRx, Excel add-ins or other on-premise report writers now has a modern cloud option without losing their real-time access to GP data.”

In the near future Solver will also release this real-time cloud-to-on-premise integration technology for other ERPs, including Dynamics NAV/D365 BC, Dynamics SL, and several SQL-server-based ERPs from Sage and SAP.  In the meantime, Solver expects its Hybrid Cloud Connector to further enable Microsoft Dynamics GP users to make better, faster decisions in their financial reporting.

 

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 the 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.

powerbiandsolver

If you have ever tried to build and maintain financial reports inside a visualization tool, the answer should be simple. Power BI works well for dashboards, but modern cloud-based corporate performance management (CPM) solutions are the best option for your financial reports.

BI vs. CPM

Let’s elaborate. Power BI belongs to a category typically referred to as Business Intelligence (BI) tools. While purpose-built, financial reporting and consolidation tools belong to a category referred to as Corporate Performance Management (CPM) Software.

Business Intelligence:

In the business intelligence category, you also find other well-known solutions such as Tableau and Domo. For the most part, BI tools are purpose-built for dashboards with rich visualizations. Also, BI tools are increasingly infused with artificial intelligence (AI) capabilities.

Corporate Performance Management Software:

On the other hand, CPM solutions are specifically designed for accounting teams to consolidate financial data. CPMs often produce professionally formatted financial reports such as: 

  • Profit & Loss
  • Balance Sheet
  • Cash flow statements

Most CPM reporting tools offer budgeting modules. And in recent years, the ability to do sophisticated planning such as sales forecasting and modeling.

If the difference between BI and CPM is so clear, why is “Financial Reporting in Power BI or in a Corporate Performance Management Solution” even a topic worth covering in a blog? 

Well, with the rapid rise in popularity of Power BI for financial reporting and its key competitors, an army of “hungry” consultants have emerged.  And, given a strong and flexible tool like Power BI, a sales person with the right technical skills can make almost anything, including formatted financial reports, look good.  Many companies have fallen into this trap lately of using Power BI for financial reporting. And, when you ask a skilled, revenue motivated consultant: Can you do that? Chances are that you will get a “Yes!”  And after a few weeks…or a few months, and a sizable consulting bill, you may actually have good looking Power BI financial reports.  But, as excited as your executives may be to have a single cloud-based portal for both dashboards and financial reports, for most financial executives this has a tendency to turn into a small nightmare.  Why?

Because neither Power BI nor its BI competitors were designed to manage a financial reporting process.

A lot of hard coding and hacking is needed behind the scenes in Power BI’s modeling language. Of course, if you are ready to hire a technical expert or keep your Power BI consultant permanently retained to handle model changes as your chart of accounts grows, your roll-ups change or you need to write a new report, you could survive for a while. Eventually, we can say with certainty, you will be back in Excel to do your financial reporting where your accounting team is comfortable with formulas and formatting.

Alternatively, you can deploy a CPM solution that is built to streamline the financial process. Also, you can deploy a CPM tool to deliver professionally formatted financial statements.

With a CPM solution, you can also move your budgeting process into the CPM tool and run it all in the cloud.  Now, it does not have to be an either or.

The Best Way: Use BI Tools and CPMs Reporting Tools Together

An increasing number of CPM vendors offer pre-built integrations to leading BI tools like Power BI.

Two such vendors are Solver and Prophix. As an example, Solver is similar to Power BI in that it is an Azure cloud-based platform, and it comes with a pre-built connector to Power BI.  Below is an example of a comparison between Power BI and Solver. It clearly shows that companies looking for both dashboards and financial reporting should use a BI tool for their dashboards and a CPM tool for their financial reporting. Neither tool replaces the other.

power bi and solver

As organizations gear up for what can be the “Roaring Twenties,” having the right tools for the job might be one of the smartest strategic moves a management team can make. On the other hand, trying to fit a square peg in a round hole, could lead to frustration. The frustration is delayed reporting and wasted money. It is increasingly accepted that “data is the new gold.” When Power BI is integrated with a best-in-class CPM solution and both are running in the cloud, organizations are likely a step closer to success and industry leadership in the years ahead.

Consolidation_01

For many years it seems like every mid-market and enterprise resource planning (ERP) vendor has aspired to offer native financial consolidation software. However, they all seem to fall short, often to the disappointment of customers that were promised that their new ERP system easily could produce the consolidated financials from their individual subsidiary ledgers. 

So why is it so hard for an ERP vendor to deliver the necessary financial consolidation functionality inside the ERP system itself? There can be any number of reasons.

Limitations in Current Financial Consolidation ERPs

  • Lack of ability to handle different chart of accounts
  • Lack of ability of consolidating across subsidiaries with different fiscal calendars
  • Poor currency conversion functionality 
  • Weak auto-elimination functionality
  • Tedious to post manual consolidation adjustments
  • Weak financial report writer to produce the consolidated reports
  • Clunky consolidation process with too many steps 
  • Problematic to consolidate across subsidiaries with different ERPs
  • Lack of dynamic pro-forma consolidations

 

It would be a controller’s dream if all of these areas were elegantly handled within their ERP system. And, while most mid-market and enterprise ERPs typically can check all or most of the boxes for consolidation features, almost always, consolidating in the ERP it is simply too clunky with too many steps. Because of this, the finance team ends up doing it in Excel where they at least are comfortable with formulas and they can produce professional report layout. 

 

overloaded manager

Microsoft Dynamics 365 ERP

But what about Microsoft’s Dynamics 365 Finance and Operations (D365 FO) ERP system? 

While it clearly can be considered one of the top cloud solutions on the market today- alongside SAP, Oracle and Workday– customers with significant consolidations and related financial reporting needs, often end up in Excel in the final steps of the process. 

While there are plenty of ERP consolidation features in D365 FO, and its native Management Reporter is an above-the-average report writer, it is increasingly normal that customers add on a “best-of-breed” corporate performance management (CPM) solution to streamline their financial consolidation and reporting software.  

Modern cloud-based CPM solutions

Solver is an example of a CPM solution that comes with several added advantages for Microsoft customers.

Advantages of Solver CPM for Financial Consolidation

  • Solution is cloud-based Azure like D365 FO
  • Its configurable to D365’s general ledger as well as sub-ledgers
  • It has a pre-built connector to Power BI for visualization

PowerBI_Dashboard_01

 

Some cloud-based CPM vendors now also offer an Excel add-in to give power users more flexible and familiar report design. 

End users can still run the same reports in the cloud using their web browsers. They could do the same using their local Excel on the desktop connected to the CPM database in the cloud.

Consolidation_01

 

An added advantage of modern cloud-based CPM solutions is that they typically also house advanced budgeting and workflow capabilities. This allow for a single solution and a single report/form designer for both financial reporting, consolidations and budgeting. 

Level Up Your Dynamics 365 Finance & Operations With Solver

In the next decade, enabling faster and better decisions will be one of the key competitive advantages. This advantage differentiates successful, growing companies from others. 

Dynamics 365 Finance and Operations, a leading ERP solution, is a great cloud-based transaction platform because it drives better data and accounting processes. A modern CPM solution with a snug fit on top of D365 FO and that compliments visualization in Power BI checks the boxes that a finance team needs to take their ERP financial consolidations and reporting processes to the next level.

Payroll-Now-Blog-Picture-1200×675
BudgetingForecasting_01

This article will provide insight into some of the key features you could expect from modern corporate performance management (CPM) solutions.

Cloud-Computing-Concept.-The-Future-Everything-from-Socket

This article focuses on modern cloud-based reporting using BI360 as an example of a solution that is affordable and enables companies to make better business decisions.

PowerBI_Dashboard_01

This article focuses on the best of both worlds: a world-class reporting solution and a leading visualization tool.

Ascendfam-1200×800

This year’s BI360 Partner and Customer Conference, Ascend 2019, has proverbially sailed into the sunset. And it was amazing!

Read more

shutterstock_74784901-1200×1200

This article will focus on the benefits of partnering with a company that offers a corporate performance management solution as a product.

Image taken from Shutterstock.

Read more