Wednesday, February 22, 2012

SSRS: GL Trial Balance Summary report returns no data - Follow Up

Back in July of last year, I wrote an article on a reported issue with the SSRS GL Trial Balance reports were not returning any data with Microsoft Dynamics GP 2010 and 2010 R2 (SP2) - see SSRS: GL Trial Balance Summary report returns no data.

Since then, this problem has been documented in KB article 2588519 - GL Trial Balance SRS Reports return no data using Microsoft Dynamics GP and a workaround provided in the same article to fix the ailing stored procedure, dbo.seeglPrintSRSTrialBalance, causing data not to be returned.

The good news is, this problem is scheduled to be fixed in Service Pack 3.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

5 comments:

Anonymous said...

Thank you!! Upgraded a client to GP 2010 R2 and have been surprised at how poorly SSRS performs. We have spent lots of time troubleshooting when in fact, it appears the SRS reports themselves are not correct.

Not cool...

Anonymous said...

We are on GP 2010 SP3 and I'm running into the problem of beginning balances not showing if there were no debits or credits within the year. Was this bug fixed with SP3? Or do we still need to run this script?

JW said...

I am having the same problem. Accounts with no activity and a beginning balance are not on the trial balance

Mariano Gomez said...

All,

All issues with this report have been resolved in the latest service packs. Please download and apply. If you continue to experience any issues, please contact Microsoft Support as I am not in a position to resolve the problem - if there's even one.

MG.-

Anonymous said...

i've posted this problem to Microsoft Connect. if anyone would like vote on it so it gets attention, it is id 785504.

we are on SP3. i'm not sure why we are running into this unless there is something having to do with SRS reports that our partner didn't do during the install of the service pack.