AR Operational Metrics sourced measures and KPIs

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

These measures can be analyzed by different time series. These time series are available:

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 Pmt	The number of days between the due date and the final payment date
Days Diff – Invc and Due	The number of days between the invoice date and the due date
Days Diff – Invc and Pmt	The number of days between the invoice date and the final payment 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 Invcs w/ Chgd Due Date	The number of customer invoices with changes to the due date Aggregations: Avg, Sum
No. of Invoices	The number of customer invoices Aggregation: Sum
No. of Payments	The number of payments made on an invoice
No. of Pmt Reminders	The number of payment reminders of an invoice
No. of Record Changes	The number of times that an invoice record was updated in M3
Payment Amt	The payment amount in the division currency
Payment Amt – For Curr	The payment amount in the foreign currency
Weighted Invc Amt – Due Date	The invoice amount in the division currency multiplied by the number of days between the invoice date and the due date
Weighted Pmt Amt – Due Date	The payment amount in the division currency multiplied by the number of days between the due date and the final payment date
Weighted Pmt Amt – Invc Date	The payment amount in the division currency multiplied by the number of days between the invoice date and the final payment date