AP Operational Metrics sourced measures and KPIs
This table shows the AP Operational Metrics measures that are sourced directly in Data Warehouse.
These measures can be analyzed by different time series. These time series are available:
- Month Ago
- Quarter Ago
- Quarter-To-date
- Trailing 12 Months
- Trailing 3 Months
- Year Ago
- Year-To-date
Most measures have Avg, Max, Min, and Sum aggregations. For cases where this does not apply, the available aggregations are indicated in this table:
Measure | Description |
---|---|
Days Diff – Due and Acctg | The number of days between the due date and the accounting date |
Days Diff – Due and Recon | The number of days between the due date and the internal reconciliation date |
Days Diff – Invc and Acctg | The number of days between the invoice date and the accounting date |
Days Diff – Invc and Due | The number of days between the invoice date and the due date |
Days Diff – Invc and Recon | The number of days between the invoice date and the internal reconciliation date |
Invoice Amt | The invoice amount in the division currency |
Invoice Amt – For Curr | The invoice amount in the foreign currency |
No. of AP Employees |
The number of distinct employees that processed supplier invoices Aggregation: Count Distinct |
No. of Credit Notes |
The number of credit notes Aggregations: Avg, Sum |
No. of Invoices |
The number of supplier invoices Aggregation: Sum |
No. of Payments | The number of payments made on an invoice |
No. of Record Changes | The number of times that an invoice record was updated in M3 |
No. of Reversals |
The number of reversal vouchers made on a supplier invoice Aggregations: Avg, Sum |
Payment Amt | The payment amount in the division currency |
Payment Amt – For Curr | The payment amount in the foreign currency |