AR130 - Automatic Cash Application Audit
Run AR130 (Automatic Cash Application Audit) to automatically apply payments
and, in certain cases, credit memos to open items for customers that have Yes
selected in the Automatic Application Method Apply field, and a method
selected in the Application Method field in AR10.1 (Customer).
AR130 has two form tabs; Selection and Algorithm. Choose the Selection form
tab to define application selection parameters. Choose the Algorithm form tab
to select parameters used in cash application.
Automatic application occurs in three ways: transaction match, transaction
applied, and the algorithm method. Transaction match uses a remittance advice
to match a payment to an associated open item. Transaction applied has two
types of processing: balance forward (oldest payments applied to oldest open
items) and last statement (oldest payments applied to open items on the
customer's last statement). The algorithm method applies a payment to a single
open item of the same amount (including a user-defined variance) or to a
user-defined combination of open items (variance not applicable).
Customers that have Open Item processing selected in the Application Method
field in AR10.1 (Customer) can use any automatic cash application method.
Customers that have Balance Forward processing selected in the Application
Method field in AR10.1 (Customer) can use only the balance forward automatic
cash application method.
Specific rules exist for the automatic application of credits and payments for
a national account relationship. Only the balance forward and transaction
match application methods can use national account application feature.
For balance forward processing, all unapplied payments and credits of the
national account will be applied first to the national account, then to
invoiced customers, assuming at least one payment is applied. The application
of the invoiced customer's unapplied payments and credits is controlled by
the National Account Credits field. If you type Yes, then all credits in the
national account group, along with the national account payments, will be
applied first to the national account, then the invoiced customer's open
items, assuming at least one payment is applied.
Note: Customers that only have unapplied credits (without unapplied payments)
may have credit applications created in AR131 (Automatic Memo Application).
Note: If you selected Yes in the Currency Override field, in selecting items
for application all possible currency combinations will be attempted (base
currency to base currency; non-base currency to like non-base currency; base
currency to non-base currency; non-base currency to an unlike non-base
currency). If you selected No in the Currency Override field, in selecting
items for application only certain combinations will be attempted (base
currency to base currency; non-base currency to like non-base currency; base
currency to non-base currency).
Payment remittance records for balance forward customers can be interface or
entered online, however AR130 will only allow those remittance records to be
applied if the remittance override method is selected.
AR130 does not delete remittance records. Remittance records are deleted when
you run AR300 (Transaction Purge) to delete a payment.
Note: If you selected Yes in the Currency Override field, the payment currency
will be respected; open items will be translated into the payment of the
currency.
For transaction match processing, the matching process will attempt to select
the national account's open items first, then the invoiced customer's open
items. If the matching process crosses companies, the base currencies must be
the same for the open item to be selected.
AR130 creates a report of the automatic cash application by batch number and
by sequence number within each batch, and includes both batch and report
totals.
Note: In a rare situation AR130 may not perform a 3-way currency application.
If a full application would cause the original amount to remain open
(generally only by a cent or two, due to rounding differences) the application
will not be processed. This is not an error, this is an exception that will
not be processed. The AR130 prints a message informing you of this exception.
Updated Files
ARADJUST - Primary file updated by program.
ARAPPLIED - Primary file updated by program.
ARCOMP - Obtains company information.
ARCUSTOMER - Updates customer balance and customer high balance.
ARCUSTPER - Updates customer period write-offs.
ARDRAFTS -
AROIHDR - Obtains open item records.
AROITEMS - Updates open item applied amount, open item sequence number,
and open item status.
AROPIVOT -
ARPAYMENT - Updates payment applied amount, payment applied sequence
number, and payment status.
ARPROCLEVL - Obtains process level information.
ARREASON - Obtains reason code information.
ARREMIT - Obtains information from remit file. Deletes remit records for
the company after running.
ARSADJUST - Temporary cash application adjustment record created.
ARSAPPLIED - Temporary cash application record created.
ARUADJUST -
ARUOIHDR -
ARUSADJUST -
CBBANKINST - Used as part of payment code validation.
CKPOINT - The environment file used for recovery.
CUSTDESC - Updates customer description balance.
NATBALANCE - Updates national account balance.
Referenced Files
ARAPSELECT -
ARCUSTGRP - Obtains customer group information.
ARDISTRIB - Validates tax point distribution status.
AROPTR - Verifies operator and set used flag.
ARPYMNTHDR - Obtains payment header information.
ARRTM - Validates presence of return to maker payment.
CUACCT - Calculates currency gain/loss adjustment.
CUCONV - Used as part of currency validation.
CURELAT -
GLADDRESS - Validates part of company information.
GLCHART - Validates part of company information.
GLCODES - Verifies general ledger dates.
GLINTCO - Used to validate inter company general ledger relationships.
GLSYSTEM - Validates general ledger company information.
NATACCT - Obtains national account information.
INVOKED Programs
IFAC
ACAC
ACCL
IFCU
IFSG
IFAU
SLSE
SLSU
|
