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.
After you download the package (above) by right-clicking and choose ‘save as’, you can import it in version 10 or 11 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 payables or the summary trial balance export package just send me an email and it’s yours.