Customer Payment Application Inquiry

If you edit this topic, review Payment Apply and Open Item Apply and Resolve.

Menu Path: Accounts Receivable Images\bluerarw.gif Inquiries Images\bluerarw.gif Customers Images\bluerarw.gif Customer Payment Application Inquiry

Purpose

Review the details of a payment application.

Overview

Use Customer Payment Application Inquiry to view all details for payment applications. This window is an inquiry-only version of Payment Apply.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Customer Payment Application Inquiry window.

Show Data

Click this button to display or refresh accounts receivable data on the Results tab based on criteria selected on the Select tab. This button is only enabled if you enter a payment ID.

On Account

Click this button to display On Account Entry, which allows you to enter on account transactions. This button is only enabled if you enter a payment ID.

Payment Image

Click this button to display the payment image (if one was entered for the payment).

Amount Lookup

Click this button to display A/R Amount Lookup, which allows you to find accounts receivable transactions of a specific amount. This is useful if it is difficult to determine who the customer is on a payment (for example, the name on the check is a dba name), and there is no payment stub identifying reference numbers and corresponding amounts. If the payment is intended to pay for a single invoice, A/R Amount Lookup allows you to enter an amount and view all reference numbers with that amount, to help you determine the correct customer for the payment. This button is only enabled if you enter a payment ID.

Notes

Click this button to display Notes Entry, which allows you to create, updated, or delete notes for a selected payment. This button is only enabled if you enter a payment ID.

Prepayment Inquiry

Click this button to display Customer Prepayment Management, which allows you to view orders associated with a selected prepayment. This button is only available if you select a prepayment transaction.

Ribbon Batch Tab Buttons

Button

Description

Select

Click this button to display Select a New Batch, which allows you to select a previously created batch.

Open

Click this button to display Open a New Batch, which allows you to create a new batch.

Close

Click this button to display Close A Batch, which allows you to close a batch.

Edit

Click this button to display Edit A Batch, which allows you to edit an existing batch.

Select Tab Fields and Buttons

Field or Button

Description

Customer Code

Enter a customer code for which you want to display transactions, or click the Lookup button to select a customer code.

Name

Enter a customer name for which you want to display transactions, or click the Lookup button to select a customer name.

Customer Payment Date

This field displays the customer payment date.

Batch ID

This field displays the current batch. It defaults to an open batch if one is open. You can use the Select, Open, Edit, and Close buttons in the ribbon to work with batches.

Payment ID

Enter a payment ID for the selected customer, or click the Lookup button to select a payment ID.

Payment Date

This field displays the payment date of a payment entered in the Payment ID field.

Payment Amount

This field displays the amount of a payment entered in the Payment ID field.

Method

This field displays the payment method for the payment entered in the Payment ID field.

Currency

This field displays the currency of the batch entered in the Batch ID field.

Period

This field displays the accounts receivable default period.

Year

This field displays the accounts receivable default year.

All (Due Dates)

Select this check box to display transactions for all due dates.

From (Due Date)

Enter the first due date in a range of due dates for which to display transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All check box.

To (Due Date)

Enter the last due date in a range of due dates for which to display transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All check box.

All (Reference Dates)

Select this check box to display transactions for all reference dates.

From (Reference Date)

Enter the first reference date in a range of reference dates for which to display transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All check box.

To (Reference Date)

Enter the last reference date in a range of reference dates for which to display transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All check box.

All (Reference Numbers)

Select this check box to display transactions for all reference numbers.

From (Reference Numbers)

Enter the first reference number in a range of reference numbers for which to display transactions, or click the Lookup button to select a reference number. This field is only enabled if you clear the All check box.

To (Reference Numbers)

Enter the last reference number in a range of reference numbers for which to display transactions, or click the Lookup button to select a reference number. This field is only enabled if you clear the All check box.

All (Reference Types)

Select this check box to display transactions for all accounts receivable reference types.

Invoice

Select this check box to display invoice transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Finance Charge

Select this check box to display finance charge transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Credit Memo

Select this check box to display credit memo transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Non-Sufficient Funds

Select this check box to display non-sufficient funds transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Debit Memo

Select this check box to display debit memo transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

On Account

Select this check box to display on account transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Chargeback

Select this check box to display chargeback transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Prepayment

Select this check box to display prepayment transactions. This check box is cleared by default, and is only enabled if you clear the All check box.

Results Tab Fields and Buttons

Field or Button

Description

Sort Changed Browser Items First

Select this check box to display transactions that you are applying at the top of the Transactions grid.

Sort

