AR Aging, AP Aging, General Ledger, Trial Balance exports to Excel

Hi Kenny,

Have you looked at installing the SQL Server Reporting Services Report Pack? At first glance it looks like the reports you want are included and the SSRS reports export to Excel nicely and can also be more easily modified if you need to simplify the export further.

If those don't work for you I would suggest writing one that does OR write the report query and link to it directly within Excel.

Let me know if this helps at all or if I can provide any other information.

Thanks,

Adam

Thanks for your reply Adam. Sorry since I am new to GP, I don't have a great understanding of the terminology being used. I am assuming that the SSRS reports are part of the SQL Service Reporting Services Report Pack. How would I know if we have that report pack or not?

We do have a reporting function which generates reports but they do not neatly export to excel. I wish they did and I wouldn't have this problem.

Hi,

If you look in GP under Dynamics GP >> Tools >> Setup >> System >> Reporting Tools Setup you should be able to view the report deployment status and go through the deployment process if you do not already have them deployed.

GP has both SSRS (SQL Server Reporting Services) reports that it ships with now and also a variety of Excel reports. The SSRS reports are deployed to your reporting server which must be configured and working before the deployment will work. The Excel reports deploy to the file system and you end up with a linked worksheet that users can open and refresh at their convenience. There are pros and cons to both of these but as far as out of the box solutions I would look there to see if they meet your needs.

I would also look at the options in Smartlists as they export directly to Excel. It is just a matter of wheter or not they meet the need you have.

Your difficulty in running reports to Excel is not uncommon. With GP there are quite a few ways to retreive the data you want so it defintely is worth the time for the planning step to define what you want and in what format and then work on your own or with a partner to get it setup that way. This contrasts with QB/Peachtree a bit in that I have found users don't need to do as much planning for their reporting however for the long term, going through a planning phase with GP to lay out what you want will have more beneifts because of the additional flexibility it provides.

Let me know if I can help you with anything else.

Thanks,

Adam

Adam is correct - you need to have the SSRS reports deployed.  These easily export to Excel.  SmartList is very useful for running data queries but not so much for replicating the standard GP reports.

Hi Kenny,

Until you get SSRS set up, I have done some of those reports as SmartListt templates. If you have SmartList Builder, send me an e-mail (do not just respond to the forum, please) and I will send them to you. I've also modified the AR trial balance so that it's export friendly. I see you already have a gl trial balance. What I have along those lines is a current year Summary Trial balance - is't a modified Report Writer report. It's the one the auditors usually ask my clients for, so that's why it's just the summary.

Please e-mail me if you would like the files.

Kind regards

Leslie

Thank you everyone for your responses. I am going to try to run these reports which you have mentioned and will get back to you with the results.