Reporting Tool

reporting tool"reporting tool"

Microsoft Dynamics GP Reporting Tools. What are my Options?

Today, more than ever, it's critical to have up-to-date information to make informed business decisions. Microsoft Dynamics GP has a large number of pre-formatted reports for comprehensive reporting and analysis.

Below is a highlight of Microsoft Dynamics GP reporting tools available in every edition

FRx report designer links directly to Microsoft Dynamics GP General Ledger. You would use this report design tools for GL level reports, including consolidated reports, working over FRx reporting tree. Also it works with GL budgets as well as has an option to consolidate your GP companies with virtual companies, which are exported into Excel worksheet - FRx has Excel linking mechanism.

Smartlist Builder/Excel Reporter - Used to create Smartlist other than those out-of-the-box with GP. Smartlist 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.

• Smartlist with Export Options - Used for ad-hoc queries in Great Plains. 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 GP. Reports are not formatted unless Export Options is used to run macros to format the Excel file. Create Smartlist favorites and export them to Excel. Record macros that manipulate and format the data. These macros are saved with the smartlist export so that you can execute them each time you export the smartlist to Excel.

Excel (MS Office) - A powerful reporting tool that integrates with SQL data, FRx, Smartlist, Analysis Cubes, and SQL Reporting Services. Pivot tables allow users to summarize and "slice and dice" a set of data in many ways.

• Excel Pivot Tables - One of the most powerful data analysis tools available in Excel. Learn the basics of how to use a pivot table in relevant examples such as departmental distributions for AP aging.

 

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

 

Out of the Box SQL Reporting Services Reports - You can give non-GP users access to the most commonly requested reports, such as trial balances, aging reports, sales summaries, and stock status reports. Manage security on the SQL server and allow the users who need these reports to run them in internet explorer - without ever logging into GP.

About the Author

Imtiaz Ahmed , a Certified Dynamics GP Consultant who works with Medium sized Enterprises in Pakistan can be reached at http://www.ax-1.com

Watch Storage Monitoring & Reporting Tool Demo Here!


reporting tool
reporting tool
reporting tool