Documentation >
MAC-PAC Reference Library >
Financials >
General Ledger >
Key Concepts and Procedures >
Trial Balance, General Ledger, and Transaction Reports >
Transaction Report Definition
Transaction Report Definition
Transaction reports are set up and maintained by the Transaction Report Request and Specification File Maintenance Program (GL150E). The following figure shows the Transaction Report Definition Screen. The report number defines the report to the system. The report title is printed on the top of the report. These two fields are also used to identify the report on the Transaction Report Selection and Search Screens.
The report group field allows users to assign a particular report to a group that can be selected with one request. Using report groups ensures that all reports of a specific type are printed when the report group is selected. For example, complete trial balance reports for all locations can be included in one report group. Reports for a center or responsibility area can also be included in one report group.
Each transaction report specification defines account and transaction selection criteria for only one location. This provides more flexibility when reports for individual locations are required. The report group field can be specified if reports for multiple locations must be printed at one time. Account and center number ranges are provided so that reports can contain only the accounts or centers of interest to the user. The selected accounts can be printed in account or center sequence. Reports printed in account number sequence are used to review both the activity against certain account types and the activity of like accounts in a number of centers. Reports printed in center number sequence provide a better overall view of the activity against the specified accounts within each center.
Transaction reports can list financial or statistical data but not both. Duplicate report specifications must be entered to produce reports that list financial and statistical data for the same range of accounts. Data can be listed for a single fiscal period or a range of fiscal periods. Certain reports may require current fiscal period amounts to be listed. To list transactions and account amounts for the current processing period, leave the period range fields blank. The fiscal period ranges allow the user to prepare quarter-to-date and year-to-date reports.
WILLIAMS GENERAL LEDGER 2/27/95
DSP01 TRANSACTION REPORT SPEC FILE MAINT AND SELECT DEFINITION
ENTER
Report AA0005
Report Title INVENTORY, SUPPLIES, AND EQUIPMENT
Report Group
Company/Location 001 BER
From Account/Center 0101001000
To Account/Center 9999999999
Sequence Code A
Fin or Stat F
Period/Year (From/To) 01 95 02 95
Print Level D
Break 1 Pos/Desc
Break 2 Pos/Desc
Foreign Amounts N
Copies 1
Submit N
F2=Command F3=Exit F4=Prompt F9=Selection
F10=Search
|
Transaction Report Definition Screen
WILLIAMS GENERAL LEDGER 2/27/95
DSP01 TRANSACTION REPORT SPEC FILE MAINT AND SELECT SELECT
Report Group
Copies
--OR-- Roll 8
Enter the number of copies to print for each report
Copies Report Gp Report Title Sq Tp Fn Pt B1 B2
Co Loc From Account/Center To Account/Center Fp Fy Tp Ty
AA0005 INVENTORY, SUPPLIES, AND EQUIPMENT A F N D
ALL ALL ACCOUNT BALANCES/CHANGES A F Y D
FRPTOT ALL TRANSACTIONS FOR 007BRU A F Y D
FRP01 TRANSACTION REPORT FOR 009/001 A F Y D
FRP011 BS B/S ACCTS, CP, 007 BRU A F Y D 1 2
FRP012 BS B/S ACCTS, CP 007BRU - NO FOREIGN AMTS A F N D 1 2
FRP021 IS I/S ACCTS, CP, 007BRU C F Y A 1
FRP022 IS I/S ACCTS, CP, 007BRU - NON-FOREIGN AMTS A F N A 1 +
Submit Y
F2=Command F3=Exit F4=Prompt F6=Fold/Truncate
F10=Search F11=Report Defn
|
Transaction Report Selection Screen
Transaction reports can be prepared listing all detail transactions for the selected accounts (detail print level), only account and center totals (center print level), or only account totals (account print level).
Note: Two subtotals can be printed based on portions of the account number. The user defines the account number positions at which to subtotal, and the descriptive text printed at each subtotal break.
The foreign currency amounts associated with the detail transactions entered in a currency that was different than the base currency can be listed on a report.
Printed listings of transaction report definitions can be requested through the Allocation and Report Specification File Listing Program (GL110E). A listing of all transaction reports, a range of reports, or a single report can be prepared.