BeyondERP.Newsletter
Menu

Setup step on the Vendor aging report page · Expense management

Age the amounts owed to employees

See how long reimbursements to employees have been waiting.

Business process
Manage time and attendance
Menu item
output:TrvVendAgingBalance
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that ages the balances owed to vendors, including the employees who are paid their expenses as vendors, by date interval or aging period definition.
What you do hereUse this report to see how long amounts owed to vendors have been outstanding, filtered by vendor account and group.
ExampleFor example, with Balance as of 30 June, criteria Due date and an aging period definition of Current, 30, 60 and 90 days, the report shows an employee's 640.00 USD expense balance in the 30-day column, waiting for the next payment run.
Vendor aging report page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage time and attendance
Menu pathExpense management › Inquiries and reports › Vendor aging report
Set up firstAging period definitions Microsoft Learn
Used next byVendor payment journal Microsoft Learn
Related pagesPosted transactions Microsoft Learn
In this process Check per diem payments · Track travel requisitions
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAt period end, or before a payment run, to see how long amounts owed to vendors, including employee expense balances, have been outstanding.
How oftenMonthly at period end, or before each payment run.
What the output showsVendor balances split into aging columns, with optional transaction details. Payments shown in the first column were not settled against invoices; a balance that looks too old often means open items that should be settled.

Source: Microsoft Learn

Setup steps on this page

Age the amounts owed to employees

See how long reimbursements to employees have been waiting.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Vendor aging report.
  2. Set Balance as of to the date to show vendor balances for, and choose the Criteria: transaction date, due date or document date.
  3. Choose an Aging period definition, or leave it empty and use Interval and Day/Mth to define the columns; definitions with more than six periods can't be printed.
  4. Turn on Details to list the transactions behind each balance, Exclude zero balance accounts to drop settled vendors, and Payment positioning to show unsettled payments in the first column.
  5. In Records to include, filter on vendor account or vendor group, for example employees set up as vendors, run the report, and reconcile the totals with the vendor balances.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Balance as ofThe date to show vendor balances for.Microsoft Learn
CriteriaThe type of date the report is based on: transaction date, due date or document date.Microsoft Learn
Aging periodThe aging period definition to use.Microsoft Learn
IntervalThe number of day or month units in each period when no aging period definition is used.Microsoft Learn
DetailsLists the transactions behind the balances.Microsoft Learn
Exclude zero balance accountsLeaves out vendors with a zero balance.Microsoft Learn
Payment positioningIncludes payments that aren't settled, shown in the first column.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report prints no linesRecords to include filters out everything, or the data isn't posted yet. Clear the filters, check the date range, and run it again. Microsoft Learn
The report runs but shows another company's data is missingReports read the current legal entity only. Change company and run the report again. Microsoft Learn

Test checklist

  1. Post an expense report for a test employee.
  2. Run the report with Balance as of today and criteria Due date.
  3. Check the employee's balance appears in the right aging column.
  4. Turn on Details and check the transaction behind the balance.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Age the amounts owed to employeesRun it before each payment run with criteria Due date and an aging period definition of six periods or fewer.Posted expense reports create amounts owed to the employee as a vendor, and the report ages them like any vendor balance.How quickly should employees be reimbursed?Using an aging period definition with more than six periods, which can't be printed.Test: Employee balances are aged

Feature management and licence

Licence or add-inIn this system Employee and Contractor enter their own expenses, and Expense administrator sets up the module and processes documents. The expense mobile app needs the Employee role, a company on the user account and a link to an employee with active employment. The expense administrator runs this report; no Feature management feature is needed.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report runs in the legal entity you are signed in to and reads that company's expense data. Microsoft Learn
Can it be undoneReversible: The report reads data and changes nothing.
If you change it laterAging period definitions with more than six aging periods can't be used on the printed report. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TrvVendAgingBalance Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:TrvVendAgingBalance
Data migrationLoad order: The report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted or entered expense data and prints it; nothing on it is loaded or migrated. Run it in each environment after the data is there.Microsoft Learn
Everyone

8Sources

To cite this step: EM-RPT-090, Age the amounts owed to employees. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/EM-RPT-090