Our Company has recently switched over from Peachtree & Quickbooks to GP. We are having difficulties running reports which easily extract to Excel. It appears that we can run an AR Aging, AP Aging, General Ledger, and Trial balance using the Reports function within the modules but they do not easily extract to Excel.
I was able to save the Trial balance to a tab deliminated file which I can open in Excel and it works well. All the other files need quite a bit of modification such as removing headings and space in between rows.
I've tried creating reports using SmartList but maybe my columns are incorrect as the balance never ties to the canned reports run from the Reports function.
As a lot of our analysis are performed using these reports in Excel it would be nice to easily generate these reports. Could anyone please advise or direct me somewhere I could find more information?
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 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.
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.
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.
Frank E. Hamelly, MCP, MCITP, MCT, MVP
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.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13