SSRS GL Trial Balance Returning No Data

Posted on 14th June 2012 by Ian Grieve

I was doing some testing to compare the SSRS Trial Balance against the standard report version but ran into a problem straight away when I found the SSRS version returned no data.

A quick search online found me this post SSRS: GL Trial Balance Summary report returns no data – Follow Up by Mariano Gomez where he discussed the exact problem I had encountered.

As Mariano says this has been fixed in the upcoming SP3 but for now there is a Knowledge Base article covering a workaround which is to alter the stored procedure (seeglPrintSRSTrialBalance) which is used for returning the data: GL Trial Balance SRS Reports return no data using Microsoft Dynamics GP.

About Ian Grieve

Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently working for Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England. Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews. In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.

View all posts by Ian Grieve →

This entry was posted in Dynamics, GP, Microsoft and tagged Financials, General Ledger, Microsoft, Microsoft Dynamics, Microsoft Dynamics GP 2010, Microsoft SQL Server, Microsoft SQL Server 2008 R2, Reporting, Reports, SSRS, TSQL. Bookmark the permalink.

2 comments on “SSRS GL Trial Balance Returning No Data”

Leave a Reply Cancel reply

Pre-Order My Book
Login

Username

Password

Remember Me
- Register
- Lost Password
Search azurecurve

Search for:
Translation Tool
Post Calendar
June 2012

M T W T F S S

« May Jul »

1 2 3

4 5 6 7 8 9 10

11 12 13 14 15 16 17

18 19 20 21 22 23 24

25 26 27 28 29 30
Categories
Tags
Configuration CRM Customisations Downloads eConnect Errors Financials General Ledger GP Installation Installation & Configuration Integration Integration Manager Inventory Control Leslie Vail Management Reporter Management Reporter 2012 MDGP 2013 Feature of the Day Microsoft Microsoft Dynamics Microsoft Dynamics CRM 2011 Microsoft Dynamics GP 10 Microsoft Dynamics GP 2010 Microsoft Dynamics GP 2010 R2 Microsoft Dynamics GP 2013 Microsoft SQL Server Microsoft SQL Server 2008 R2 Packt Publishing Payables Management Payment Run Purchase Order Processing Purchasing Receivables Management Reporting Reports Sales Sales Order Processing Security Site News SQL Script System Web Client Web Services Windows Windows Server
Dynamics GP Community
Map of Visits
Disclaimer

This blog and its content is provided "AS IS" with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages arising out of the use of, or inability to use, information or opinions expressed in this site and confers no rights.

The links in this blog may lead to third-party Web sites to provide access to third-party resources to assist you in finding other services and/or technical support resources. Information at these sites may change without notice and azurecurve is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.