Report page · Accounts payable
Vendor aging report
A report that shows the balances due to vendors, sorted by date interval or by aging period definition.
- Used by
- —
- Business process
- —
- Menu item
output:VendAgingBalance- Main table
- —
- Data entity
- —
- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | A report that shows the balances due to vendors, sorted by date interval or by aging period definition. |
|---|---|
| What you do here | Used to analyze vendor balances by aging period, filtered by balance date, criteria (transaction, due, or document date), and options such as details, negative balances, and unsettled payments. |
| Example | For example, to see aging in 15-day steps, enter 15 in the Interval field and select Day in the Day/Mth field. |
Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | Accounts payable › Inquiries and reports › Vendor aging report |
| Set up first | Aging period definitions Microsoft Learn ↗ |
| Used next by | — |
| Related pages | Vendor aging data storage Microsoft Learn ↗Vendor payments Microsoft Learn ↗ |
End user · Functional consultant
3How to do it
Microsoft's steps
—
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Balance as of | The date to show vendor balances for.Microsoft Learn ↗ | — | — |
| Criteria | Which date the aging is based on: transaction date, due date or document date.Microsoft Learn ↗ | — | — |
| Aging period definition | The set of aging periods to use; when chosen, Interval is ignored.Microsoft Learn ↗ | — | — |
| Interval | The length of each period in days or months, used when no aging period definition is chosen.Microsoft Learn ↗ | — | — |
| Printing direction | Backward shows past periods; Forward shows future periods.Microsoft Learn ↗ | — | — |
| Details | Lists the transactions behind each balance.Microsoft Learn ↗ | — | — |
| Exclude zero balance accounts | Leaves out vendors with a zero balance.Microsoft Learn ↗ | — | — |
| Payment positioning | Includes unsettled payments in the first column.Microsoft Learn ↗ | — | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | — |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | Aging period definitions with more than six periods can't be used on the printed report. Microsoft Learn ↗ |
Technical architect
6Technical
| Menu item | output:VendAgingBalance Checked in Dynamics 365 |
|---|---|
| Form | SysOperationTemplateForm Checked in Dynamics 365 |
| Table | — |
| Data entities | — |
| Who can open it | — |
| Actions on the page | — |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=output:VendAgingBalance |
|---|---|
| Integrate with | — |
| Table definition | — |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/accounts-payable/vendor-aging-report
- learn.microsoft.com/dynamics365/finance/accounts-payable/vendor-aging-report
- learn.microsoft.com/dynamics365/finance/accounts-payable/vendor-aging-data-store
- learn.microsoft.com/dynamics365/finance/accounts-payable/vendor-payments-workspace
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.