AR Balances calculated measures and KPIs

This table shows the AR Balances measures that are calculated and defined as saved expressions. The saved expressions use the Accounting Period Date and Sum aggregation.

Measure Description
Days Receivable Outstanding amount divided by sales amount multiplied by the number of calendar days per accounting period
Receivable Turnover Sales amount divided by the outstanding amount
Overdue Amt Pct Overdue invoice amount divided by the outstanding amount
Stopped Amt Pct Stopped amount divided by the outstanding amount
Outstanding Undisputed Outstanding amount minus the sum of overdue invoice amount and stopped amount
Outstanding Undisputed Pct Outstanding undisputed divided by the outstanding amount
Credit Limit 1 Util Pct The overdue invoice amount in the transaction currency divided by the payer's credit limit 1 amount
Credit Limit 2 Util Pct The outstanding amount in the transaction currency divided by the payer's credit limit 2 amount
Credit Limit 3 Util Pct The sum of outstanding and open order amounts in the transaction currency divided by the payer's credit limit 3 amount