Export Dynamics GP Trial Balance to Excel

Do you ever need to export your Financial Trial Balance (or even your AR or AP) to Excel?  Tired of printing your GP Trial Balance report to a CSV file and then attempting to open it in Excel, and then delete the report/page headings every 20 or 30 lines?

Well, now you can use the SQL Reporting Services (SRS) report that comes default with Dynamics GP 10!  SRS reports natively export nicely to Excel, saving you much time and trouble.

With the release of Dynamics GP 10, several of the most common GP reports were updated (and I do mean that in all possible senses) to SRS.  About 75 reports in total, from the major modules.  If you are running SQL Reporting Services on your SQL Server (2000, 2005, 2008), you can access these reports through GP or a URL.

1. Make sure you are running IIS somewhere (if your server is not overloaded, you can do this on the SQL Server itself)
2. Make sure SRS is installed as part of your SQL Server installation.  I will not go into details in this post, but you can read more at MS books online site.
3. Configure Reporting Services (either at install time using the defaults, or manually using the config tool)
4. Install the Dynamics GP SRS Wizard from the AdProd folder of the GP DVD (or disc 2 of the CD set, or downloaded from Partnersource/Customersource)
5. Run the tool, and select one or more companies for which to deploy the reports
6. In GP, under Tools - Setup - Reporting Tools Setup, specify the URLs of the SRS reporting site (usually http://servername/ReportServer/reportservice.asmx and http://servername/reports/pages/folder.aspx)
7. 
8. In GP, under the Administration navigation pane tab, clock on Custom Reports List to view a list of SRS Reports deployed.

So now you can open these reports from within GP, or point a user to them (After giving them appropriate security) using a URL.

The GL Trial Balance report will be in the COMPANY_CODE - Financial folder.  There is a Detail and Summary report.  Run one, pick your options, and then hit View Report.

Once it is up, you can select Excel as the output option and hit "Export" and you now have a GP Trial Balance in a well-formatted Excel spreadsheet!