Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel

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.

This entry was posted in Dynamics GP. Bookmark the permalink.

125 Responses to Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel

  1. Jon Hunt says:

    Hello,

    I need the summary trial balance export package. Could you please send that to me?

    Thanks,
    Jon Hunt

  2. Sandy says:

    Please send me the summary trial balance export package

  3. Howard says:

    Please send me the summary trial balance export, and the payables reports if available.
    Thanks

  4. Steve says:

    Hi There,

    Great work! Thanks for that.

    Please send me payables and summary trial balance reports.

    Thanks,
    Steve

  5. Jim L. says:

    THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU!

  6. Tony Pearson says:

    Can you send me the PM version as well. Thank you. also send to my co worker rworth@gisy.com

    Thank you again!!!

  7. David says:

    Can you send me the the summary as well as the summary and detailed versions for payables? Thank you so much!!

  8. Michele says:

    Hi,
    Can you please send me the payables historical aged trial balance detail package?
    Thank you!
    Michele

  9. Robin says:

    I am having trouble with this report – cannot get it formatted into excel – any ideas ?
    thanks

  10. Steve says:

    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

  11. Michele says:

    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

  12. please send the summary a/r trial balance package – thanks!!

  13. Steve says:

    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

  14. Pingback: Doing the “Impossible” | Q Factor’s Blog

  15. Marc Soliman says:

    +1 on this timesaver! May I please have the Summary A/R as well? Thanks!!

  16. Scott Martin says:

    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

  17. Donald Wisch says:

    This is awesome!!! Can you please send me the AP historical aged trial balance detail package?

    Much thanks!!!

  18. Michael Smith says:

    This works great, can you please forward a copy of the HATB summary report package.
    Thanks
    Michael

  19. Mary says:

    Totally Awesome!

    Can you send me the detail AR and both AP detail and summary!

    Thanks so much

  20. Kate Morrow says:

    This is wonderful!!! Can you please send me the AP historical aged trial balance detail package? Thank you!!!

  21. Yassir says:

    May you send me AP-HATB Please?

    Thank you in advance.

  22. Yassir says:

    also I need summary AR-HATB as well if you can plz.

  23. Jay says:

    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.

  24. Travis Cogle says:

    Steve – This is fantastic. Thanks for sharing. Could you please send me the payables and summary trial balance? Thanks in advance!

  25. Steve says:

    Unfortunately, I don’ t have the multi-currency ones.

  26. Steve Zimmerman says:

    I really need the PM version of this badly. I hope you’re still watching this….

  27. Geoff James says:

    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

  28. Chris Barron says:

    Hi Steve.

    I would like the summary trial balance and accounts payable reports. The detail report worked great. I appreciate it.

    Thanks.

  29. Mackenzie Platten says:

    Hello, the AR worked perfectly. May I have the PM and Trial Balance as well? Thanks!

  30. Christian Sureta says:

    Hey Steve

    This is awesome! You da man! Can you send over the payables and the summary packages? Thanks!

  31. Yaritza Andino says:

    Hi,

    send the HATB summary, AP historical aged trial balance detail, and AP historical aged trial balance summary.

    Thanks

  32. Tom Ingram says:

    Hi Steve

    I would most appreciate receiving a copy of the AP historical aged trial balance detail.

    Thank You!

  33. Chris Lawton says:

    Can you send me the summary tbal report, please

  34. Sandeep says:

    Hi Steve

    This is a wonderful job. Can you please send a copy of the AP historical aged trial balance detail.

    Thanks.

  35. Michael says:

    Hello, Could I get the Summary AR Historical Aged Trial Balance?

    Thanks a ton!

  36. Dan Tauro says:

    Could someone please send me the PM HATB?

    Thank you!

  37. Michael Jones says:

    Hi Steve,

    Thank you for your awesome work! Would you mind sending me the Summary AR Historical Aged Trial Balance? Thanks!

  38. Noraini says:

    Hi Steve,

    Please send me payables and summary trial balance reports.

    Thank you so much.

  39. A Evans says:

    Hi

    Could you please send me the Payables report? Thanks.

  40. M Bloom says:

    Could you send the me the AP version and Summary TB-Thank you for your time and efforts!

  41. Russ Worth says:

    Steve can you please send me the AP version? Thanks so much.

  42. echan says:

    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.

  43. Kayla Worley says:

    Can you send me the AR Summary HATB for SRS?

    Thank you

  44. Juan Martin says:

    Hi, could yo preas send me PM AGED TB-OPTIONS-DETAILS and RM AGED TB – OPTIONS – DETAIL? Thanks.

  45. ian says:

    I don’t suppose there is a multicurrency version of the same report?

  46. Layne Duncan says:

    Steve,

    Please send me the payables and the summary trial balance export package.

    Thank you for this great information.

    Layne

  47. J Olson says:

    Please send me the payables detail and the summary trial balance export packages for payables and receivables. Love the report. Thanks for sharing.

  48. Jen Grimshaw says:

    Could I please please please have the AR detailed and summary HATB??
    Thank you!!!!!

  49. Peter Smith says:

    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

  50. Steve says:

    I don’t have the AR Summary HATB for SRS.

Leave a Reply

Your email address will not be published. Required fields are marked *