Payables Payment
Analyze by Dates:
- Check Date
- Create Date
- Invoice Date
- Void Date
| Measure | Source and/or calculation |
|---|---|
| Bank Check Amount | BankCheckAmount |
| Base Withholding Amount | 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 DiscountLost = false THEN DiscountAmount.CurrencyAmount |
| Discount Amount Lost |
IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true THEN DiscountAmount.CurrencyAmount |
| Discount Eligible 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 DiscountLost = false AND DiscountAmount.CurrencyAmount <> 0 |
| Income Withholding Percent | IncomeWithholdingPercent |
| Net Payment Currency Amount | NetPaymentAmount.CurrencyAmount |
| Net Payment Functional Amount | NetPaymentAmount.FunctionalAmount |
| Paid Amount | IF PaymentStatus = Historical AND VoidSequence = 0 THEN PaymentAmount.CurrencyAmount |
| 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 <= Discount Date AND DiscountDate <> NULL |
| Payables Invoice Amount | PayablesInvoice.InvoiceAmount.CurrencyAmount |
| Payables Invoice Payment Count | PayablesInvoicePayment record count |
| Payables Invoice Payment Number Measure | Count of payments processed |
| Payables Payment Days Paid Late |
If paid late, days between DiscountDate and CheckDate OR days between DueDate and CheckDate |
| Payables Payment Discount Currency Amount | DiscountAmount.CurrencyAmount |
| Payables Payment Discount Functional Amount | DiscountAmount.FunctionalAmount |
| Payables Payment Discount Functional Amount Lost | IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true THEN DiscountAmount.FunctionalAmount |
| Payables Payment Discount Functional Amount Taken | IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = false THEN DiscountAmount.FunctionalAmount |
| Payables Payment Late Payment Count | IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate > DiscountDate OR CheckDate > DueDate |
| Payables Payment Invoiced Electronically Count | Count IF InvoiceSource = EDI |
| Payment Amount Currency Amount | PaymentAmount.CurrencyAmount |
| Payment Amount Functional Amount | PaymentAmount.FunctionalAmount |
| Payment Count | Count IF PaymentStatus = Historical AND VoidSequence = 0 |
| Received Discount Count | Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = false AND PayablesInvoice.DiscountAmount1 <> 0 |
| Released for Payment Count | Count IF PaymentStatus = Released |
| Rush Payment Amount | IF PayImmediately = true THEN PaymentAmount.CurrencyAmount |
| Rush Payment Count | Count IF PayImmediately = true |
| Secondary Withholding Transaction Amount 1-3 | SecondaryWithholdingTransactionAmount1-3 |
| System Generated Payment Count | Count IF PaymentStatus = SystemGeneratedPayment |
| Unreleased Payment Count | Count IF PaymentStatus = Unreleased |
| Vendor Payment Amount | VendorPaymentAmount |
| Void Net Payment Amount |
IF Status = Historical AND VoidSequence > 0 THEN NetPaymentAmount.FunctionalAmount |
| Void Payment Amount |
IF Status = Historical AND VoidSequence > 0 THEN PaymentAmount.FunctionalAmount |
| Void Payment Count | Count IF Status = Historical AND VoidSequence > 0 |
| Withholding Amount | WithholdingAmount |