GL50.1 - Ledger Report Setup
Use GL50.1 (Ledger Report Setup) to define and maintain a ledger report. The
ledger reports lists transaction detail for a General Ledger company. You can
select which transactions are selected for the report, what transaction fields
print, and how selected transactions are sorted, totaled, and printed. Both
debit and credit information is included.
Tip: Use the PageDown key to display additional fields that you can select to
include in the report.
The report prints one 78-character detail line for each transaction based on
the fields you select for printing and the sequence number you assign to each
field.
Choose the New Report button to define transaction report header information.
Choose the Totals button to select additional sorting, totaling, and page
break options.
Choose the Filter button to include or exclude specific values in the report.
You can Run GL250 (Ledger Report Listing) to list report parameters you
select. Run GL290 (General Ledger Report) to create the report.
Updated Files
GLRPTDEF - This file is updated with the transaction writer report
definition maintained by this program.
Referenced Files
GLADDRESS - Used by common library; not referenced in this program.
GLCHART - Used by common library; not referenced in this program.
GLRPTSEL - Used to access report selection parameters.
GLSYSTEM - Used to validate companies.
GL50.2 - Define Ledger Report
Use GL50.2 (Define Ledger Report) to define and maintain report requests and
header information.
Choose the Copy button to open the copy subform. Use this subform to create a
new ledger report by copying an existing one and changing information.
Updated Files
GLRPTDEF - This file is updated with the last report selection line
number maintained by this program.
GLRPTSEL - This file stores report selection records maintained by this
program.
Referenced Files
GLADDRESS - Used by common library; not referenced in this program.
GLCHART - Used by common library; not referenced in this program.
GLSYSTEM - Used to validate companies.
GL50.4 - Filters
Use GL50.4 (Filters) to define limiting values to include or exclude
transactions with a specific report field value.
Use the item and group fields together to create conditional value
statements. The following table shows the type of conditional statement
created depending on the values in these fields.
Item Number Group Number Statement
___________________________________________________
same same or
different different or
same different or
different same and
Note: If you choose an Item Number that represents an amount value, such as
Transaction Amount, and you want to include a negative amount in the value
range fields, make sure you type the minus (-) sign following the numeric
value. For example, type 100.00-.
Updated Files
GLRPTDEF - This file is updated with the report definition maintained by
this program.
GLRPTSEL - This file is updated with report selection criteria maintained
by this program.
Referenced Files
ACACTIVITY - Used to validate an activity.
CUCODES - Used to validate currency codes.
GLADDRESS - Used by common library; not referenced in this program.
GLCHART - Used by common library; not referenced in this program.
GLCODES - Used to validate system codes.
GLMASTER - Used to validate posting accounts.
GLNAMES - Used to validate accounting units.
GLSRCCODE - Used to validate source code.
GLSYSTEM - Used to validate companies.
GLZONE - Used to validate zones.
SYSTEMCODE - Used to validate system code.
GL50.5 - Copy
Use GL50.5 (Copy) to create a new ledger report by copying an existing one
and making changes.
Updated Files
GLRPTDEF - This file is updated with the copied report definition.
GLRPTSEL - This file is updated with the copied report selection criteria.
Referenced Files
GLADDRESS - Used by common library; not referenced in this program.
GLCHART - Used by common library; not referenced in this program.
GLSYSTEM - Used to validate companies.
INVOKED Programs
IFSG
|
