AP Operational Metrics sourced measures and KPIs

This table shows the AP Operational Metrics measures that are sourced directly in Data Warehouse.

You can use different time series to analyze these measures. For the list of available time series measures, see Time.

Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:

Measure Description
Invoice Amt – Transaction The invoice amount in the transaction currency
Invoice Amt – Division The invoice amount in the division currency
Invoice Amt – Third Curr The invoice amount in third currency, used for comparison in the financial system
Payment Amt – Transaction The payment amount in the transaction currency
Payment Amt – Division The payment amount in the division currency
Payment Amt – Third Curr The payment amount in third currency, used for comparison in the financial system
Reversal Amt – Transaction The total reversal amount for both invoices and payments in the transaction currency
Reversal Amt – Division The total reversal amount for both invoices and payments in the division currency
Reversal Amt – Third Curr The total reversal amount for both invoices and payments in third currency, used for comparison in the financial system
No. of Invoices The number of supplier invoices

Aggregations: Avg, Sum

No. of Payments The number of payments made on an invoice

Aggregations: Avg, Sum

No. of Reversals The total number of reversal vouchers for both invoices and payments

Aggregations: Avg, Sum

No. of Credit Notes The number of credit notes

Aggregations: Avg, Sum

No. of Record Changes The number of times that an invoice record was updated in M3

Aggregations: Avg, Sum

No. of AP Employees The number of distinct employees that processed supplier invoices

Aggregation: Count Distinct

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
Days Diff – Invc and Acctg The number of days between the invoice 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 – Due and Acctg The number of days between the due date and the accounting date