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/

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...
February 2, 2013 at 10:55 AM
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?
April 4, 2013 at 7:20 PM
JW said…
I am having the same problem. Accounts with no activity and a beginning balance are not on the trial balance
April 14, 2013 at 9:16 PM
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.-
April 15, 2013 at 9:13 PM
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.
April 24, 2013 at 2:43 PM
Post a Comment

Popular posts from this blog

Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)

Image
I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps.  This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about: Power Apps trigger in Power Automate   Get Rows SQL action   Variables action Select action and Arrays Response action Power Apps Collections To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP
Read more

Why my transactions don't post through GL even when I have the flag selected?

Image
Are you tired of asking why is it that some transactions do post through GL and why some don't? Tired of changing the posting settings to no avail? This issue outta be one of the most confusing issues for users and consultants, new or seasoned alike. If you ever struggle with one issue in GP, please tell me it's this one, because even today, I cannot claim victory over this subject. So let's walk the walk together. What the theory says? According to Part 3, Chapter 13, page 87 of the Microsoft Dynamics GP's System Setup guide, " If you mark the Post Through General Ledger Files option, batches posted in other modules automatically will update the module in which the transactions originated and the appropriate posting accounts in General Ledger. Your transactions will post to General Ledger and not through General Ledger when posting transaction individually (without a batch). " Now lets break it down... It's important to really pay close attention to the t...
Read more

A .NET Framework error occurred during the execution of user-defined routine or aggregate "GetAssignedUsers"

Image
So, I found myself helping a client to troubleshoot a workflow issue. After configuring workflow a few weeks aback and running a few tests without any issues, we applied Microsoft Dynamics GP 2015 R2 January 2016 Hotfix. Now, when the client went to execute the workflow, he received the corresponding email indicating there was a purchase order to approve. He then proceeded to click the Approve hyperlink and the process continued as expected. After clicking the Approve button, the client receive the following error message: The server encountered an error processing the request. See server logs for more details The following shows the error as displayed on the client's screen. At this point, it is worth stating that the workflow ran to completion and the PO appeared completely approved and fine in Dynamics GP, so whatever was causing this error did not seem to interrupt the approval flow. As good troubleshooters, we went to the Event Viewer to check for addi...
Read more