Export the Dynamics GP 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. 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.

To download, right-click and “save link as”

 Download_Receivables

Download_Payables

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 modifed reports to ensure nothing is overwritten accidently.

If you need the summary trial balance export packages just create a comment below.

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

75 Responses to Export the Dynamics GP Receivables Historical Aged Trial Balance to Excel

  1. Eric says:

    Hi Steve,

    Thank you so much for putting this together and sharing your work with all of us! I know I can speak for everyone here, this has made life so much easier when dealing with these reports.

    Can you please send me the package for the customized payables detail report?

    Thanks again Steve!

  2. Mel says:

    Hi Steve,

    Can you please let me have the PM Summary and detail reports?

  3. Phil Justice says:

    Hello Steve,

    Could you please send me the Detail and Summary AR Historical Aged TB’s. I am having a little difficulty trying to download the detail from the site.

    Thank You

  4. Keith says:

    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.

    Thank you

  5. Robert says:

    Can you please provide me with the AP trail balance and Summary please?

    Thanks

  6. John says:

    Hi Steve,
    I know you posted this a few years ago but that AP HATB package file would save me some time.

    Great work, thank you!

  7. Lisa Sorensen says:

    Steve,

    Can I get a copy of the Payables and Summary TB export package as well. This is great to have. Thank you for being generous and sharing it.

  8. Steve says:

    Unfortunately I don’t have the multicurrency version.

  9. Alicia says:

    Hi Steve,

    Can I get a copy of the Historical AP TB Detail and Summary export package as well.

    Thanks sharing!!

  10. Albertha says:

    We’ve customized the MC Payables Historical Aged TB (Detailed). For some reason, after the customization, I’m unable to save to file as text, Comma- or Tab-delimited. Any ideas?

  11. Steve says:

    Try making sure all the fields in each column are the same width, or try going back to the original to see if you have an environment issue, I’m not sure otherwise.

  12. Julio says:

    Hi, I can’t download the RMHistoricalAgedTrialBalanceDetail.package Can you help me please.

  13. Lindsay says:

    Hi there,

    can you please send me the package for AR and AP?

    thank you,
    Lindsay

  14. Brenda says:

    Can I please get the package file for the AR and AP reports, it will not download
    thanks
    Brenda

  15. Travis says:

    Hello – Could you please send me the packages for summary trial balance? Thanks in advance. Good work!

  16. Carly Dartez says:

    Can you send me the summary trial balance export packages

    Many thanks!

  17. Mark Wiley says:

    Thanks Steve. I’d like the summary versions, if possible. Thanks for sharing.

  18. Nikki Toole-Hebert says:

    This looks great could you send me the AR and AP detail Trial Balance Reports.
    Thank you for this.

  19. Kerri Reinholtz says:

    This is great – can you send me the package for the Receivables Historical Aged Trial Balance Reports? I am having trouble downloading/saving it.

    Thank you!

  20. Kim Harold says:

    Steve,
    Can you send me the TB detail and summary report packages as well?

    Thanks! Kim

  21. D. Lawson says:

    Hi Steve,

    Can you please send the PM Historical aged Trial Balance Summary? When i went in and stripped the report myself and try to run it i get the “ILLEGAL SYNTAX” error. I did not add any new fields. Only removed fields and move fields between headers. Can those two actions create bad syntax?

    Thanks!
    David

  22. Steve says:

    Yes, deleting fields can sometimes do this if the report relies on them. I recommend reimporting the package then making the fields you don’t want invisible.

  23. Cale says:

    Hi Steve,

    Thanks for posting! Would you please send me the summary trial balance export packages for both? Much appreciated!

    Thanks!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>