دفع المدفوعات

دفع المدفوعات

التحليل حسب التواريخ:

  • تاريخ الفحص
  • تاريخ الإنشاء
  • تاريخ الفاتورة
  • تاريخ الإلغاء
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