AP - Balance and Ageing - Pay By Date

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

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.

This KPI includes the following metrics:

Metric Definition

The total of account payable according to the length of time an invoice has been outstanding since the pay by date

AP 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 payable outstanding by 30 days since the invoice date.

60 Days

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

90 Days

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

120+ Days

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

4 Periods

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

5 Periods

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

6 Periods

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

7 Periods

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

8 Periods

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

9 Periods

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

10 Periods

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

11 Periods

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

12+ Periods

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