previous

AR Apply/Unapply Payments (ar_payments_tracking with ARA3.FMX)

Note: This report is only available when the Cashiering>Accounts Receivables application function is set to Y.

The AR Apply/Unapply Payments report shows any past and/or current payments that have been Applied/Unapplied to invoices that fall within the report filter criteria.

Note: The report does not include unallocated payments that are sitting in AR and have not been applied against an invoice.

AR Apply/Unapply Payments Report Filter

Date Ranges

Note: The date range selected will correspond to the date the payment is posted in the AR Account and not the date it's applied to an invoice.

From Date. Enter the beginning date for the date range to populate the AR Apply/Unapply Payments on the report output. By default, the current business date is populated. If the value is removed and the field is blank, then the current business date will be used as the From Date filter.

To Date. Enter the end date for the date range to populate the AR Apply/Unapply Payments on the report output. By default, the current business date is populated. If the value is removed and the field is blank, then the current business date will be used as the To Date filter.

Filter

Account Number. Select the down arrow to choose a specific AR Account Number, or Numbers, from the list of values. If this field is left blank, all AR Accounts will be searched upon for payments that have has invoices payments Applied or Unapplied.

Payment Code. Select the down arrow to choose a specific payment method, or methods, used for the payment that was Applied/Unapplied to an invoice.

Report Output

It will show the amount and time Applied against the invoice and if the user later on Unapplied the payment, then it will show on the same record the amount and time of the Unapply operation.

Trn Code. The transaction code that was used for the payment.

Description. Description of the transaction code.

Invoice No. Number of the AR Account Invoice that the payment was Applied/Unapplied to.

Cur. Currency in which the payment was made in.

Payment Applied. Total amount of the payment that was Applied to the AR Invoice.

Payment Unapplied. Total amount of the payment that was Unapplied from the AR Invoice.

Supplement. Displays any comments entered that are relevant to the payment being Applied to the invoice.

Reference. Displays any comments entered that are relevant to the payment being Unapplied from the invoice.

User Name. User name assigned to the user that Applied/Unapplied the payment to the AR Invoice.

Cashier ID. If a Cashier ID is attached to the User Name, then this ID is populated in this column.

Payment Applied/Unapplied. System Date and Time that the payment was Applied/Unapplied to the AR Invoice.

Trn. Date. Date the payment was posted into the AR Account.

Account No. Account Number assigned to the AR Account that the transaction took place for.

Account Name. Name attached to the AR Account.