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

Payroll-Now-Blog-Picture-1200×675

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

Visualization 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 bodybuilder 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.

What are Dashboards for Real Estate?

Dashboards are defined as charts, graphs, and scorecards that convey data trends, successes, and problem areas with key performance indicators (KPIs), whether you are looking at a product, location, a corporate department in particular, or the entire company. Real estate companies can benefit tremendously. For instance, there are dashboards that allow agents and brokers to have complete control over how their listings are performing and dashboards that show an overview of the real estate projects that contribute the most to the organization’s revenues.

Dashboards can integrate your organizational data from multiple sources so that you’re able to see what the big picture will look like without having to access your library of applications and systems. If you’re looking for simple, but real-time analytics for your data, you can rely on the built-in dashboard functionality within your Dynamics GP system. Dashboards exist to make sense of your data in one snapshot in a customized format that enables the end-user to view any metric he/she wants.

Benefits of Real Estate Dashboards

With a dashboard solution, real estate companies can see their information organized into one location using visuals that improve operational efficiency by making more informed business decisions in a short amount of time.

Historical data can be produced to identify successes and challenges from the past. Also, real-time data can be used to forecast the power of current business decisions based on future organizational goals. Since company information is reported in real-time, any potential challenges can be identified and corrected to resolve problem issues quickly.

Additionally, it is common to have multiple, easy-to-read dashboards, as opposed to having one dashboard and packing information and visuals into it. This will allow your end-users to know exactly the information they find on each dashboard. For instance, a real estate benchmarking dashboard shows how you can compare the sales performance of your own company against the industry and a competitor, and a chief operating officer (COO) dashboard gives COOs access to a single view about the revenue-generating units (RGUs).

The right dashboard will transform the success in running a real estate company by identifying relevant information from your sources, predicting results early on, eliminating any inaccurate data, and enhancing decision-making for your company. Your company can track information over specific periods of time, monitor current company performance, and summarize important company data by using aesthetically-pleasing visuals such as graphs, charts, and other features. More companies are investing in commercial dashboard tools, but they are facing problems like information overload. If there is too much information or if there are too many visuals, your dashboard will not be easily readable.

How to Choose the Right Technology Platform for Your Real Estate Dashboard

There are several technology platforms to consider when looking to invest in a dashboard. Software that have Excel add-ins may be the easiest choice to implement due to how familiar the spreadsheet program and its functionalities and features are for people who already are familiar with Excel. Dashboards can be produced in the Excel spreadsheet, but interactive visuals are important to executives. An increasing number of real estate companies are looking for web-based tools, including browser-based dashboard solutions, both on-premises and/or in the cloud. Web-based solutions provide access from anywhere you have internet access. There are also mobile dashboard applications for real estate agents who are usually on-the-go and moving from space to space. There are a few independent software vendors (ISVs) creating mobile dashboards, with screen size limited to one KPI or visual each time. There are some dashboard software offerings that join Excel, mobile, and web types of data access.

If you’re on the management team for a real estate company, you will be able to monitor the top 10 projects based on sales, the budget, and the actual sales trend for each project, numbers of units added to inventory, number of available properties per month for a specific project, and many more. Dashboards enable your company to be aware and stay competitive with accessible and business user-friendly analytics. It will be important to come up with specific BI goals and compare with modern dashboard solutions, so you can invest in the best tool for your team. Modern dashboard tools offer powerful and easy-to-use features and functionalities to access, interpret, and understand company data for better decision-making.

Choose Solver for Easy to Use Dashboards

At Solver, we would be happy to answer questions and generally review our Solver Suite’s Excel, web and/or mobile-based, easy-to-use dashboards module (stand-alone and component) in the comprehensive suite of BI modules for collaborative, streamlined decision-making capabilities for real estate organizations using Microsoft Dynamics GP.

Solver enables world-class decisions with BI360, a leading web-based CPM suite made up of budgeting, reporting, dashboards, and data warehousing, delivered through a web portal. Solver is reinventing CPM with its next-generation solution. BI360 empowers business users with modern features including innovative use of Excel in the model design process. If you’re interested in learning more, our team is excited to hear about your organizational needs and goals.

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.

mediadashboard
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