Posts

solver microsoft

In a recent announcement, Microsoft and Solver launched a “Cooperation Agreement” (Agreement) to deliver deeply integrated planning and reporting for Microsoft’s Dynamics 365 Finance. This Agreement offers several benefits for current and future Dynamics 365 Finance (Finance) customers; and as a byproduct, many of these same benefits will also be available for Microsoft Dynamics 365 Business Central (Business Central) customers. Key benefits for Finance customers, Business Central customers, and both (D365) are discussed below.

Advanced CPM Software

One Version of the Truth

With a two-way integration between D365 and Solver, customers will be able to easily synchronize data between D365 and Solver, and update completed budgets and forecasts from Solver back into D365. Furthermore, customers will be able to drill down on reports in Solver to source transactions in D365.

Vendor Stability

In recent years there have been many acquisitions in the corporate performance management (CPM) and analytics space, often making customers uncertain about the future direction of their vendor. One of the most well-known of these acquisitions was when ERP vendor Workday acquired Adaptive Insights (Adaptive) in 2018. While it was an exciting transaction for Workday customers, it was not good news for Adaptive customers and Partners on ERPs competing with Workday. With Solver’s independent status, focus on the Azure cloud platform, and now this new Agreement with Microsoft, customers can look forward to years of integration enhancements and platform benefits.

More Leverage of the Microsoft Azure Platform and Other Microsoft Products like Teams and Excel

Since its inception, the Solver cloud product has had a deep integration to Excel for its report and budget form design experience. Microsoft Teams users can view Solver reports in Teams while discussing budgets and financials with other users, all on the Microsoft Azure platform. As part of the recently announced Microsoft Agreement, Solver will also deliver several enhanced integrations and other capabilities to D365 customers.

Easier Cloud Migrations to D365 for Legacy Dynamics AX, NAV, GP and SL Customers

There is still a large, global customer base running the on-premise Microsoft Dynamics legacy ERPs.

Solver’s integrations to Dynamics AX, NAV, GP and SL will assist Dynamics legacy customers’ migration to D365 at a reduced cost and amount of effort. In a nutshell, legacy customers can “park” their important historical AX, NAV, GP and SL data (e.g. 10 years’ worth) in Solver’s cloud data warehouse, and minimize the data they need to convert and load into their new D365 cloud ERP, thus saving time and cost.

Quick-Time-to-Value and Low Implementation Risk

The enhanced, two-way integration resulting from the Solver – Microsoft Agreement provided an opportunity to create QuickStart, an integration wizard that includes Solver’s unique mapping technology which enables immediate use of pre-built financial reports, budget forms and Power BI dashboards. While reporting and planning tools typically take weeks or months for customers to integrate, deploy and design, Solver’s QuickStart technology enables cloud tenant deployment with a standard D365 integration and pre-built financial templates to be up and running in as little as one day. This quick-time-to-value frees up more time for partners and customers to create high value analytics content. It also lowers the risk of implementations going over budget and not delivering promised value.

Eliminate or Reduce Dependency on Manual Excel Models or Legacy CPM Platforms

D365 customers will be able to save costs and reduce effort by eliminating old, manual planning and reporting models and consolidating them into the Solver cloud platform.  Most businesses extensively use homegrown Excel models to meet specific formatting requirements, and to customize budgeting and forecasting models. Some also have legacy third-party CPM solutions with ongoing high maintenance costs.

These companies will now be able to deploy Solver with deep two-way integrations into their D365 system, saving time and effort, with fewer models and technologies to update and maintain.

More Time for Analysis and Daily Accounting Tasks

The rapid time-to-value and simpler upkeep resulting from the technologies evolving out of the Microsoft – Solver Agreement will give the office of finance more time for analysis and high value tasks.  Direct time savings and improved efficiency are key customer benefits of interoperability between D365 and Solver. Furthermore, users will see continuous expansion and improvements in out-of-the-box integrations, including third-party apps that work with D365, as well as a growing marketplace with out-of-the-box reporting and planning templates.

The Promise of a “Cleaner” ERP?

