Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

InterDyn Artis, an LBMC Technology Solutions Company

Take the Mystery Out of Reporting with Microsoft Dynamics GP Reporting Tools


Email | Print

In today's business environment, it's critical to have up-to-date information to make informed business decisions. Microsoft Dynamics GP (formerly Great Plains) has a large number of pre-formatted reports for comprehensive reporting and analysis.

Below is a highlight of Microsoft Dynamics GP reporting tools recently discussed at a Microsoft Dynamics Reporting Tools Workshop hosted by InterDyn Artis. The workshop was held for the Microsoft Dynamics GP community at the Microsoft office in Charlotte, NC.  Each attendee received a complimentary in-depth manual of these reporting tools
Download the complimentary Microsoft Dynamics GP Reporting Tools manual

  • 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:o
    • 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.
  • SQL Reporting Services Report Builder (SRS)- SRS has report models that make it straightforward to design simple reports that can then be published for use outside of GP.

To learn more about Microsoft Dynamics GP Reporting Tools contact InterDyn Artis today.

by Interdyn Artis - North Carolina Microsoft Dynamics GP Partner

8 Responses to “Take the Mystery Out of Reporting with Microsoft Dynamics GP Reporting Tools”

  1. Hey Boss – its a nice blog, just looking around some blogs, seems a pretty nice platform you are using. I’m currently using WordPress for a few of my sites but looking to change one of them over to a platform similar to yours as a trial run. Anything in particular you would recommend me about it?

  2. Scott Van Der Linden says:

    I am constantly amazed at the flexibilty of Dynamics. Thanks for this insightful information.