|
|
AR194 - Audit Summary
**Form Purpose
Run Audit Summary (AR194) to report accounts receivable activity, close
Invoice Payment Average (IPA) and Days Beyond Terms (DBT) period totals, and
create a static aged trial balance for each customer in a company. The report
includes all accounts receivable activity since the last time you ran AR194
and both process level (if selected) and company totals. Run AR194 daily after
you run Application Closing (AR190).
**Processing Effect
The customer static aging periods amounts display in Credit Transaction
Review (AR72.1) and Transaction Review (AR73.1) and are used when selecting
customers in Dunning Letter Select (AR160) and Customer Review Selection
(AR170). The aging amounts are calculated, in a due date aging format, as of
the current system date using the aging options defined for the company in
Company (AR01.1).
Each aging period includes two additional calculations: the percentage of
each period total compared to the sum total and the Funds Outstanding Ratio
(FOR) for the sum total and each applicable aging period. The FOR is not
calculated for the future and current periods because the FOR applies only to
invoices and debit memos and is always calculated using the invoice date. The
FOR is calculated as follows: 1) for each transaction, multiply the days
outstanding by the open amount to calculate the receivable days; 2) Add the
open amount of all open items to calculate the total open amount; 3) add the
receivable days of all open items to calculate the total receivable days; 4)
divide the total receivable days by the total open amount.
If you select No in the Qualify Future Applications field, only open
transactions (credit memos, debit memos, and invoices of status 1 (Open), and
payments of status 2 (Open Payment) will be selected. This cuts down on the
number of records that need to be read (and the processing time involved).
Note "Qualify future applications" refers to applications that have a GL date
greater than the "as of" system date. If you select Yes, then a future
application will not be considered as part of the "as of system date" open
amount logic. If you select No, then a future application will be considered
as part of the system date "as of system date" open amount logic.
Updated Files
ADDRDATA -
ARCUSTOMER - Updates customer occurs fields for IPA and DBT averages.
Updates paid prompt, invoice paid, collect days, and the static
past due aging fields.
ARSUMMARY - Accesses summary information printed on the top half of the
report.
CKPOINT - Use in program re-start logic.
MXLISTHDR -
STATICCUST - Updates a customer's static aging file if an aging code is
present for the customer.
Referenced Files
AGINGCODE - Accesses aging rules information.
ARADJUST - Used as part of application file access.
ARAPPLIED - Accesses applied amounts to payments, open items, or credit
memos.
ARCOMP - Accesses company information.
ARCUSTGRP - Used as part of company validation.
ARDISPUTE - Accesses dispute amounts.
ARDRAFTS - Accesses bills of exchange to determine totals in the summary
aged trial balance.
AROITEMS - Selects open items for use in determining totals in the
summary Aged Trial Balance.
ARPAYMENT - Selects payments for use in determining totals in the summary
aged Trial Balance.
ARPROCLEVL - Validates and selects by process level.
GLADDRESS - Defaults general ledger company address.
GLCHART - Validates general ledger company chart information.
GLSYSTEM - Validates general ledger company information.
INSTCTRYCD -
WFSETUP -
INVOKED Programs
IFOB
IFSG
|