One of the premises of the entire CPM software category is to provide a connected, best-of-breed planning and reporting solution. When customers plan their CPM solution before deploying their new ERP system, it has a great potential to eliminate unnecessary, complex or “clunky” ERP configurations patched up with accompanying complex manual Excel models.

The Agreement between Microsoft and Solver also promises a reduction of compromises done with dimensions and other setups during an ERP implementation. Adjustments that are typically done to purely to satisfy native ERP reporting or planning requirements. The new agreement provides the potential for cleaner, more user-friendly ERP deployments.

Advanced CPM Software

Higher ROI on Microsoft Dynamics 365 Finance & Business Central Investment  

Most companies at this point have a plan to migrate to a cloud ERP, if they haven’t already done so.  Those that have previously experienced ERP implementations know the risks of running over time and over budget. Because of the many benefits brought by closely aligned ERP and CPM solutions, and how the Microsoft – Solver Agreement further enables this, customers are likely to enjoy a higher return on investment (ROI) for their new D365 solution.

Summary

While all modern cloud ERPs have application programming interfaces (APIs) and independent software vendor (ISV) apps that can connect to provide additional value to customers, deeper relationships like the one between Microsoft and Solver is rarer and offers many new benefits to customers as they continue to digitalize and automate their processes as they move their business apps to the cloud.

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

What is a Profit & Loss Report with Links to Supporting Sub-ledger Reports?

Financial statements with links to sub-ledger reports are considered self-service analysis reports and are often used by managers and accountants to provide users with easy answers to their questions. Key functionality in this type of report allows the user to click on the hyperlinked account numbers located in the first column. These links will open a different report that provides granular details about the figure seen in the financial statement. Examples of such reports can include a sales report explaining a revenue figure, or an accounts payable report explaining the details behind an expense figure. You will find an example of this type of report below.

Purpose of Profit & Loss Reports with Links to Supporting Sub-ledger Reports

Companies and organizations use Profit & Loss Reports with Links to Supporting Sub-ledger Reports to give users a way to answer their questions by providing direct drill-down to detailed sub-ledger transactions. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its speed of decision-making, as well as, reduce the time that managers constantly ask accountants to go back to the ERP system to explain figures in financial statements.

Profit & Loss Reports with Links to Supporting Sub-ledger Report Example

Here is an example of a Profit & Loss Report with hyperlinks to underlying sub-ledger transaction reports.

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

You can find hundreds of additional examples here.

Who Uses This Type of Report?

The typical users of this type of report are: Executives, Department Heads and Financial Managers.

Other Reports Often Used in Conjunction with Profit & Loss Reports with Links to Supporting Sub-ledger Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Profit & Loss Reports with Links to Supporting Sub-ledger Reports, along with balance sheets, cash flow reports, transaction analysis reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

financial planning analysis blog

The rapid growth of Microsoft’s Dynamics 365 Business Central (D365 BC) cloud ERP system comes with investments in add-on app solutions by independent software vendors (ISVs)For example, Progressus is a company as described above and has a project solution for D365 BC. With Progressus, small and mid-sized companies receive easy-to-configure and advanced project accounting functionality in the cloud. 

However, as all project-centric business managers know, good transactional systems also need proper financial planning and analysis tools. In today’s highly competitive market, this can be the difference between success and failure.  As successful project-based companies invest in new cloud-based ERP systems like D365 BC and add advanced project apps like Progressus, a natural next step after the implementation is to look for an integrated and flexible reporting and planning solutionA reporting and planning software like Solver can operate down to the detailed field and dimension level in the Progressus tables inside the ERP system.  

Project Reports for D365 and the Progressus App

Lately, most companies prefer pre-integrated solutions. Due to this, Solver partnered with Progressus and now the corporate performance management solution delivers an out-of-the box integration to both Dynamics 365 Business Central and Progressus. Solver not only provides D365 BC customers with a strong financial reporting and budgeting software for general ledger and sub-ledger data, but it also now extends this functionality into all the project detail provided by Progressus. 

Customer Benefits:

  • Pre-built integration to Dynamics 365 and Progressus tables
  • Pre-built Progressus Project reports
  • Full report writer with Excel design
  • Optional Budgeting module
  • Multi-tenant Azure Cloud Platform
  • Pre-built Power BI integration for interactive Dashboards

