AR - Accounts Receivable Days
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 |
|---|---|
|
AR Days |
The number of accounts receivable days at the snapshot date. |
|
Last Year AR Days |
The number of accounts receivable days at the snapshot date last yearat the same time last year. |
|
Change |
The difference in accounts receivable days between the current snapshot date and last yearat the same time last year.
|
|
% Change |
The difference in accounts receivable days between the current snapshot date and last yearat the same time last year, expressed as a percentage of Last Year AR Days.
|
|
Variance |
The difference between the target AR Days (if entered) and the current AR Days.
|
|
% Variance |
The difference between the target AR Days (if entered) and the current AR Days, expressed as a percentage of Target AR Days.
|
|
Balance Ex-Tax |
The receivable balance, exclusive of tax, at the snapshot date. |
|
Sales |
The total value of sales for the active days, up to the snapshot date. |
|
LY Balance Ex-Tax |
The receivable balance, exclusive of tax, last yearat the same time last year. |
|
LY Sales |
The total value of sales for the year last yearat the same time last year. |
|
Active Days |
The lesser of the total number of days in the year, or the total number of days from the earliest transaction. |
