IdealWare Online Users Manual

GL4-09-02 G/L MAINTENANCE
31692 Report Generator Report Codes

 

PURPOSE

 

The Report Codes Maintenance program allows you to define reports. When defining a new report, the report information must be added via the following maintenance programs in the following sequence:

  1. REPORT CODES
  2. COLUMN HEADINGS
  3. SECTION TITLES
  4. MAJOR SECTIONS
  5. LINE TITLES
  6. REPORT DETAILS

Once the report information has been added via the REPORT CODES maintenance, move to the COLUMN HEADINGS maintenance etc.

 

 

PROCEDURE

 

When you select Report Codes from the Report Generator menu the following screen is displayed:

 

G/L REPORT CODES MAINTENANCE DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│May10/07                     D E M O   C O M P A N Y                            │
│                          G/L REPORT CODES MAINTENANCE                          â”‚
│                                                                                â”‚
│   COMPANY#              06  THE IDEAL COMPUTER GROUP INC.                      â”‚
│   REPORT CODE           __________                                             â”‚
│                                                                                â”‚
│01 REPORT HEADING                                                               â”‚
│02 COMMENT 1                                                                    â”‚
│03 COMMENT 2                                                                    â”‚
│04 COMPANY OR DIVISION                                                          â”‚
│05 STARTING DIVISION                                                            â”‚
│06 ENDING DIVISION                                                              â”‚
│07 DIVISIONS TO SKIP                                                            â”‚
│08 REPORT PERIOD                                                                â”‚
│09 DATE HEADING TYPE                                                            â”‚
│10 ROUNDING METHOD                                                              â”‚
│11 ACCOUNT/GROUP NAME                                                           â”‚
│12 PRINT NUMBER                                                                 â”‚
│13 RESERVED                                                                     â”‚
│14 RESERVED                                                                     â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

COMPANY#

 

Displays the company you are currently working in.

 

REPORT CODE

 

Enter the Report Code you wish to access or add.

 

[F5] to Display list of Report Generator Reports for selection.

 


ADD A CODE

 

If you enter a code which is not defined the following prompt displays.

 

** NOT ON FILE. DO YOU WANT TO ADD ? (CR=YES/F2=NO):

 

[Enter] to add a new code.

 

The program will step you through each field (see FIELDS below). Once all fields have been entered, the following prompt is displayed:

 

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept and update.

 

[F2] to modify.

 

See MODIFY AN EXISTING CODE below.

 

 

[F4] to not add the code and return to CODE field.

 

[F2] to not add a new code.

 

You may enter a different NEW code, an existing code or press [F4] to exit.

 

 

 

MODIFY AN EXISTING CODE

 

If you enter an existing code the following prompt is displayed.

 

** ENTER FIELD # TO MODIFY, D=DELETE, CR=CONTINUE:

 

[Enter] to not modify the code and return to the CODE field.

 

Enter the number of the field you wish to modify.

 

Once you have modified the field data (see FIELDS below) press [Enter] to return to this prompt where you may enter the number of additional fields to modify or press [Enter] again to end modifications.

 

 

[Enter] when modifications are complete.

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept changes and update.

 

The file is updated and you are returned to the CODE field.

 

 

[F2] to make additional modifications.

 

You are returned to the FIELD NUMBER prompt above.

 

 

[F4] to cancel changes and return to CODE field.

 

"D" to delete the code.

 

** OK TO DELETE? (Y/N):

 

"Y" to delete the code.

 

"N" to not delete the code.

 

Example Report Codes Maintenance display:

┌────────────────────────────────────────────────────────────────────────────────┐
│05/10/07                    D E M O   C O M P A N Y                             â”‚
│                          G/L REPORT CODES MAINTENANCE                          â”‚
│                                                                                â”‚
│   COMPANY#              01  IdealWare Demo Company                             â”‚
│   REPORT CODE           NEWREPORT                                              â”‚
│                                                                                â”‚
│01 REPORT HEADING        New Report                                             â”‚
│02 COMMENT 1                                                                    â”‚
│03 COMMENT 2                                                                    â”‚
│04 COMPANY OR DIVISION   C  COMPANY REPORT                                      â”‚
│05 STARTING DIVISION     FIRST                                                  â”‚
│06 ENDING DIVISION       LAST                                                   â”‚
│07 DIVISIONS TO SKIP     NONE IN SELECTED RANGE                                 â”‚
│08 REPORT PERIOD         VARIABLE                                               â”‚
│09 DATE HEADING TYPE     B  BALANCE SHEET STYLE                                 â”‚
│10 ROUNDING METHOD       B  TWO DECIMALS WITH CONDENSED PRINT MASK              â”‚
│11 ACCOUNT/GROUP NAME    A  ACCOUNT NAME                                        â”‚
│12 PRINT NUMBER          Y                                                      â”‚
│13 RESERVED                                                                     â”‚
│14 RESERVED                                                                     â”‚
│                                                                                â”‚
│                                                                                â”‚
│** OK TO UPDATE ? (CR=UPDATE, F2=MODIFY, F4=BYPASS): _                          â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

FIELDS

 

REPORT CODE

 

Enter a unique (up to) ten character code to identify the report.

 

The report code entered here will be referenced throughout the remaining report generator programs.

 

 

REPORT HEADING

 

Enter a thirty character heading description for the report.

 

COMMENT 1

 

Enter a thirty character additional optional comment.

 

[Enter] to bypass.

 

COMMENT 2

 

Enter a thirty character additional optional comment.

 

[Enter] to bypass.

 

COMPANY OR DIVISION

 

"C" for a company report.

 

This will allow only printing company consolidated reports.

 

 

"D" for a divisional report.

 

This will allow only printing individual reports by division.

 


[F2] for variable.

 

This will allow either company consolidated or divisional reports to be specified.

 

 

STARTING DIVISION

 

Enter a two character division code.

 

This defines the default starting division.

 

 

[F2] to set the starting division as the first G/L division.

 

Also automatically sets the ending division to the last G/L division.

 

 

ENDING DIVISION

 

Enter a two character division code.

 

This defines the default ending division.

 

 

[F2] to set the ending division to the last G/L division.

 

DIVISIONS TO SKIP

 

Enter any divisions to skip when printing the report.

 

Enter ##,##, to skip Individual divisions: for example, 01,02,04,

 

Enter ##-##, to skip a Range of divisions: for example, 03-05,

 

[F2] to skip no divisions

 

REPORT PERIOD

 

"M" for a monthly period.

 

This will print monthly figures only.

 

 

"Q" for a quarterly period.

 

This will print quarterly figures only.

 

 

"Y" for a yearly period.

 

This will print yearly figures only.

 

 

[F2] for a variable period.

 

This will allow a selection of monthly, quarterly or yearly when printing the report.

 

 

DATE HEADING TYPE

 

"B" for a balance sheet style.

 

"I" for an income statement style.


ROUNDING METHOD

 

"A" for two decimals with full print mask.

 

"B" for two decimals with condensed print mask.

 

"C" for no decimals.

 

You can fit more columns on the report with options "B" or "C".

 

 

ACCOUNT/GROUP NAME

 

"A" to use the account name.

 

"G" to use the group name.

 

This option is only relevant for lines where account detail is printed and indicates whether the account or group name will be printed.

 

 

PRINT NUMBER

 

"Y" to print the account number in description.

 

"N" to not print the account number.

 

This is only relevant for lines where account detail is printed.