AR Balances sourced measures and KPIs

This table shows the AR Balances 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
Invc Amt – Transaction The total invoice amount for the period in the transaction currency
Invc Amt – Division The total invoice amount for the period in the division currency
Pmt Amt – Transaction The payments made for the period in the transaction currency
Pmt Amt – Division The payments made for the period in the division currency
Sales Amt – Transaction The total sales amount for the period in the transaction currency
Sales Amt – Division The total sales amount for the period in the division currency
Outstanding Amt – Transaction The amount of outstanding invoices in the transaction currency
Outstanding Amt – Division The amount of outstanding invoices in the division currency
Overdue Invc Amt – Transaction The amount of past due invoices in the transaction currency
Overdue Invc Amt – Division The amount of past due invoices in the division currency
Stopped Amt – Transaction Total amount stopped in transaction currency for a customer when credit limit is exceeded
Stopped Amt – Division Total amount stopped in division currency for a customer when credit limit is exceeded
Open Order Amt – Transaction The amount of open orders in the transaction currency
Open Order Amt – Division The amount of open orders in the division currency
DSO Value The average time for payment of customer invoices in days of each payer for the period
Pmt Var 1 – Transaction The payment variance in reference field amount 15 for the period in the transaction currency
Pmt Var 1 – Division The payment variance in reference field amount 15 for the period in the division currency
Pmt Var 2 – Transaction The payment variance in reference field amount 16 for the period in the transaction currency
Pmt Var 2 – Division The payment variance in reference field amount 16 for the period in the division currency
Pmt Var 3 – Transaction The payment variance in reference field amount 18 for the period in the transaction currency
Pmt Var 3 – Division The payment variance in reference field amount 18 for the period in the division currency
Pmt Var 4 – Transaction The payment variance in reference field amount 19 for the period in the transaction currency
Pmt Var 4 – Division The payment variance in reference field amount 19 for the period in the division currency
Pmt Var 5 – Transaction The payment variance in reference field amount 20 for the period in the transaction currency
Pmt Var 5 – Division The payment variance in reference field amount 20 for the period in the division currency
No. of AR Balance Records

The total number of AR balance records

Aggregation: Avg, Sum