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 Apps - Application Monitoring with Azure Application Insights

Image
In this video, learn to enable Power Apps Application Monitoring with Azure Application Insights.  The following topics are covered in this video:  ( 0:00 ) - Intro  ( 0:36 ) - What is Azure Application Insights  ( 1:32 ) - The timesheet app  ( 2:12 ) - Creating an Application Insight for the timesheet application  ( 3:55 ) - Identify and copy the application instrumentation key  ( 4:09 ) - Enabling the timesheet application with the instrumentation key  ( 5:32 ) - Working with Application Insights  ( 8:06 ) - Outro For additional information on Azure Application Insights, please follow these resources: Microsoft Docs - What is Azure Application Insights? here Adam Marczak - Azure for Everyone: Azure Application Insights Tutorial, here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP
Read more

#MSDYNGP: Named Printers and Redirected Printers in RDP environments

Image
A lot of the guiding principles for deploying Named Printers in a Terminal Server or Citrix environment comes from two of my favorite articles, written by my good friend and fellow Microsoft Business Applications MVP, David Musgrave  (twitter: @winthropdc ). David happens to be the creator of Named Printers and probably understands the product better than anyone I know. You can read his articles here: Using Named Printers with Terminal Server Using Named Printers with Terminal Server Revisited These articles continue to be very relevant if you are in an environment where a Print (or Printer) server is the norm and published printers are standard. Print servers are used to interface printers with devices in a network, but mostly to standardize administrative policies, and balance the document load that printers can manage. Part of the standardization is to ensure printers are uniquely identified across the networks, regardless of whether you are accessing the network remotely or ph
Read more

Integration Manager 10 INI settings

Image
The Integration Manager parameter file, Microsoft.Dynamics.GP.IntegrationManager.ini , provides a few keys that allow the application to perform certain actions according to the values and the sections in which these parameters are initialize . Here is a list of keys for the initialization file per section within the file: IMBaseProvider section This section controls the overall behavior of the Integration Manager application. AutoUpgradeIntegrations= 0/1 Prompts IM to check whether to upgrade an integration or not. CommandTimeout=30 Time allotted to execute a particular IM operation. If the operation is not successful in the time alloted, the record integration will fail. HideMsgBox= False/True Hides IM registration window during the application launch. UseOptimizedFiltering= False/True Allows you to maintain the same sorting as the original source. One note that I would make is that the following switch was put in more for performance. If you notice that your data is not coming in th
Read more