However, as with any reporting solution, pre-built report templates speed up deployment when can be used as a starting point. 

Solver offers a number of project-focused reports for Progressus including:  

  • Benchmarking
  • Project Manager Benchmarking
  • Project Capacity by
    • Customer Group and Resource
    • Department and Resource
    • Customer Group and Resource
  • Project Detail by Customer
  • Project List
  • Resource Detail
  • Actual vs Budget Variance

 

project capacity

project 2

Both solutions are independently integrated to Microsoft Dynamics 365 Business Central. After the partnership between the two companies, they decided to configure a joint integration. With the rapid growth in popularity of cloud ERP software like D365 BC, one of the next big cloud drivers is that ISVs, such as Progressus and Solver, work together to give customers elegant integrations across both standard ERP data as well as transactions originating from ISV add-ins to the ERP systems. This eliminates many of the custom integrations that are configured in the old on-premise platforms.

Technology is driving major industry changes into the next decade. Project managers and executives will need and demand complete insight to their data to drive faster and better decisions. Cloud-based ERP vendors and ISVs are making good strides to make this happen!

The information you are reading is more than 2 years old and may be outdated. Read new blogs.
solver suite live reporting
The information you are reading is more than 2 years old and may be outdated. Read new blogs.
award-best-work-la-2019

This article focuses on the future of Dynamics GP Users and their Reporting and Budgeting tools.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

Why are many companies still keeping their Dynamics GP ERP system on-premise when there is a cloud option available? Some may not know the options to migrate to the cloud. Others may feel safer using a more traditional platform. Microsoft just changed the whole game for Microsoft Dynamics Enterprise Resource Planning (ERP) users. A true cloud version of Microsoft Dynamics, Microsoft Dynamics 365, officially released this November 1st. Dynamics 365 lets companies combine CRM, ERP and Microsoft Office capabilities into the next generation of business applications in the cloud. This Azure-hosted Dynamics service seems to be the true future for many Dynamics GP customers. Therefore, if your company is slowly making its way to the cloud, and on premise tools are most likely developed less progressively, eventually moving to Dynamics 365 or other CRM/ERP tools seems a pretty interesting alternative. This article focuses on the steps your company will need to take when your ERP is moving to the cloud.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will discuss financial report writers in today’s marketplace for manufacturing organizations looking to expand their SAP Business One experience.

 
ManufacturingReporting_PLHave you used a Fitbit before to track your fitness activity, diet and sleep? If you have specific fitness goals to be healthier and the Fitbit carries all the features and functionalities you need, this tracker is perfect because it describes in detail an event, situation or occurrence. Similarly, a financial report writer collects and presents financial data so that it can be analyzed. Reporting is the necessary prerequisite of analysis. Reporting makes data understandable and ready for accurate and efficient analysis so you can better reach your company goals. This article will discuss your options for features and functionalities that third party solutions are offering for your SAP Business One (SAP B1) system, specifically zooming in on data management and analysis in manufacturing companies.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article discusses the modern, dynamic, and business user friendly financial reporting options available for Healthcare organizations using Sage 100.

It has been a while since I have blogged, and in that time, I have had several great opportunities to talk to finance and accounting professionals, as well as executives, about their Business Intelligence (BI) and Corporate Performance Management (CPM) needs.  Some of these conversations happened at BI360 Focus 2016, some of these manifested as one-off conversations, and one even occurred on a flight to Portland.  Lately though, it seems like I have not only been in conversation with more healthcare professionals, but I’ve also found myself personally and professionally curious about this industry.  The healthcare industry seems to be one of the most complex and regulated sectors – and for good reason obviously, but the effect it has on financial reporting requires sophisticated, yet business user friendly BI tools.  The best financial reporting tools for Sage 100 users offer Healthcare-specific data management that produces the necessary financial reporting and/or dashboards.
This blog article will focus on modern financial reporting with Sage 100.  I’ll first discuss the bigger picture of what you should be looking for to achieve your financial reporting and analytical objectives.  Then, I’ll zoom in on the financial reporting modules delivered by certain, more dynamic products that can enable Healthcare organizations to produce traditional financial statements, meet regulations, and present information to key stakeholders and decision-makers.
Read more