This is a modified Dynamics GP report (see download) I’ve provided to my clients for years that can be exported to a text file and imported into excel that includes the customer ID, name, and the aging columns. Through GP security, you can only have one modified report for each user and company if you’re running a shared modified reports dictionary for each workstation. What this means is if you already have an existing modified historical aged trial balance detail report you may have to provide a separate login or shortcut to this report to have access to both. Here’s a screenshot of the report in excel.
You have to add totals and grand total line, be sure to exclude the “Original Amount” column.
Payables:
Download report
Receivables:
Download report
After you download the package(s) from above by right-clicking and choose ‘save as’, you can import it in version 10, 2010, 2013 by going to Microsoft Dynamics GP>>tools>>customize>>customization maintenance and choose import. Before doing so, be sure to back up your modified reports to ensure nothing is overwritten.
If you need the summary trial balance export packages just create a comment below and I will email them to you.
Hello,
I need the summary trial balance export package. Could you please send that to me?
Thanks,
Jon Hunt
Please send me the summary trial balance export package
Please send me the summary trial balance export, and the payables reports if available.
Thanks
Hi There,
Great work! Thanks for that.
Please send me payables and summary trial balance reports.
Thanks,
Steve
THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU!
Can you send me the PM version as well. Thank you. also send to my co worker rworth@gisy.com
Thank you again!!!
Can you send me the the summary as well as the summary and detailed versions for payables? Thank you so much!!
Hi,
Can you please send me the payables historical aged trial balance detail package?
Thank you!
Michele
I am having trouble with this report – cannot get it formatted into excel – any ideas ?
thanks
Several things can go wrong, try following these instructions
1. Give yourself security access to the report
2. On the report destination, be sure to mark file and choose ‘Tab – Delimited’ on the file format
3. Be sure you know where you’re saving it and the file extension is txt.
4. Open up excel, then choose file>>open
5. On the file types choose text, or in the file name you can choose *.txt and click the enter key to display the file types, then open the file
6. This brings you to the text import wizard, choose delimited and choose next
7. For the delimiters mark the tab field, choose next and finish
8. From there you sort out the things you don’t need, clean up and enter subtotals
Steve
Hi Steve,
It gave me an error when I imported: “Unable to open customizations dictionary”,would you know why I got that error?
Thanks,
Michele
please send the summary a/r trial balance package – thanks!!
Presuming your modified reports are shared, you have to get all users out of GP before importing it. That’s what causes that error.
Steve
Pingback: Doing the “Impossible” | Q Factor’s Blog
+1 on this timesaver! May I please have the Summary A/R as well? Thanks!!
Steve,
Can you plese send me the payables and summary trial balance export packages. Thank you vry much. These routines fill a big void in the organic GP reporting and analysis functionality.
Sincerely,
Scott Martin
This is awesome!!! Can you please send me the AP historical aged trial balance detail package?
Much thanks!!!
This works great, can you please forward a copy of the HATB summary report package.
Thanks
Michael
Totally Awesome!
Can you send me the detail AR and both AP detail and summary!
Thanks so much
This is wonderful!!! Can you please send me the AP historical aged trial balance detail package? Thank you!!!
May you send me AP-HATB Please?
Thank you in advance.
also I need summary AR-HATB as well if you can plz.
A great contribution to the community! Please send the HATB summary, AP historical aged trial balance detail, and AP historical aged trial balance summary.
I actually need the MC HATB detail and summary for RM. If you could send that, I would be most grateful.
Steve – This is fantastic. Thanks for sharing. Could you please send me the payables and summary trial balance? Thanks in advance!
Unfortunately, I don’ t have the multi-currency ones.
I really need the PM version of this badly. I hope you’re still watching this….
Hi Steve,
I have just found your site and these reports. I would appreciate you sending me a copy of the summary and both PM versions as well.
Thank you for developing these reports. I have been asked several times from one client why this is not available.
Kind Regards,
Geoff James
Hi Steve.
I would like the summary trial balance and accounts payable reports. The detail report worked great. I appreciate it.
Thanks.
Hello, the AR worked perfectly. May I have the PM and Trial Balance as well? Thanks!
Hey Steve
This is awesome! You da man! Can you send over the payables and the summary packages? Thanks!
Hi,
send the HATB summary, AP historical aged trial balance detail, and AP historical aged trial balance summary.
Thanks
Hi Steve
I would most appreciate receiving a copy of the AP historical aged trial balance detail.
Thank You!
Can you send me the summary tbal report, please
Hi Steve
This is a wonderful job. Can you please send a copy of the AP historical aged trial balance detail.
Thanks.
Hello, Could I get the Summary AR Historical Aged Trial Balance?
Thanks a ton!
Could someone please send me the PM HATB?
Thank you!
Hi Steve,
Thank you for your awesome work! Would you mind sending me the Summary AR Historical Aged Trial Balance? Thanks!
Hi Steve,
Please send me payables and summary trial balance reports.
Thank you so much.
Hi
Could you please send me the Payables report? Thanks.
Could you send the me the AP version and Summary TB-Thank you for your time and efforts!
Steve can you please send me the AP version? Thanks so much.
Can you please send me the AP versions (detailed and summary HATB) as well as the AR summary HATB?
I’ve been looking for this for a long time. I appreciate and thank you for your efforts.
Can you send me the AR Summary HATB for SRS?
Thank you
Hi, could yo preas send me PM AGED TB-OPTIONS-DETAILS and RM AGED TB – OPTIONS – DETAIL? Thanks.
I don’t suppose there is a multicurrency version of the same report?
Steve,
Please send me the payables and the summary trial balance export package.
Thank you for this great information.
Layne
Please send me the payables detail and the summary trial balance export packages for payables and receivables. Love the report. Thanks for sharing.
Could I please please please have the AR detailed and summary HATB??
Thank you!!!!!
Hi,
Can you please send a copy of the payables report and the summary report. This will save me the time to do the same all accountants want to send everything to Excel.
Kind Regards
Peter
I don’t have the AR Summary HATB for SRS.