Accounts Receivable - Detail Payment Query

Pgm: ARPAYQRY – AR Detail Payment Query; standard Treeview path: Accounts Receivable > Queries > Payments

The Accounts Receivable Detail Payment Query screen displays payment information based on check number within the entered customer code. The query allows you to retrieve payment information such as the cash account this payment was posted into, the check date, payment amount, received date, post date, reconciled date, currency, foreign amount, conversion factor, reversal code, reversed date, job code, batch number, and sequence number.

Selection Criteria

This section’s fields are used to filter the list of payment details displayed in the Receipt Query section.

Company

Enter/select a company code.

Show Voided Checks

Check this box to included voided checks.

Query Data

Press this button to run the query. If one of the parameters is changed, click this button again to refresh the list.

Receipt Query

This section lists the payment information details filtered via the Selection Criteria section.

Invoices

From a selected Payment record, use the Invoice Detail button to view those invoices, against which, the payment was applied.