SQL Reporting Services (SRS) for Microsoft Dynamics GP

Is your boss, who may not be a Microsoft Dynamics GP user, continually asking you for GP reports such as AR or AP agings? Take yourself out of that loop and empower your boss at the same time by implementing SQL Reporting Services – you already own it!

SQL Reporting Services (SRS) is a component of SQL that can be installed in a few minutes. With GP version 10.0, you also get a library of reports out of the box that can be deployed, in a secure fashion, very easily. These reports should look familiar to existing GP users.  Below is an out of the box AR aging report available in SRS. The report can be printed or exported to a number of formats, including Excel and PDF. It can be generated from a secure website inside your firewall or it can be delivered via e‐mail on a schedule you define to the recipients who need the report. 

Users can get an e‐mail with a link to the report and/or a file in a specified format, such as PDF.  In addition to the out of the box reports provided with version 10, users can design custom reports.  These reports can include not only data from GP tables but data from third party products, custom  tables, and different databases. In order to write reports, some knowledge of SQL is required. The  report writing tool itself should not be hard to learn for anyone who has any report writing  experience in another report writing tool such as Crystal Reports.  SRS has something for everyone in your organization who needs access to GP and other SQL data.  Each series has its own folder on the website.  Each folder contains a broad selection of reports.

You can designate who can see each individual report using network security. Consumers of reports need not be GP users. In fact, if you have employees who use GP simply for reports or inquiries it may be possible to entirely eliminate their need to use GP. So you can use this free software, SRS, to keep down your GP licensing costs.