AM270 - Account Balance Report
**Form purpose
Run Account Balance Report (AM270) to reconciles general ledger account
transactions that were posted to the General Ledger by company and account
number. This report includes the posting date, asset, tag, transaction type,
and transaction amount. You can run this report for non-posting books as
well.
**Required fields
Posting Dates (Beginning and End), Company or Company Group (not both), and
Book.
**Decision/impact
- You can report on any book that has the Trans Hist (Transaction History)
set to Y (Yes) on Book (AM00.1) or Books (AM00.2).
- If you select D (Detail) in the Totals field, the report lists all the
transactions, a begining and end balance for each account as well as the
detail of each addition, adjustment, transfer, and disposal transaction posted
to the account.
- If you select S (Summarize) in the Totals field, the report prints a
beginning and end balance as well as addition, depreciation, adjustment,
transfer, and disposal summary amounts for each account, for each
accounting unit, and for each company selected. This is the default.
- Select Y (Yes) in the Page Break field to start a new page when the company
or accounting unit changes. The default is N (No).
**More help
Use the other fields to further limit your report and specify the level of
setail and page breaks you want in the report.
You can limit the report to an accounting unit or to a list of accounting
units that are members of an accounting unit attribute list. Otherwise, all
accounting units in the company or company group to which asset balances have
been posted will be included in the report. You can also limit the report to
one or more ranges of accounts. If you do not specify account ranges, all
asset accounts that have balances will be included in the report.
Updated Files
CKPOINT -
MXLISTHDR -
MXLISTMBR -
Referenced Files
AMASSET - Used to retrieve the asset tag number.
AMBKTRANS -
AMBOOK - Used to retrieve the book description and currency code. Used
to store the asset book records that are used to depreciate
assets.
AMCALENDAR - Used to retrieve the posting book. Used to store calendar
records that asset books use for calculating depreciation,
replacement cost, and insurance values, and for reporting date
ranges.
AMTRANS - Used to retrieve transactions that were posted to the general
ledger. Used to store detailed records of asset transactions
that update the general ledger.
AMTRANSUMM - Used to retrieve the balances for accounts. Used to store
summary records of asset activity by general ledger account for
a fiscal year.
AUMXVALUE -
GLADDRESS - Referenced by a common library; not used by this program.
GLCGCPY - Used to validate the company group.
GLCHART - Referenced by a common library; not used by this program.
GLNAMES -
GLSYSTEM - Used to validate the company.
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
WFSETUP -
INVOKED Programs
IFAC
ACAC
ACCL
IFCU
IFSG
IFAU
SLSE
SLSU
IFUP
|
