Payables measures

Measure	Measure source	Calculation
Days To Pay Invoice	PayablesInvoicePayment	Check Date - Invoice Date
DiscountAmount Currency Amount	PayablesInvoicePayment
DiscountAmount Applied	PayablesInvoicePayment	Discount Amount when When Status = Historical AND Discount Amount <> 0 AND Discount Lost <> TRUE
DiscountAmount Lost	PayablesInvoicePayment	Discount Amount when When Status = Historical AND Discount Amount <> 0 AND Discount Lost = TRUE
Discount Elig Payments Count	PayablesInvoicePayment	When Status = Historical AND Discount Amount <> 0
Discount Lost Count	PayablesInvoicePayment	When Status = Historical AND Discount Amount = 0 AND Discount Lost <> TRUE
Discounted Payments Count	PayablesInvoicePayment	When Status = Historical AND Discount Amount <> 0 AND Discount Lost <> TRUE
Eligible Discount Amount	PayablesInvoicePayment	Payables Invoice Base Discount Amount1 When Status = Historical
Invoiced Electronically Count	PayablesInvoicePayment	Payables Invoice Invoice Source = EDI
Open Invoice Amount	PayablesInvoicePayment	Transaction Net Payment when Status <> TRUE
Open Invoice Count	PayablesInvoicePayment	When Status <> TRUE
Paid Amount	PayablesInvoicePayment	Payment Amount
Paid Electronically Count	PayablesInvoicePayment	Bank Transaction Code Payment Output Option = Electronic File
Paid In Full Count	PayablesInvoicePayment	Status = Historical AND Payables Invoice Paid Invoice = TRUE
Paid On Time Count	PayablesInvoicePayment	Status = Historical AND Check Date <= Due Date
Paid Within Terms	PayablesInvoicePayment	Status = Historical AND Check Date <= Discount Date
Invoice Amount	PayablesInvoicePayment
Invoice Count	PayablesInvoicePayment	PayablesInvoicePayment record count = PayblesInvoice count
Received Discount Count	PayablesInvoicePayment	Status = Historical AND Discount Lost <> 'Y' AND Payables Invoice Base Discount Amount1 <> 0
Rush Payment Amount	PayablesInvoicePayment	Transaction Net Payment when Pay Immediately = TRUE
Rush Payment Count	PayablesInvoicePayment	Pay Immediately = TRUE
Void Payment Amount	PayablesInvoicePayment	Currency Amount when ‘Is Void Cash’ = true
Void Payment Count	PayablesInvoicePayment	1 when ‘Is Void Cash’ = true
Distinct Operators	Calculated measure	Distinct count of operators
Average Days to Pay	Calculated measure	DaysToPayInvoice / PaymentsProcessedCount
Average Payments per Operator	Calculated measure	PaymentCount / Distinct Operators
Pct Payments with Errors	Calculated measure	VoidPaymentCount / PaymentCount
Pct Discount Amount Lost	Calculated measure	DiscountAmountLost / EligibleDiscountAmount
Pct Discount Amount Taken	Calculated measure	DiscountAmountApplied / EligibleDiscountAmount
Pct Discounts Lost	Calculated measure	DiscountLostCount / DiscountEligPaymentsCount
Pct Discounts Taken	Calculated measure	DiscountedPaymentsCount / DiscountEligPaymentsCount
Pct Invoiced Electronically	Calculated measure	InvoicedElectronicallyCount / PaymentCount
Pct Paid Electronically	Calculated measure	PaidElectronicallyCount / PaymentCount
Pct Paid on Time	Calculated measure	PaidOnTimeCount / PaymentCount
Pct Paid within Terms	Calculated measure	PaidWithinTerms / PaymentCount
Pct Paid in Full	Calculated measure	PaidInFullCount / PaymentCount
Pct Received Discount	Calculated measure	ReceivedDiscountCount / PaymentCount
Pct Rush Payments	Calculated measure	RushPaymentCount / PaymentCount
Paid Late	Calculated measure	1 when invoice status is < 2 and Payment Date > Due Date
Paid Partial Invoices	Calculated measure	Invoice Count - PaidInFullCount

‘Is Void Cash’ is true when:

• a Cash Ledger Payables Payment exists
• and a Cash Ledger Transaction exists
• and Cash Ledger Transaction Status = Voided

Or when:

• Cash Ledger Transaction does not exist
• and Cash Ledger Payables Payment exists
• and Cash Ledger Payables Payment ‘Summarized Payment is Voided’ = true
• and Bank Transaction Code Transaction Type = Cash Payment
• and Payables Invoice Payment Void Sequence is specified.