Select one of the following sort options:

  • Ref # - Sort by invoice number or transaction ID.

  • Due Date / Ref#  - Sort by transaction due date, and then by invoice number or transaction ID.

  • Due Date / Ref Type - Sort by transaction due date, and then by type of transaction (i.e. invoice or credit memo).

  • Open Amt / Ref# - Sort by the transaction balance, and then by invoice number or transaction ID.

  • Ref Type / Due Date - Sort by the type of transaction (i.e. invoice or credit memo), and then by the transaction due date.

  • Expected Pay Date / Ref # - Sort by transaction expected payment date, and then by invoice number or transaction ID.

  • Store ID / Ref Date - Sort by the transaction’s store ID, and then by the reference date (i.e. invoice date).

  • PO# / Ref Date - Sort by the customer’s purchase order number, and then by the reference date (i.e. invoice date).

  • RA# / Ref Date - Sort by the transaction’s return authorization number, and then by the reference date (i.e. invoice date).

  • Billing Customer Code / Ref# - Sort by the customer code, and then by invoice number or transaction ID.

  • Billing Customer Name / Ref# - Sort by the customer name, and then by invoice number or transaction ID.

Transactions

This grid displays transactions based on the criteria selected on the Select tab. This grid includes the following columns:

  • Ref Type - This column displays the two-character code for the accounts receivable reference type of each transaction.

  • Ref# - This column displays the accounts receivable reference number for each transaction.

Note This also includes a suffix if the invoice has split terms (for example, HBG000060031-01)

  • Discount Date - This column displays the discount date, if applicable, for each transaction if the payment terms has a cash discount associated with it.

  • Ref Date - This column displays the reference date of each transaction.

  • Due Date - This column displays the due date of each transaction.

  • Orig Amt - This column displays the original amount of each transaction.

  • Open Amt - This column displays the current open amount of each transaction.

Note The open amount is independent of the reference type. If there was an invoice for $100 that was paid twice, this invoice could now have an open amount of -$100.

  • Applied Amt - This column displays the amount being applied to each transaction.

  • Cash Disc Applied Amt - This column displays the cash discount for each transaction.

  • Net Amt Applied - This column displays the apply amount plus the cash discount applied amount for each transaction.

  • Absorb Amt - This column displays the automatic absorption amount for each transaction. Sometimes a customer overpays or underpays for a transaction and you want to completely apply (pay off) that transaction anyway instead of keeping it open for a minor amount. If the transaction is not a chargeback, the reference payment absorption tolerance percentage and reference payment absorption tolerance amount rules are used. If the transaction is a chargeback, the chargeback absorption tolerance percentage and chargeback absorption tolerance amount rule are used.

Note Individual transaction-level absorption amounts are subject to an overall payment maximum absorption amount rule.

  • Cust Ref# - This column displays the customer's reference number for each transaction. This is typically found on chargebacks and credit memos.

  • Remarks - The check box in this column is selected for each transaction that has associated remarks.

  • Entered Currency - This column displays the entered currency of each transaction.

  • Orig Amt (Entered Currency) - This column displays the original amount of each transaction in the entered currency.

  • Open Amt (Entered Currency) - This column displays the open amount of each transaction in the entered currency.

  • Write-Off Amt - This column displays the write-off amount for any transaction that has a write-off.

  • Store ID - This column displays the store ID for each transaction. This is typically used for mass merchant accounts with retail store identification numbers to help in the resolution of a chargeback.

  • Cust PO# - This column displays the customer purchase order number for each transaction.

  • RA# - This column displays the return authorization number for each transaction.

  • Billing Customer Code - This column displays the billing customer code associated with each transaction.

  • Billing Customer Name - This column displays the billing customer name associated with each transaction.

  • Forex Amt - This column displays the currency exchange gain or loss amount for each transaction. This is calculated if the entered currency of the transaction is different than the currency of the batch.

  • Remark Content - This column displays the first remark associated with each transaction.

  • Contains Notes - The check box in this column is selected for each transaction that has notes entered for it.

  • First Order Number - This column displays the first order number associated with each transaction. This column is only used for invoices, credit memos, and prepayments.

  • Chargeback User Defined 1-10 - These user-defined columns display appropriate information for chargebacks. For information on setting up the labels, formats, and validation for these columns, see User Defined Fields Maintenance.

Amount to Apply

This field displays the amount to be applied for the selected payment ID.

Applied Amount

This field displays the cumulative amount applied for the selected payment ID.

Cash Discount Total

This field displays the cumulative cash discount amount applied for the selected payment ID.

Charge Back Total

This field displays the cumulative chargeback amount applied for the selected payment ID.

On Account Total

This field displays the on account amount for the selected payment ID.

Absorption Total

This field displays the cumulative absorption amount applied for the selected payment ID.

Unapplied Balance

This field displays the summary balance left to apply for the selected payment ID.

Write-Off Total

This field displays the total write-off amount for the selected payment ID.