AR - Balance and Ageing - Due Date
This KPI provides the following default drill paths:
-
customer
-
territory class
-
sales rep
The metricA measure used to assess performance in a key area of a business. rank values displayed in the KPI History and KPI Definition screens is the aggregated value of the first item for the first drill path only. Additionally, displayed rank-based metric values in these screens are not applicable.
To viewA set of data connected to a cube, deliberately laid out to communicate business information. the actual values for each KPI drill path, click History, select a snapshot date, and click Drill Down.
The displayed value of each metric is an aggregation of the data, up to the viewed levelIn a hierarchy, a level indicates a group of common or related members. For example, in a Time level, members may include Year, Month, Day or Fiscal Year, Calendar Year, etc. of the selected drill path, as of the As At snapshot date.
This KPI includes the following metrics:
| Metric | Definition |
|---|---|
|
The total of account receivables according to the length of time an invoice has been outstanding since the invoice due date |
|
|
AR Balance |
The accounts receivable balance at the snapshot date. |
|
Future |
Value of all future accounts receivables. |
|
Current |
Value of current accounts receivables. |
|
30 Days |
Value of accounts receivables outstanding since the due date by 30 days. |
|
60 Days |
Value of accounts receivables outstanding since the due date by 60 days. |
|
90 Days |
Value of accounts receivables outstanding since the due date by 90 days. |
|
120+ Days |
Value of accounts receivables outstanding since the due date by 120 or more days. |
|
4 Periods |
Value of accounts receivables outstanding since the due date by 4 periods. |
|
5 Periods |
Value of accounts receivables outstanding since the due date by 5 periods. |
|
6 Periods |
Value of accounts receivables outstanding since the due date by 6 periods. |
|
7 Periods |
Value of accounts receivables outstanding since the due date by 7 periods. |
|
8 Periods |
Value of accounts receivables outstanding since the due date by 8 periods. |
|
9 Periods |
Value of accounts receivables outstanding since the invoice date by 9 periods. |
|
10 Periods |
Value of accounts receivables outstanding since the invoice date by 10 periods. |
|
11 Periods |
Value of accounts receivables outstanding since the invoice date by 11 periods. |
|
12+ Periods |
Value of accounts receivables outstanding since the invoice date by 12 or more periods. |