AP - Balance and Ageing - Invoice Date

KPIQuantifiable measurements, agreed to beforehand, that reflect the critical success factors (of the company, department, project, individual). 120

This KPI provides the following default drill paths:

  • supplier

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.

The following KPIs are available:

Metric Definition

The total of account payables according to the length of time an invoice has been outstanding since the invoice date.

AR Balance

The accounts payable balance at the snapshot date.

Future

Value of all future accounts payables.

Current

Value of current accounts payables.

30 Days

Value of accounts payables outstanding by 30 days since the invoice date.

60 Days

Value of accounts payables outstanding since the invoice date by 60 days.

90 Days

Value of accounts payables outstanding since the invoice date by 90 days.

120+ Days

Value of accounts payables outstanding since the invoice date by 120 or more days.

4 Periods

Value of accounts payables outstanding since the invoice date by 4 periods.

5 Periods

Value of accounts payables outstanding since the invoice date by 5 periods.

6 Periods

Value of accounts payables outstanding since the invoice date by 6 periods.

7 Periods

Value of accounts payables outstanding since the invoice date by 7 periods.

8 Periods

Value of accounts payables outstanding since the invoice date by 8 periods.

9 Periods

Value of accounts payables outstanding since the invoice date by 9 periods.

10 Periods

Value of accounts payables outstanding since the invoice date by 10 periods.

11 Periods

Value of accounts payables outstanding since the invoice date by 11 periods.

12+ Periods

Value of accounts receivables outstanding since the invoice date by 12 or more periods.