Posts

hybrid cloud

There are more than 200,000 companies running on-premise ERP systems from Microsoft, Sage, SAP and Acumatica 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 ERP GP data?  

The obvious answer is that you use the report writer that natively comes with your ERP system such as  Management Reporter, GP Report Writer, Smartlist or SQL Reporting Services (SSRS). However, at best, it would be safe to say that these tools have aged “gracefully,” and 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 the ERP in order to run reports from outside the office network.
  • Maintaining multiple report writers for different data (e.g. for formatted financial statements versus sub-ledger transaction reports).

In order to overcome these weaknesses and help on-premise ERP customers maximize the value of their data a modern, cloud-based reporting platform, 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 ERP 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 the GL budget table in the ERP database.
  • Be better prepared to move to a cloud ERP later because the reporting and budgeting solution is already in the cloud. 

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 ERP reports and drill-down.

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

hybriddiagram

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

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 the ERP system. 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, 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, 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. 

Supported ERP systems are: Microsoft Dynamics GP, SL, and NAV, Sage 100 (SQL)*, 300* and 500*, SAP Business One (SQL)*, and Acumatica*.

*) Direct budget writeback not offered for these ERPs.

 

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.

Image taken from Shutterstock

This article discusses the differences between corporate performance management (CPM) and business intelligence (BI) solutions in the cloud technology era.

On this blog, we write a lot about corporate performance management (CPM) tools. And we talk a lot about business intelligence (BI) solutions. In fact, we seemingly use the terms interchangeably – and there’s some thought behind that. BI and CPM exist in the same realm of enterprise technology that makes sense of the health of the organization. They both pull data from a variety of sources to crunch numbers and analyze information, so that you can pinpoint strengths, weaknesses, opportunities, and threats. However, there are some differences, and while their output might not seem mutually exclusive, there is not much overlap. As we continue our ascent to the new normal of cloud technology platforms, it will be helpful for companies to understand the differences between the two, so the right solutions can be deployed to meet organizational goals. This article will highlight the distinctions between BI and CPM solutions, so you can continue to build your cloud technology roadmap with precision.
Read more

In this article, financial reporting solutions for organizations utilizing Dynamics 365 for Finance and Operations, Business Edition will take center stage, so you can make the best software investment.
 

Image taken Shutterstock.

Image taken Shutterstock.


Last November, Microsoft took the wraps off of Microsoft Dynamics 365. It combines Dynamics customer relationship management (CRM) and enterprise resource planning (ERP) solutions into one integrated cloud product offering. As many of you know, there are two versions of Microsoft Dynamics 365. One, the Business Edition, is the lower end version based on the Dynamics NAV product in its structure. The higher end version, Enterprise Edition, is based on Dynamics AX and is designed for the higher end of the market. Both are architected for and deployed in the Microsoft Azure cloud, and it’s managed and hosted by Microsoft. This article will cover financial reporting tools for your company using Dynamics 365, Business Edition. Read more

sales-icon-blue

Image taken from Shutterstock


This article will discuss the established place for Cloud-Based CPM – the journey to embracing the newer platform and the value proposition that became a tipping point.
If you are as plugged into technology as even the next guy, you are definitely aware of “the cloud” – and that it is taking over as the new normal in terms of hosting files, applications, and networks. You might not know that much about what it all means, but you probably understand that hosting in the cloud means you’re not storing your pictures or your software or your connection to other devices on-premise. The iCloud might be the most pervasive example, with the popularity of Apple products, as it takes any files that you might have traditionally just stored on your cell phone (contacts, music, photos) and houses them in the cloud. Now, as cloud continues to build momentum, it has permeated the business technology space – and has finally established itself as a suitable platform, if not soon to be a leading platform option, for corporate performance management (CPM) and business intelligence (BI) solutions. This article will discuss the journey to this place of embracing the cloud as a platform for CPM and BI tools – and why companies are seeing the cloud as the future, right now.
Read more

Image taken from Shutterstock


This article is the final installment in a series focused on how Corporate Performance Management (CPM) tools can serve as a true solution, particularly zooming in on budgeting and forecasting challenges companies face with data housed in multiple cloud and on-premise systems.
The last blog article I wrote, I zoomed in further on the multi-cloud world that businesses today are navigating – and how Corporate Performance Management (CPM) and Business Intelligence (BI) processes and specifically, modern financial and operational reporting tools, can function as a complete solution to the related technological and data management oriented challenges we’re all facing. If you think about all of the essential enterprise technology solutions making the shift to the cloud, it can seem like a lot, especially in terms of the challenge to integrate and/or combine all of this diverse data. There are also on-premise tools, which is where plenty of accounting systems are still residing. But what about budgeting and forecasting – and all of the historical data from disparate sources needed to effectively plan? This article will focus on planning as an important BI and CPM process – and how the right application can be a true solution to your obstacles related to multi-cloud management.
Read more

Image taken from Shutterstock


This article is the second in a series about how Corporate Performance Management (CPM) applications can function as a true solution, this time specifically in regard to reporting and analysis challenges businesses face with data spread across multiple cloud and on-premise systems.
Last week, I wrote about this multi-cloud world that we are definitely already living in – and how Corporate Performance Management (CPM) and/or Business Intelligence (BI) systems can serve as a complete solution to technology and data management challenges that come with multiple cloud systems. Considering the number of enterprise technology applications moving to the cloud that are essential to running today’s businesses, it can be overwhelming and quite frankly, challenging to integrate and/or consolidate all of these data sources. On top of that, there are on-premise tools as well, where a lot of accounting systems still reside. Now, as our understanding of data and how we can harness this insight continues to evolve into more richly integrated manifestations, the multi-cloud reality can be frustrating. This article will zoom in on reporting as part of BI and CPM processes – and how the right tool can be a complete solution to your life, as we know it, in a multi-cloud era.
Read more

Image taken from AdobeStock


This article is the first in a series about how Corporate Performance Management (CPM)  applications can be a true solution for the reporting, analysis and budgeting challenges that businesses face with their data spread across multiple cloud and on-premise systems.
I recently wrote about multi-cloud deployments – defining the term, explaining how it works, and the motivation behind such a strategy. However, with more research and talking to those in the trenches of enterprise technology and system management, whether as a power user, an end user, and/or an IT professional, I increasingly realized that most organizations are already living in a truly multi-cloud world. Businesses today, generally speaking, are already harnessing the power of multiple cloud services and applications, as well as on-premise tools, to run their businesses. And this can be problematic in terms of bringing together all of your data sources for complete, actionable analyses for informed decision-making. This article will explore how the right Business Intelligence (BI) and/or Corporate Performance Management (CPM) system can be a complete solution to life in a multi-cloud world.
Read more

This article discusses the benefits of hybrid cloud deployments for your Business Intelligence and Corporate Performance Management systems.
In today’s business culture, cloud computing is common for enterprises and organizations, no matter the size. It was not always like this, as the technology seemed lofty, new, and unsecure. However, over time, the technological advances, the accessibility of company data from anywhere with an internet connection, and the scalability of cloud computing has reduced costs and made this business culture technology evolution a relevant consideration for all companies. And Business Intelligence (BI) and Corporate Performance Management (CPM) solutions have followed the move to cloud deployments, so if you’re involved with data management, analysis, or decision-making at your company, you might be wondering how to proceed – if you haven’t already made the leap. This article will zoom in on the benefit of implementing a hybrid cloud approach as a way to take your BI and CPM processes to the next level.
Read more