Vendor statistics (form)
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. |
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
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. |
Fields
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. |
See also
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).