Find Payments and Refunds

Security Note: You need the Allow searching of payments through Payment Explorer security right in the Contracts domain security rights group for this activity.

Activity Steps

  1. Open the Payment Explorer.
  2. Select the Payments tab.
  3. Enter the following search criteria as required.
    • Start Date—Limit the search by Payment Date or Refund Date.
    • End Date
    • Organisations—Select from the organisations and companies defined on the Organisations panel of the Solution Explorer.
    • Internal Companies—Select from the companies defined on the Organisations panel of the Solution Explorer.
    • Payment State—Select from Both, Locked and Unlocked.
    • Entry Type—Select from Both, Accounts Receivable and Accounts Payable.
    • Contract Type—Select from:
      • All—Payments and refunds related to invoice instalments for any contract type, including service, freight and finance.
      • Sales Contract—Payments and refunds related to invoice instalments for at least one sales despatch order. For example, this option can include payments for service invoice instalments for a service charge related to a sales despatch order.
      • Purchase Contract—Payments and refunds related to invoice instalments for at least one purchase despatch order.
    • Pay By—Set to Invoice.
    • Bank Accounts—Select from bank accounts defined for any Company. If any Internal Companies are selected, limited to back accounts for those companies.
  4. To include a text string in the search criteria, select the method to Search By and enter the Search Text. Text searches are case-sensitive with SQL databases with a case-sensitive collation and with all Oracle databases. Select from:
    • Payment Name (default)—Includes refund names.
    • Payment Reference—Includes refund references.
    • Internal Company
    • Organisation
    • Invoice Number
    • Invoice Reference
  5. To sort the search results:
    1. Select the method to Order By from Payment Name, Payment Date (default), Available Amount and Payment Amount.
    2. Set the Sort Order to be ascending or descending (default).
  6. Click Search or press F3.

    Note: You can save search criteria as a search profile. Search profiles for the Payment Explorer include all criteria except the Start Date and End Date.

  7. To edit a payment or refund or view more details, click the hyperlinked Payment Name.

    The Installment Payment or Refund displays.