# How to run the Vendor aging report in Dynamics 365 Finance

In Dynamics 365 Finance, run the Vendor aging report as at your chosen date. Check the total ties to your accounts payable balance and look at items over 30 days.

An aged payables report lists what you owe each supplier, grouped by how overdue each bill is.

## Before you start

- Accounts payable role

## The Dynamics 365 Finance way

Where to find it: Accounts payable > Reports > Vendor aging

1. Run the Vendor aging report.
2. Pick Transaction date, Due date or Document date.
3. Set intervals or an aging period definition.
4. Set the Balance as of date.
5. Set the Start date and the Balance as of date.
6. Choose Printing direction: Backward for past periods or Forward for future periods.
7. Tick Details to list the transactions in each balance, and Exclude zero balance accounts to shorten the report.
8. Tick Payment positioning to show unsettled payments in the first column.

## Limits in Dynamics 365 Finance

- Aging period definitions over six columns cannot be used on the printed report.
- Interval works only when no aging period definition is chosen.

## Good to know in Dynamics 365 Finance

- Negative balances and amounts in transaction currency are optional ticks.
- The Vendor open transactions report lists invoice number, voucher number, amounts and payment due date and is used to agree the vendor book to the ledger.
- Aging period definitions are kept on their own page and can be reused across reports.

## Common mistakes

- Picking a different aging date from last month and getting a total that does not compare.
- Using an aging period definition with more than six columns on the printed report.

## Common questions

### Where is the Vendor aging report?

Go to Accounts payable > Reports > Vendor aging. Set the Balance as of date and the intervals or an aging period definition.

### What can the report age by?

Pick Transaction date, Due date or Document date.

### Is there a column limit?

Aging period definitions over six columns cannot be used on the printed report.

### Does Pulsify run this report?

No. Run it in your accounting system.

## Sources

- https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/vendor-aging-report
- https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/vendor-invoices-overview

Source: https://www.pulsify.tech/how-to/run-an-aged-payables-report-in-dynamics-365-finance/ (last checked 2026-10-19)