Microsoft Dynamics GP | Running an A/P Historical Aged Trial Balance

By: George Rios – Senior Microsoft Dynamics GP Consultant

A recurring inquiry we receive from our clients is how to run an accounts payable historical aged trial balance. We have put together these instructions that highlight the steps you should take if you run into a similar issue.

Go to Reports >> Purchasing >> Trial Balance

Select Historical Aged Trial Balance from the drop-down menu

Click on the New button at the bottom of the screen to create a new report option:

Give the new report option a name, in this case, I am calling it ‘New Report’.

Update the date through which you would like to run the aging report within the Print/ Age as of field.

Other areas of interest:

  • Unmark the ‘In Detail’ checkbox to view the summary report version
  • Verify the that GL Posting Date is selected for reporting purposes
  • Verify that the report excludes Fully Paid Documents, Zero Balances, No Activity, and Unapplied Credit Memos
  • If no restrictions are selected, you will be printing an aging report for all vendors
  • Verify the Report Destination, so you do not end up printing a bunch of pages you may not even need


Click the Print button within the Payables Trial Balance Report Options window.