|
|
AR197 - Self Balancing Report
Run AR197 Self Balancing Report to primarily list a beginning balance for a GL
account, list detail AR transaction activity, and calculate an ending balance.
This report is GL Account based, and used primarily at period end. This report
will also list prior updated GL account balances and account detail, and
update distribution balance records to enable future reporting.
This report lists balances and transaction activity for a GL account only for
the transaction activity that has occrured within the Accounts Receivable
system.
There are four report options, two of which may be run in update mode, and two
of which are listing types only.
Select Option 1 (Update Balances) is described above and is used primarily at
period end as a reporting tool to list the change in transaction activity for
a GL account since the last update run. A beginning balance for a GL account
is listed, then detail AR transaction activity is listed, and a calculated
ending balance is printed.
Select Option 2 (List Balances) will list a GL account's balances within the
date range specified.
Select Option 3 (List Detail) will list a GL account's transaction detail
within the date range specified.
Select Option 4 (Establish Balances) will update Accounts Receivable
distribution records for the specified ending date, and create distribution
balance records in AR99.6 Distribution Balance.
Sample Business Flow:
1. User establishes ending balances in AR197 for GL accounts they want to
track, with a balance "as of" date.
2. Transaction activity occurs to the specific GL Account:
This could be for any GL account - not just accrual type accounts.
Distribution post dates could be before, on, or after the stored balance
date/amount.
3. Disribution records are updated to the General Ledger system via AR195
Distribution Closing.
4. User runs Select Option 1 in AR197 with Ending Date (in update mode -
usually once a period). The previous dated stored balance amount is printed,
plus new transaction activity where the transaction post date is <= Ending
Date, with a computed ending balance. The Ending Date becomes the new balance
date, and acts as the beginning balance for the next update program run.
Note: When establishing balance records with multiple different GL dates,
(using opton 4), and then updating those balance records (using option 1), it
is important to, establish and update balances, in oldest GL date order.
For example; if the present processing period ends 6/30, and historical
balance records are desired for 2 GL accounts starting on 3/31 and on 4/30,
then establish the 3/31 balance record, update all balance records (just one
3/31 balance record exists) with a 4/30 ending date. Next establish the
second GL account balance record with a 4/30 date, update all balance records
(2 balance records exist now) with a 5/31 ending date. Now both records are
ready for the 6/30 balance update process.
Updated Files
ARDISTBAL -
ARDISTRIB -
CKPOINT -
Referenced Files
ARCOMP -
INVOKED Programs
IFAC
ACAC
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFUP
SLSE
SLSU
IFAU
|
