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