The following steps are a checklist when setting up and using the General Ledger Report Writer.
Contents
Column Definition Maintenance
From the Report Write menu, select the Column Definition Maintenance. Check and add/change the column definitions applicable to Company’s reporting requirements. A set should already exist in the Demonstration Database. Use these examples as a guide line to create new columns.
Work with Reports
From the Report Writer menu, select Work with Reports. Create a basic Profit and Loss Report and the Balance Sheet Statement for all accounts. The Report definition is made up of three (3) areas.
- Page Headings – Variables can be used in the Page Headings. These variables are the fields in the file that can be defined on the report. The Variables and User defined text (Balance Sheet) print at the top of the reports. Variables are defined in TMSGL/RW-VAR. For example &PERIOD, prints the current period if that period is selected to print or previous period etc.
- Page Columns – Columns are used to define what figures should be printed on the specific report.
- Page Details – The Details consist of Sub-Headings, Accounts, and Totals. An example exists for each of these definitions.
Report Verification
Once the Basic Reports for Profit and Loss and the Balance Sheet have been defined, select Report Verification from the menu. This option checks to see if all accounts have been added to the correct Report Type.
An error report prints identifying any accounts that have been added. If no entries are found on the report then all accounts have been added and are correct. If however, entries are found on the report, a message prints against each line advising the errors found. These errors need to be corrected in the definitions.
Print Listings
Listings can be printed for Column definitions and for Report Definitions. These reports can be used for any final checking of the Definitions.
Batch Run Maintenance
A Template must be setup first with the Default parameters. This allows the users to run the Reports Interactively.
This menu options provides the facility for the user to add a group of reports together in a single Run. If no grouping of reports is required, only the Template is required to be setup in this menu.
For example: Weekly reports, the Profit and Loss Reports for each division to a specific Run number (WEEKLY). See examples in this manual.
User restriction logic will prevent this report from being run by unauthorised users. This uses standard process GLO310 and TMSGL/UA-ACC to decide if a user has access to each company and profit centre selected in the report run panel. Any unauthorised accounts will be dropped from report.
Batch Report Run
The Submit Report Options prints all the reports associated with the selected Run number.
Print Single Reports
To print a single Report select Run Reports from the menu. This option is used to select reports defined in Work with Reports option. Changes can be made to the Report Submitter Parameters only. This menu option can be given to staff members who are only required to print the reports. Single Reports can also be run from the Work with Reports menu.
Interactive Report Run
This Report Run option is the final step in Report Writing and is used to produce the reports, based on instructions stored in the Batch Run Maintenance File. These instructions can be overridden when running the report as a maintenance facility is provided which allows for the entry of new selection criteria.
