Pay When Paid Summary (Inquiry)

Additional Information

(missing or bad snippet)

Restrictions

The inquiry includes the following default restrictions:

RestrictionDescription
 From Posting Period

Enter or select a posting period. This is the first date in the date range to include all items.

To Posting PeriodEnter or select a posting period. This is the last date in the date range to include open items.
 VendorEnter or select a vendor.
 Payable BalanceEnter a payable balance.
 Days OldEnter a number of days old.
 To Be PaidEnter a to be paid value.

For a list of the optional restrictions, see ClosedPay When Paid Summary Inquiry Optional Restrictions.

The following optional restrictions are available:

  • Company
  • Currency
  • From Voucher Date
  • Invoice Number
  • Organization
  • Organization Map
  • Organization Map Level
  • Payable Account
  • Project
  • To Voucher Date
  • Vendor Parent
  • Voucher Number

Results

The inquiry results include the following levels of information:

  • Pay When Paid Summary: The first level of the inquiry provides pay when paid information, which includes Vendor Name, Voucher Number, Days Old, Currency Code, Payable Balance, Payable Paid, Unbilled, Billed, Available Amount, and To Be Paid. By default, the results are sorted by the Vendor Name and Voucher Number. ClosedPay When Paid Summary Optional Columns.

    The following optional columns of information are available:

    • % Collected
    • Account Code
    • Account Name
    • Available Tax
    • Collected
    • Invoice Number
    • Last Billed Date
    • Last Collected Date
    • Not Billable
    • On Hold
    • Organization Code
    • Organization Name
    • Organization Map Code
    • Organization Map Name
    • Organization Map Levels 2-6 Name
    • Pay When Paid
    • Payable Summary
    • Posting Period
    • Project Code
    • Project Name
    • Source Company Code
    • Source Company Name
    • Tax
    • Vendor Code
    • Vendor Parent Code
    • Vendor Parent Name
    • Vendor Type Code
    • Vendor Type Name
    • Voucher Amount
    • Voucher Date

    • Pay When Paid Detail: The detail level of the inquiry includes the Project Code, Project Name, Task Hierarchy Code, Amount, Unbilled, Billed, Bill Amount, Bill Currency Code, Bill Number, and Available Amount. By default, the detail is sorted by Creation Date. ClosedPayment History Detail Optional Columns.

      The following optional columns of information are available:

      • Bill Amount Collected
      • Client Code
      • Client Name
      • Collected
      • Company Code
      • Company Name
      • Creation Time
      • Detail Type
      • Document Type
      • Not Billable
      • Organization Code
      • Organization Name
      • Task Fee Type
      • Task Name

Available Amount Calculation

The displayed Available Amount will be different based on the Line Items type being classified as Chargeable, Non-Chargeable or Non-Project.

  • Chargeable Task
    • Available Amount is equal to Voucher Amount when 100% of the Bill Amount has been Collected
    • Holds do not effect Available Amount
    • Write-offs: Creates a Write-off line in Pay When Paid Detail and sets Available Amount to equal amount of Write-Off (Write-offs are not chargeable)
  • Non-Chargeable or Non-Project
    • Available Amount is equal to Voucher Amount. (These amounts are not subject to Project Billing, therefore a collected amount is not relevant)
  • Available Taxes
    • Available Amount divided by the (Voucher Amount – Tax), multiplied by the Tax Amount (ex. $50 / $100 * 10)
Example: Voucher (with Pay When Paid)
Line #TypeVoucher AmountAvailable Amount
L 1Chargeable40.000.00
L 2Chargeable10.000.00
L 3Non-Chargeable30.0030.00
L 4Non-Project20.0020.00
 Tax10.005.00
Total 110.0055.00