This article will discuss the benefits of consolidating your many reporting tools.
How many of us use five or more report writers across our business systems? I know it sounds absurd, but most organizations do use that many reporting tools across their ERP system and other databases. When looking to invest in a reporting tool, how you integrate and present your data is very important. It is the backbone when it comes to making wise business decisions. In this article, I will focus on various options for consolidating multiple reporting tools to navigate your organization-specific issues in managing and analyzing your data.
This article focuses on financial reporting options for non-profit organizations utilizing Microsoft Dynamics GP, zooming in on features and functionalities to expand your analytics.
Financial reporting has traditionally been the lead singer if Business Intelligence (BI) processes were in a band, and it is no different for non-profit organizations. If you’re utilizing Microsoft Dynamics GP, you know that the accounting system is equipped with several native financial reporting functions. However, plenty of organizations are moving to independent software vendor (ISV) offerings for their regular financial reporting tasks, but why? Third party software solutions for financial report writing are designed in response to consumer demands, streamlining and expanding analytics for more robust insight into your data, trajectories, successes, and challenges. This article will explore the benefits of an ISV financial report writer for non-profit organizations using Microsoft Dynamics GP.
Smartlist is a very popular query tool used by all Microsoft Dynamics GP customers worldwide. It has hundreds of useful SQL Views to allow GP users to filter and retrieve transactions from different tables in the GP database. BI360 now integrates to Smartlist views to provide an almost unlimited number of opportunities for business users to drill down from BI360 financial reports and into GP without having to create their own drill-down queries. For example, a department head can run a Profit & Loss report for his or her department, notice a budget variance on a row (e.g. Office Supplies) and with one click, drill down into the Accounts Payable transaction in GP and retrieve the vendor’s Purchase Order and see each line item on the purchase order. Not only does this provide instant answers to business questions without having to bother accountants and power users, but it also does not require the user to have any knowledge of the Dynamics GP application, as both the drill down and the resulting view of the underlying transactions all happen from with the BI360 Excel-based report interface.
For a detailed example of the BI360 integration to Smartlist, please contact Solver and ask for the white paper “Integrating BI360 to a Smartlist view”.
The BI360 Drill To function is available for all BI360 ERP integrations, including Microsoft Dynamics AX, NAV, GP, SL, Sage MAS 500 and X3. and Epicor Prophet 21. This document provides a detailed example of how to integrate a Smartlist SQL view with the powerful Drill To feature in BI360 (version 3.5 and later) for the purpose of setting up a drill down rule that let a user drill down from a Profit & Loss report and all the way into sub-ledger (here: Accounts Payable) transactions in the GP database.
Data Retrieved from Drilling to Smartlist
Customizing the Integration to include Smartlist Views