Vendor statistics (form) [AX 2012]

Updated: November 6, 2012

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

Click Accounts payable > Common > Vendors > All vendors. On the Action Pane, on the General tab, click Period statistics.

Use this form to gain an overview of a vendor's invoices, payments, used discount, unused discount, and average number of days for payment. This information is shown for the five predefined periods that are described in the following table.

Line

Description

1

The current month.

2

The previous month. For example, if the current month is October, statistics for September are shown.

3

Statistics for the whole year, up to and including today's date.

4

Statistics for the previous year.

5

Statistics up to and including the current date.

The following tables provide descriptions for the controls in this form.

Tab

Description

Period statistics

View statistics about the vendor's invoices, payments, used discount, unused discount, and average number of days for payment.

Other

View information about the last invoice, last payment, highest balance, and average invoice amount.

Field

Description

Start date

The start date for the current statistical period.

End date

The end date for the current statistical period.

Invoice

The invoice quantity.

Total

The total invoice amount in the accounting currency.

Payments

The number of payments.

Total

The total payment amount.

Used discount

The total cash discount amount that was used.

Unused discount

The total cash discount amount that was not used.

Days, payments

The average number of days for payment.

Last invoice

The date of the last invoice.

Invoice number

The identifier of the last invoice.

Invoice amount

The amount of the last invoice. This includes any sales tax.

Last payment

The date of the last payment.

Check number

The check number of the last payment.

Payment amount

The amount of the last payment.

Created

The date when the vendor account was created.

Modified date and time

The date and time when the vendor account information was last modified.

Highest balance

The vendor's highest balance.

Average invoice

The average amount of invoices for the vendor.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: