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. 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