Payables Management measures

Analyze by Dates:
  • Check Date
  • Invoice Date
  • Void Date
Measure Source and/or calculation
Bank Check Amount PayablesInvoicePayment.BankCheckAmount
Base Withholding Amount PayablesInvoicePayment.BaseWithholdingAmount
Days To Pay Invoice Days between InvoiceDate and CheckDate
Days to Process Invoice Days between CreateDate and CheckDate
Discount Amount Applied 
IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0 AND DiscountLost = false THEN DiscountAmountCurrencyAmount
Discount Amount Lost 
IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true THEN DiscountAmountCurrencyAmount
Discount Elig Payments Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0
Discount Lost Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true
Discounted Payments Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0 AND DiscountLost = false
Income Withholding Percent PayablesInvoicePayment.IncomeWithholdingPercent
Net Payment Currency Amount PayablesInvoicePayment.NetPaymentAmountCurrencyAmount
Net Payment Functional Amount PayablesInvoicePayment.NetPaymentAmountFunctionalAmountEnteredCurrencyAmount
Paid Amount 
IF PaymentStatus = Historical AND VoidSequence = 0 THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
Paid Electronically Count 
Count IF PaymentOutputOption = Electronic File
Paid In Full Count 
Count IF PaymentStatus = Historical AND PaidInvoice = true
Paid Invoice Count 
COUNT IF IsInvoicePaid = true
Paid Late Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate > DueDate AND DueDate <> NULL
Paid On Time Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate <= DueDate AND DueDate <> NULL
Paid Partial Count 
Count IF IsSplitPayment = true AND PaymentStatus = Historical OR SeparatePayment = true
Paid Within Terms 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate <= DiscountDate AND DiscountDate <> NULL
Payables Invoice Amount PayablesInvoicePayment.PayablesInvoiceInvoiceAmountCurrencyAmount
Payables Invoice Payment Count Count of each payment record
Payables Payment Discount Currency Amount DiscountAmount.CurrencyAmount
Payables Payment Discount Functional Amount DiscountAmount.FunctionalAmount.EnteredCurrencyAmount
Payables Payment Invoiced Electronically Count Count if InvoiceSource = EDI
Payment Amount Currency Amount PayableInvoicePayment.PaymentAmountCurrencyAmount
Payment Amount Functional Amount PayablesInvoicePayment.PaymentAmountFunctionalAmountEnteredCurrencyAmount
Payment Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0
Received Discount Count 
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = false AND PayablesInvoiceDiscountAmount1 <> 0
Released for Payment Count 
Count IF PaymentStatus = Released
Rush Payment Amount 
IF PayImmediately = true THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
Rush Payment Count 
Count IF PayImmediately = true
Secondary Withholding Transaction Amount 1 PayablesInvoicePayment.SecondaryWithholdingBaseAmount1
Secondary Withholding Transaction Amount 2 PayablesInvoicePayment.SecondaryWithholdingBaseAmount2
Secondary Withholding Transaction Amount 3 PayablesInvoicePayment.SecondaryWithholdingBaseAmount3
System Generated Payment Count 
Count IF PaymentStatus = SystemGeneratedPayment
Unreleased Payment Count 
Count IF PaymentStatus = Unreleased
Vendor Payment Amount PayablesInvoicePayment.VendorPaymentAmount
Void Payment Amount 
IF IsVoidCash = true THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
Void Payment Count 
Count IF IsVoidCash = true
Withholding Amount PayablesInvoicePayment.WithholdingAmount