Today, more than ever, it's critical to have up-to-date information to make informed business decisions.
SmartLists with Export Options Used for ad-hoc queries in Microsoft Dynamics GP. Queries can be saved as Smartlist favorites to be used again. The user enters restrictions and changes the columns displayed. This can be used to export query results to Excel and as a shortcut to data in Microsoft Dynamics GP. Reports are not formatted unless Export Options is used to run macros to format the Excel file.
SmartList Builder/Excel Reporter Used to create Smartlists other than those that are out-of-the-box with Microsoft Dynamics GP. Smartlists can be built to combine companies, pull third party data, and pull data from other databases. Excel Reporter was added to Smartlist Builder with the version 10 Feature Pack for Dynamics GP. Excel Reporter is used to create refreshable Excel reports similar to Smartlist exports except that the data may be refreshed in Excel. Data connections used by these tools can be deployed to be used in Excel.
Excel (MS Office) A powerful reporting tool that integrates with SQL data, FRx, Smartlists, Analysis Cubes, and SQL Reporting Services. Pivot tables allow users to summarize and “slice and dice” a set of data in many ways. Data connections are a more restricted alternative to direct access.
Analysis Cubes Used to allow users who are not familiar with database structures to write reports. The cubes store a fraction of the data in the ERP system to allow users to dig into data. Excel is the primary delivery method, but there are sophisticated OLAP viewers available.
Dynamics GP has 2 cubes available:
- Financial – GL, AR, AP, Bank Rec.
- Distribution – SOP, POP, Inventory
SQL Reporting Services (SQL Server) SRS is used to deliver reports via an intranet/internet to users throughout the organization – regardless of whether or not they are Dynamics GP users. SRS can combine data from multiple sources and multiple companies. Reports are accessed using Internet Explorer and the security is controlled via the server. Reports are designed in Visual Studio.
- SRS Reports from MS – approx. 90 report templates available with version 10. These can be modified in Visual Studio.
- SRS Report Builder – a “light” version of SRS that uses report models to define the data that is available to users. Users can create simple reports and make them available in the SRS Report Manager.
Microsoft FRx (Report Designer, Report Launcher, Drilldown Viewer, Report Server, WebPort, Report Manager) Used for Financial Statements. FRx pulls data from Microsoft Dynamics GP General Ledger, Excel, FRx Forecaster.
**Report Manager creates Report Books that allow you to combine multiple files in one package.
Microsoft Management Reporter The next generation for FRx. Available with Microsoft Dynamics GP 2010, this is the replacement for FRx. A migration wizard converts FRx building blocks to MR report definitions.
Microsoft Forecaster Budgeting application available with BRL licensing. Generate budget reports, forecasts, financial statements within the application and copy to Excel.
Check out and
InterDyn Artis, established in 1989, is a Microsoft Gold Certified Partner dedicated to the implementation, training and support of the Microsoft Dynamics line of products including
By InterDyn Artis, a