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 |