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