Payables

Overview

These tables describe Payables metrics.

Financials - AP Aging

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices based on invoice open date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices based on schedule date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices based on invoice open date grouped by selected aging period. The grain for this is invoice payment schedule.
Aging Count - Schedule Date Basis	Shows the aging count for the open invoices based on schedule date grouped by selected aging period. The grain for this is invoice payment schedule.
Amount Due Next 30 Days	This metric is computed as follows: overdue amount + upcoming dues for 30 days for open invoices.
AP Balances. Activity Amount	Shows the activities amount of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time.
AP Balances. Closing Amount	Shows the closing balance (end of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Balances. Opening Amount	Shows the opening balance (beginning of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Turnover. AP Turnover	This metric is computed as follows : ((invoice amount - credit memo amount - debit memo amount )* 365) / (closing amount * number of days in a selected period). This metric will provide correct value only when used with common or pillar specific dimensions.
AP Turnover. Days Payables Outstanding	This metric is computed as follows : (closing amount * number of days in a selected period) / (invoice amount - credit memo amount - debit memo amount). This metric will provide correct value only when used with common or pillar specific dimensions.
Avg Invoice Days Current	This metric is computed as follows: total number of days before due date / current invoices count. This is based on schedule date.
Avg Invoice Days Outstanding	This metric is computed as follows: total number of days invoice outstanding / total outstanding invoices count. This is based on invoice date.
Avg Invoice Days overdue	This metric is computed as follows: total number of days invoice overdue / overdue invoices count. This is based on schedule date.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Amount to Total Outstanding %	This metric is computed as follows: (current amount / total outstanding amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (current invoices count / total outstanding invoices count) * 100.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date. The grain for this is invoice payment schedule.
Open Invoices Amount	Shows the total invoice amount for the invoices that are fully open and partially open.
overdue Amount	Shows the invoices amount which has crossed the schedule due date. The grain for this is invoice payment schedule.
overdue Amount to Total Outstanding %	This metric is computed as follows: (overdue amount / total outstanding amount) * 100.
overdue Count to Total Outstanding %	This metric is computed as follows: (overdue invoices count / total outstanding invoices count) * 100.
overdue Invoices Count	Shows the invoices count which has crossed the schedule due date. The grain for this is invoice payment schedule.
Total Outstanding Amount	Shows the outstanding invoice amount which includes current and overdue invoices.
Total Outstanding Invoices Count	Shows the count of outstanding invoices computed as follows: (current invoices count + overdue invoices count).
Future Activity Amount	Shows the total activity amount that is accounted in future periods. This amount is available for analysis only in the current snapshot.

Financials - AP Expenses

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Expense Distribution Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices based on invoice open date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices based on schedule date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices based on invoice open date grouped by selected aging period. The grain for this is invoice payment schedule.
Aging Count - Schedule Date Basis	Shows the aging count for the open invoices based on schedule date grouped by selected aging period. The grain for this is invoice payment schedule.
Amount Due Next 30 Days	This metric is computed as follows: overdue amount + upcoming dues for 30 days for open invoices.
AP Balances. Activity Amount	Shows the activities amount of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time.
AP Balances. Closing Amount	Shows the closing balance (end of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Balances. Opening Amount	Shows the opening balance (beginning of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Turnover. AP Turnover	This metric is computed as follows : ((invoice amount - credit memo amount - debit memo amount )* 365) / (closing amount * number of days in a selected period). This metric will provide correct value only when used with common or pillar specific dimensions.
AP Turnover. Days Payables Outstanding	This metric is computed as follows : (closing amount * number of days in a selected period) / (invoice amount - credit memo amount - debit memo amount). This metric will provide correct value only when used with common or pillar specific dimensions.
Avg Invoice Days Current	This metric is computed as follows: total number of days before due date / current invoices count. This is based on schedule date.
Avg Invoice Days Outstanding	This metric is computed as follows: total number of days invoice outstanding / total outstanding invoices count. This is based on invoice date.
Avg Invoice Days overdue	This metric is computed as follows: total number of days invoice overdue / overdue invoices count. This is based on schedule date.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Amount to Total Outstanding %	This metric is computed as follows: (current amount / total outstanding amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (current invoices count / total outstanding invoices count) * 100.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date. The grain for this is invoice payment schedule.
Open Invoices Amount	Shows the total invoice amount for the invoices that are fully open and partially open.
overdue Amount	Shows the invoices amount which has crossed the schedule due date. The grain for this is invoice payment schedule.
overdue Amount to Total Outstanding %	This metric is computed as follows: (overdue amount / total outstanding amount) * 100.
overdue Count to Total Outstanding %	This metric is computed as follows: (overdue invoices count / total outstanding invoices count) * 100.
overdue Invoices Count	Shows the invoices count which has crossed the schedule due date. The grain for this is invoice payment schedule.
Total Outstanding Amount	Shows the outstanding invoice amount which includes current and overdue invoices.
Total Outstanding Invoices Count	Shows the count of outstanding invoices computed as follows: (current invoices count + overdue invoices count).
Future Activity Amount	Shows the total activity amount that is accounted in future periods. This amount is available for analysis only in the current snapshot.

Financials - AP Holds

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Average Days on Hold	This metric is computed as follows: (sum (release date - hold date) / total number of holds applied on invoice headers and lines considering active and release holds). The active holds are without release details and use the system date if the release date is not available.
Header Holds Count	Shows the header hold count which has header level hold and considers all invoice types. This metric considers only active holds which are without release details.
Historic Holds Count	This metric can be used to analyze historic holds trend for past periods with a limit of 24 Months from the current date.
Invoice Header on Hold Release Amount	Shows the invoice amount and considers all invoice types that have header level hold. This metric considers active holds that are released.
Invoice Headers on Hold Amount	Shows the invoice amount and considers all invoice types that have header level hold. This metric considers only active holds that are without release details.
Invoice Headers on Hold Count	Shows the invoice header count which has header level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Amount	Shows the invoice line amount which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Count	Shows the invoice line count which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Release Amount	Shows the invoice line amount which had line level hold and considers all invoice types. This metric considers active holds that are released.
Invoices on Hold Amount	Shows the invoice amount and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are without release details.
Invoices on Hold Count	Shows the invoice count and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are without release details.
Invoices on Hold Release Amount	Shows the invoice amount and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are released.
Line Holds Count	Shows the line hold count which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Total Holds Count	Shows the total number of holds applied on invoice headers and lines. This metric considers only active holds which are without release details.

Financials - AP Invoices

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Avg Credit Memos Amount	This metric is computed as follows: credit memos amount / credit memos count.
Avg Debit Memos Amount	This metric is computed as follows: debit memos amount / debit memos count.
Avg Invoices Amount	This metric is computed as follows: invoices amount / invoices count.
Credit Memos Amount	Shows the invoice amount for the credit memo invoice type.
Credit Memos Count	Shows the invoices count for credit memo invoice type.
Credit Memos to Invoices Amount %	This metric is computed as follows: (credit memos amount / invoices amount) * 100.
Debit Memos Amount	Shows the invoice amount for the debit memo invoice type.
Debit Memos Count	Shows the invoices count for debit memo invoice type.
Discount Offered %	This metric is computed as follows: (discount offered amount / total transaction amount) * 100.
Discount Offered Amount	Shows the discount offered amount for all transactions.
Invoice Creation to Approval Cycle Time	Shows the time elapsed between Invoice Creation Date and Invoice Final Approval Date.
Invoice Creation to Issue Time	Shows the time elapsed between Invoice Date and Invoice Creation Date.
Invoices Amount	Shows the invoice amount excluding the credit memo and debit memo invoice type.
Invoices Count	Shows the invoices count excluding the credit memo and debit memo invoice type.
Total Transaction Amount	Shows the sum of invoice amount, debit memos amount and credit memos amount.
Total Transaction Count	Shows the sum of invoice count, debit memos count and credit memos count.

Financials - AP Liabilities

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Liability Balance Amount	This metric shows balance of AP liability account as of the selected time.
Liability Distribution Amount	Shows the liability distribution amount.

Financials - AP Payments

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Payment Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted payments are supported.

Metric	Metric Definition
% Electronic Payment Amount	This metric is computed as follows: (electronic payment amount / payments amount) * 100.
% Interest Penalties Paid	This metric is computed as follows: (interest penalties paid / payment amount) * 100.
Avg Payments Amount	This metric is computed as follows: (payments amount / payments count) * 100. And grain is payments or check number.
Avg Supplier Payment Days	This metric is computed as follows: Sum of installment level Payment Days / Number of Installments that are paid.
Discount Lost %	This metric is computed as follows: (discount lost amount / total transaction amount) * 100. This metric is supported only in Document Currency, and will provide correct value only when used with common or pillar specific dimensions.
Discount Lost Amount	Shows the discount amount lost for the invoice payments. This metric is supported only in Document Currency.
Discount Remaining Amount	This metric is computed as follows: discount offered amount - discount taken amount - discount lost amount. This metric is supported only in Document Currency, and will provide correct value only when used with common or pillar specific dimensions.
Discount Taken %	This metric is computed as follows: (discount taken amount / total transaction amount) * 100. This metric will provide correct value only when used with common or pillar specific dimensions.
Discount Taken Amount	Shows the discount amount taken for the invoice payments.
Discount Taken Exchange Loss(Gain) Amount	Shows the discount taken exchange loss or gain amount for the invoices and grain is payments or check number.
Electronic Payment Amount	Shows the paid invoice amount using electronic payment method.
Interest Penalties Paid	Shows the payment amount for invoices with the interest invoice type.
On Time Payment Performance %	This metric is computed as follows: (on time payments count / total payments count) * 100.
On Time Payments Amount	Shows the amount of payment transactions where the payment date is lesser than or equal to the scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
On Time Payments Count	Shows the count of payment transactions where payment date is lesser than or equal to scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
overdue Payments Amount	Shows the amount of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
overdue Payments Count	Shows the count of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
Payment Distribution Amount	Shows the payment distribution amount for AP payments.
Payment Exchange Loss(Gain) Amount	Shows the payment exchange loss or gain amount for the invoices and grain is payments or check number.
Payments Amount	Shows the total payments amount for the invoices and grain is payments or check number.
Payments Document Count	Shows the payments document count and grain is payments or check number.
Total Paid Installments Count	This metric is computed as follows: overdue payments count + on time payments count.
Total Payment Days	Shows the total payment days for fully paid invoices and considers all invoice types. payment days is computed as follows: payment date - invoice date.
Weighted Avg Supplier Payment Days	This metric is computed as follows: Sum of installment level Payment Days*Payment Amount / Total Payment Amount.