hybrid cloud

There are around 40,000 Microsoft Dynamics GP customers world-wide and many are not planning to move to the cloud yet. However, if you are one of them, this does not mean that your company can’t start taking advantage of modern cloud-based reporting solutions today to drive better and faster decisions for yourself and your management team!

Hasn’t Cloud-based reporting for on-premise ERPs been available for a long time?

Yes, vendors like Prophix, Solver, Vena, Adaptive Insights, and Planful (formerly Host Analytics) have offered both cloud-based financial reporting and budgeting for years. However, all of these vendors have typical corporate performance management (CPM) architectures that require data to be loaded from the on-premise ERP and into the cloud CPM tool before the user can run reports. 

The process requires a “refresh” of data from the ERP database into the CPM database which means that the data users see in reports is not real-time. This also mean that the drill-down on any number is only as detailed as the lowest level data that was loaded into the cloud CPM database. 

Your executives are often ok with this because they want to wait on their report analysis until the accounting team has closed the books. However, the accounting team that is posting transactions in the ERP system almost always prefers live ERP reporting because they want to immediately see the impact of journal entries in their reports. They don’t want to refresh data into a CPM reporting database first, and then wait one minute, ten minutes or significantly longer to run reports after the data has been transferred to the CPM tool.

How do I get true live reporting for my on-premise Dynamics GP data?  

The obvious answer is that you use an on-premise report writer like the default Management Reporter tool, GP Report Writer, Smartlist or SQL Reporting Services (SSRS). However, while none of these tools are inferior to what is offered by other ERP systems, and they have aged “gracefully,” they are just not comparable to many modern cloud reporting tools.

Key weaknesses of on-premise report tools include:

  • Not particularly user-friendly for accounting staff to design reports.
  • Lack of easy and professional formatting.
  • Typically requires VPN or Terminal Server to connect to Dynamics GP in order to run reports from outside the office network.
  • Maintaining multiple report writers for different data (e.g. Management Reporter for GL reports, and GP Report Writer and SSRS for sub-ledger reports).

In order to overcome these weaknesses and help GP customers maximize the value of their data with modern, cloud-based reporting tools, Solver has now launched what they refer to as “Hybrid Cloud Reporting.” You can see it live in this video. This is a unique integration technology that enables you to:

  • Use your web-browser to run beautifully formatted reports (looks like Excel formatting).
  • Benefit from true real-time reports on your GP data without any data transfer to a separate reporting database.
  • Drill-down from any number in the report directly into your underlying GP transactional data.
  • Easy internet and browser-based access with no need for VPN, or software like Terminal Server.
  • Enter budgets from user-friendly forms (looks like Excel) in the cloud and have the transactions stored directly into your budget table in Dynamics GP. 

In other words, now your accountants and reporting end-users get the best of two worlds by only needing a web browser to run live reports on GP and drill-down.

Below is a simple architecture diagram to explain how it works:


What about budgeting and forecasting?

Like many other cloud-based CPM solutions, Solver also offers budgeting and forecasting. With the new Hybrid Cloud technology and Solver’s cloud-based Planning Module, users can store budget data directly back from Solver’s budget forms in the cloud, into the General Ledger budget table in Dynamics GP. 

So, if you struggle with manual Excel-based spreadsheets for your budgets, you can save a lot of time by eliminating emailing files between users, linking between spreadsheets, and put better controls in place for the entire budget process with workflow and approvals. 

As an example, users can access budget forms like the example below with their browser and instantly, until you close the budget process, update their department’s budget in Microsoft Dynamics GP. Since Solver’s Hybrid Cloud updates are real-time, reports can immediately be run to see the impact of these changes on the budget.

Enjoy Faster and Better Decisions in the 2020s

Companies like Solver, Prophix, Vena, Adaptive Insights, and Planful are driving the next generation cloud-based reporting and planning technology. However, with the lack of live reporting and live budget write-back to on-premise ERP systems like Microsoft Dynamics GP, accountants and very active ERP users have been left with their legacy tools for their real-time reporting needs.  

With the release of Solver Hybrid Cloud for Microsoft Dynamics GP, these users now get the best of both worlds and can start ushering in the 2020’s by enabling themselves and other users with faster and better decisions.  Learn more about the benefits of choosing Solver CPM solutions by contacting us today or requesting a demo. 


LOS ANGELES, CA. — March 3, 2020 — Solver, the global leader in cloud and web-based Corporate Performance Management (CPM) for mid-market ERP systems, has been recognized by Analytics Insight Magazine as one of the Top 10 Most Influential Analytics Leaders of the Year.  Analytics Insight Magazine selects its annual list of Influential Analytics Leaders based on who drives digital transformation, opens new ways to create business value and facilitate data-driven decision making across organizations globally.  After another year of growth in cloud subscriptions, Solver sees this award as further acknowledgement of the Solver Cloud deployment’s success.

As Solver continues to grow, developing its CPM solution into the most efficient, dynamic option in the mid-market space remains its primary focus.  Solver has focused on releasing pre-built integrations directly addressing its most widely used ERP systems, including those from Microsoft Dynamics, SAP and Sage.  With the recent release of its Hybrid Cloud Connector for Microsoft Dynamics GP with additional ERPs to follow shortly, Solver is able to offer live cloud-to-on-premise ERP reporting capability  that makes its CPM solution even more compatible with the majority of its users.  While the growth of Solver’s cloud platform signals its direction as a leader in CPM solutions, Solver also continues to nurture its on-premise users.  In addition to product development, Solver has also consistently added new content to the Solver Academy eLearning portal covering the latest training content updates.  Not only does Solver strive to provide the most innovative CPM solution to its partners and customers, but it puts equal importance on efficient support and service resources as well.

