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

(0) Share

Report

Posted on by Kenny Chan

580

Hi all,

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?

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
KenChan on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
KenChan on at

Like (0)

Report

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.

Was this reply helpful? Yes No
KenChan on at

Like (0)

Report

Adam,

Things have been crazy and I have just now had time to start looking at how to generate excel friendly reports. I've gotten to the reporting tools set up screen. The screen says "Excel Reports: Not implemented". From my understanding it should read "Not Deployed". Is this because these reports did not come with our version of GP?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Is it saying Not Implemented under the System Level section? If so, I think that just applies to the Location for the report deployment. You should be able to setup a network share where these reports live and then set that path on the setup screen to the network share.

This location that you setup is where the physical files will be created when you click Deploy Reports.

Let me know if that helps!

Adam

Was this reply helpful? Yes No
HeatherD 425 on at

Like (0)

Report

Tee - Thanks for the step by step information and scripts - exactly what I needed today!

Heather

Was this reply helpful? Yes No