Share via

Vendor aging report (VendAgingReport)

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The Vendor aging report displays the balances that are due to vendors, sorted by date interval or by aging period definition.

How to filter the data on this report

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.

Field

Description

Start date

Enter a date that is in the first period interval or aging period to include on the report.

Balance as of

Enter the date to view the vendor balances for.

Criteria

Select the type of date to base the report on.

  • Transaction date – The posting date of the transactions. For example, this might be an invoice date that is the basis for the calculation of the due date.

  • Due date – The due date of the transactions, based on the terms of payment.

  • Document date – A user-defined document date that is the basis for the calculation of the due date.

Aging period definition

Select an aging period definition. The Interval field is not used if you select an aging period definition.

Aging period definitions that have more than six aging periods (columns) cannot be used on the printed report.

Note

You can set up aging periods in the Aging period definitions form.

Print aging period description

Select Yes to include aging period descriptions at the top of each aging period column on the report. Select No to print the report without column headers.

Interval

Define the period to use by entering the number of the day or month units in each period. For example, you might enter 15 and select Day in the Day/Mth field to show aging information at intervals of 15 days on the report. Or, to show aging information by month, enter 1 in this field and select Month in the Day/Mth field.

Note

The information that you enter in this field is used only if you have not selected an aging period definition.

Day/Mth

Select the unit, either Day or Month, that is used to define the period in the Interval field.

Printing direction

Select whether to calculate balances and print the aging report for past or future periods, relative to the date that is selected in the Balance as on field. Select Backward to show information for past periods. Select Forward to show information for future periods.

Details

Select this check box to list the transactions that are included in the balances that are shown on the report.

Include amounts in transaction currency

Select this check box to include the amounts in transaction currency.

Negative balance

Select this check box to include negative balances.

Exclude zero balance accounts

Select this check box to exclude vendors who have a zero balance.

Payment positioning

Select this check box to include payments that have not been settled. These are displayed in the first column of the report.

Vendors

The information displayed in this section is determined by your selections when you create a query.

Current print destination

The information displayed in this section is determined by your selections when you set up your printing options.

How to work with reports

The following topics explain how to print a report and how to filter and sort the data on a report.

Details of this report

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.

Detail

Description

Name of report in the AOT

VendAgingReport

Location of report in the AOT

SSRS Reports\Reports\VendAgingReport

Menu item of the report

VendAgingBalance

Navigation to the report

Click Accounts payable > Reports > Status > Vendor aging.

Where the data in this report comes from

The data on this report comes from the following sources:

  • VendTable table

  • VendAgingReportTmp table

Note

To determine where the data in the temp table comes from, view the cross-references for the VendAgingReportDP.processReport class.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).

See also

Aging period definitions (form)