Says Solver CEO Nils Rasmussen, “To me, the 2020s represents the most exciting decade so far for the analytics industry.  We have incredible technology enablers like cloud and AI that the industry can take advantage of to drive innovation and process improvement for customers.”  He adds, “I also think leaders need to challenge the status quo in their industry and ask themselves how their organization can innovate not only to drive revenue and profit growth but to improve the lives and businesses of their customers, partners and team members.”

Solver views the Top 10 Most Influential Analytics Leaders recognition as strong continuation of its start to the new decade, where it expects even more growth for its cloud platform.

To read Solver’s feature article, click here.


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


This article will zoom in on your options for modern, robust budgeting in the cloud for Microsoft Dynamics GP.  Read more

This article will discuss dashboard solutions for real estate companies that are seeking to enhance Microsoft Dynamics GP data analyses.

realestateVisualization has some beneficial side effects. Visualization improves your performance; helps reach your potential, increases focus, boosts confidence, and so much more. Think about professional athletes. For instance, everyone from tennis player Serena Williams to Arnold Schwarzenegger, who was a world champion body builder before he became an actor, have practiced visualization techniques. It makes sense to apply visuals to your financial reports and presentations. Think about receiving a stack of spreadsheets full of data. Is this how you extract your financial analysis? This is where a dashboard comes into play. The amount of data being created every year continues to grow tremendously. If your organization wants to make informed decisions, your company leaders need to be able to access and interpret data in real-time. The ability to act quickly on the data has become a competitive differentiator. A dashboard presents key data on a single page and uses visuals to summarize a large amount of data. In this article, we will discuss how dashboards will help real estate companies that are using Dynamics GP. Read more

This article is the second part in planning for a KPI design project.

KPI1A Key Performance Indicator (KPI) is a lot like a GPS navigation system. A GPS navigation device allows a driver or a passenger to be in charge when making decisions about where to steer next. KPIs are the navigational tools that the team will use to understand whether the business is on a successful journey or whether it’s veering off. As mentioned in the previous article, a KPI can help your company understand if your company is on the right track and if it’s not, it can help your company understand where to focus your attention. According to Klipfolio, a KPI is “a measureable value that demonstrates how effectively a company is achieving key business objectives.” Organizations use KPIs at many levels to assess their success at reaching targets. High-level KPIs focus on the overall performance of the organization whereas low-level KPIs zoom in on processes in departments. In this article, I will cover the last 5 steps in planning for a successful KPI design project for Microsoft Dynamics GP users based on the “Designing Metrics and Key Performance Indicators chapter” of Business Dashboards, a book published by John Wiley & Sons, Inc. Read more

This article is the first part in planning for a KPI design project.

KPI1A Key Performance Indicator (KPI) can help your company understand if your company is on the right track, and if it is not, it can help your company understand where to focus your attention. Love them or hate them, but KPIs might become the backbone of your business. A true definition of a KPI is a metric that is meant to be a measure that truly matters and that ideally can be acted on. KPIs are financial and non-financial metrics used to help a company define and measure their progress toward company goals. A metric can be the number of customers, the number of sales, or total revenue. Once you have defined your business goals, identifying and aligning the KPIs for your business will be easier and simpler. In this article, I will cover the first 5 steps in planning for a successful KPI design project for GP users based on the Designing Metrics and Key Performance Indicators chapter of the Business Dashboards published by John Wiley & Sons, Inc.
Read more

This article will discuss modern, dynamic reporting for media organizations that use Microsoft Dynamics GP, including what to look for in a software solution.

Financial reporting is absolutely unavoidable in the modern business world.  We’re all doing it, whether it is a homegrown Excel process, a legacy program, the native Microsoft Dynamics GP report writer, or an independent software vendor (ISV) solution.  And the media industry is no different.  In terms of process improvement, upgrading your reporting writing processes with a new solution means automated financial statements, modern security, accessible collaboration, and self-service analytics.  This article will explore what you should be looking for in a report writer to meet today’s analytical objectives, zooming in on what a reporting tool should offer you as a media organization using Microsoft Dynamics GP.
Read more

This article discusses dashboard solutions for media organizations that are seeking to enhance their Microsoft Dynamics GP data analyses.

Whether your organization focuses on television, radio, the Internet or a different medium, a complete dashboard solution would be an effective way to ensure your company meets the demands of the digital disruption. Data visualizations provide easily digestible and accessible data analyses with charts, graphs, and scorecards that spotlight trends, successes, and challenges employing key performance indicators (KPIs) and your data to inform management decision-making for a department, a project, and/or the entire company.
Read more

Image taken from Shutterstock.

This article is an interview with Solver Controller Gina Louie about wrapping up end of year with reporting for Dynamics GP users.
Recently, I had the opportunity to sit down with the person responsible for wrapping up Solver’s operational and financial year, Controller Gina Louie.  With her hands-on experience, this interview is a must-read for best practices to wrap up end of year for any organization.
How is the end of year different for finance and accounting teams like yours when compared to end of month?
Read more