84 Reports and Inquiries Processing Options

This chapter contains these topics:

84.1 Trial Balance by Business Unit (P09410)

Processing Option Processing Options Requiring Further Description
LEVEL OF DETAIL:  
1. Specify the lowest level account to be printed (e.g.-7).  
PERIOD INFORMATION:  
2. Enter the fiscal year and period for which the General Ledger is to be prepared.

If left blank, the current period and year of the Financial Reporting Date will be used

Year:

Period:

 
PRINT OPTIONS:  
3. To select which account number to print on the Trial Balance, enter a:

'1' = account number (default)

'2' = short account i.d.

'3' = unstructured account.

 
4. Enter a '1' to omit printing accounts with zero balances.  
5. Enter a '1' to skip to a new page when the business unit changes.

If left blank page will not skip.

 
6. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
LEDGER TYPE:  
7. Enter ledger type.

If left blank, General Ledger Type "AA" will be used.

 
SUBLEDGER INFORMATION:  
8. Enter specific subledger or '*' for all subledgers.  
9. Enter a subledger type if you have selected a subledger in the option above.  
ENHANCED SUBLEDGER SELECTION:  
10. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 
OBJECT ACCOUNT SUMMARIZATION:  
11. Enter a specific business unit type for object range summarization, or:

'+' for all business unit types

'*' for non-blank business unit types

 
12. Enter the object account range for object account summarization.

Beginning:

Ending:

 
13. Enter a specific currency code or '*' for all currency codes.

This option applies only if you post the Account Balances by currency.

 
PRIOR YEAR-END BALANCES:  
14. Enter a '1' to print Prior Year-End Balances for Income Statement accounts.

Leave blank to print Prior Year-End Balances for Balance Sheet accounts only.

 

84.2 T/B by Object (P094121)

Processing Option Processing Options Requiring Further Description
PERIOD INFORMATION:  
1. Enter the fiscal period and year for which the Trial Balance is to be prepared.

If left blank, the current period and year of the Financial Reporting Date will be used.

Year:

Period:

 
LEDGER TYPE:  
2. Enter a ledger type (leave blank if the General Ledger 'AA' is desired).  
PRINT OPTIONS:  
3. Enter a '1' to omit the printing of accounts with zero balances.  
4. To select which account number to print on the Trial Balance, enter a:

'1' - account number (default)

'2' - short account i.d.

'3' - unstructured account

 
5. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
SUBLEDGER OPTIONS:  
6. Enter specific subledger or '*' for all subledgers.  
7. Enter a subledger type if you have selected a specific subledger in the option above.  
ENHANCED SUBLEDGER SELECTION:  
8. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 
CURRENCY CODE OPTIONS:  
9. Enter specific currency code or '*' for all currency codes.  
SUMMARIZATION:  
10. Enter the object account range for account summarization.

Beginning:

Ending:

 

84.3 Debit/Credit T/B by Business Unit (P09411)

Processing Option Processing Options Requiring Further Description
LEVEL OF DETAIL:  
1. Specify the lowest level account to be printed (e.g., 7).  
FISCAL PERIOD AND YEAR:  
2. Enter the fiscal period and year.

Leave blank to use the current fiscal period and year.

Year:

Period:

 
PRINT OPTIONS:  
3. To select which account number to print on the Trial Balance, enter a:

'1' = account number (default)

'2' = short account i.d.

'3' = unstructured account

 
4. Enter a '1' to omit printing accounts with zero balances.  
5. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
SUBLEDGER INFORMATION:  
6. Enter specific subledger or '*' for all subledgers.  
7. Enter a subledger type if you have selected a subledger in the option above.  
ENHANCED SUBLEDGER SELECTION:  
8. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 
PAGE BREAKS:  
9. Enter a '1' to skip to a new page when a business unit changes.

Default of blank will not page skip.

 
10. Enter a '1' to skip to new page between Balance Sheet and Income Statement Accounts.

If left blank, the report will not page skip.

 
ACCOUNT SUMMARIZATION:  
11. Enter a specific business unit type for object range summarization, or:

'+' for all business unit types

'*' for non-blank business unit types.

 
12. Enter the beginning and ending accounts for object account summarization.

Beginning:

Ending:

 
CURRENCY CODE:  
13. Enter a specific currency code or '*' for all currency codes.  
PRIOR YEAR-END BALANCES:  
14. Enter a '1' to print Prior Year-End Balances for Income Statement accounts.

Leave blank to print Prior Year-End Balances for Balance Sheet accounts only.

 

84.4 Debit/Credit T/B by Category Code (P09472)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD AND YEAR:  
1. Enter the fiscal period and year.

Leave blank to use the current financial reporting period and year.

Year:

Period:

 
LEDGER TYPE:  
2. Enter the ledger type to process.

If left blank, 'AA' will be used.

 
PRINT OPTIONS:  
3. Enter a '1' to omit printing accounts with zero period balances.  
4. Select which category code (1 - 23) to print.

Default of blank will print category code 21.

 
5. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  

84.5 G/L by Business Unit - (P09420)

Processing Option Processing Options Requiring Further Description
REPORT DETAIL FROM:  
1. Select a from period at which to begin showing account balances in detail. Enter:

'0' for year to date (default)

'1' for current period

'2' for inception-to-date

- OR -

Enter a from date at which to begin showing account balances in detail.

If this selection is left blank then the previous selection will be used.

From Date:

 
REPORT DETAIL THRU:  
2. Enter a thru fiscal year and period for which the account balances are to be shown in detail.

Year:

Period:

- OR -

Enter a thru date for which the account balances are to be shown in detail.

If selection is left blank the previous selection will be used.

Thru Date:

 
PRINT OPTIONS:  
3. Select the account number to print:

'1' = account number (default)

'2' = short account i.d.

'3' = unstructured account

 
4. Enter '1' to print units.

Leave blank to print amounts only.

 
5. Enter '1' to skip to a new page when a new business unit is printed.

Leave blank to print without page breaks.

 
6. Enter '1' to omit accounts that have no balance or detail for the selected period.  
7. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
DOCUMENT SELECTION:  
8. Enter ledger type code to use, or leave blank for actual amounts (AA).  
9. Enter document type to use if a selective ledger is used. Leave blank to include all document types.  
10. Enter a '1' to print both posted and unposted transactions. Leave blank to print only posted transactions.  
SUBLEDGER OPTIONS:  
11. Enter subledger to use, or '*' to include all subledgers.  
12. If a specific subledger is entered in the option above, enter the subledger type.  
13. Enter '1' to print the subledger on the General Ledger print-out.  
SUMMARIZATION:  
ENHANCED SUBLEDGER SELECTIONS:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 
ENHANCED SUBLEDGER PRINT:  
15. Enter '1' to print non-blank

Enhanced Subledgers on the report.

If blank, no ES fields will print.

 
SUMMARIZATION:  
16. Select business unit types for object range summarization. Enter:

A specific business unit type

'+' to include ALL types

'*' to include all non-blank types.

 
17. Enter the object account range for account summarization.

Beginning:

Ending:

 
GENERIC TEXT:  
17. Enter a '1' to print the generic text for journal entries in a 40 character width, a '2' to print text in an 80 character width.

If left blank, generic text will not be printed.

 
CURRENCY:  
18. Enter a specific currency code or an '*' for all currency codes.

This option applies only if you post the Account Balances by currency.

 

84.6 G/L by Object Account (P09421)

Processing Option Processing Options Requiring Further Description
REPORT DETAIL FROM:  
1. Select a from period at which to begin showing account balances in detail. Enter:

'0' for year-to-date (default)

'1' for current period

'2' for inception-to-date

- OR -

Enter a from date at which to begin showing account balances in detail.

If this selection is left blank then the previous selection will be used.

From Date:

 
REPORT DETAIL THRU:  
2. Enter a thru fiscal year and period for which the account balances are to be shown in detail.

Year:

Period:

- OR -

Enter a thru date for which the account balances are to shown in detail.

If selection is left blank the previous selection will be used.

Thru Date:

 
PRINT OPTIONS:  
3. Select the account number to print:

'1' = account number (default)

'2' = short account i.d.

'3' = unstructured account

 
4. Enter '1' to print units.

Leave blank to print amounts only.

 
5. Enter '1' to omit accounts that have no balance or detail for the selected period.  
6. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
7. Enter '1' to skip to a new page when a new object is printed. Leave blank to print without page breaks.  
8. Enter ledger type code to use, or leave blank for actual amounts (AA).  
DOCUMENT SELECTION:  
9. Enter document type to use if a selective ledger is used.

Leave blank to include all document types.

 
10. Enter a '1' to print both posted and unposted transactions.

Leave blank to print only posted transactions.

 
SUBLEDGER OPTIONS:  
11. Enter subledger to use, or '*' to include all subledgers.  
12. If a specific subledger is entered in the option above, enter the subledger type.  
SUMMARIZATION:  
13. Enter the object account range for account summarization.

Beginning:

Ending:

 
ENHANCED SUBLEDGER SELECTIONS:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 
GENERIC TEXT:  
15. Enter a '1' to print the generic text journal entry lines in a 40 character width, a '2' to print text in an 80 character width.

If left blank, generic text will not be printed.

 
CURRENCY:  
16. Enter a specific currency code or an '*' for all currency codes.  
AS-IF CURRENCY:  
17. Enter the currency code for as-if reporting. This option allows for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency.

If left blank, amounts will print in their database currency.

 
18. Enter the "As Of" date for processing the current exchange rate for the as-if currency.

If left blank, the Thru date will be used.

 

84.7 General Ledger with Subledger Totals (P09422)

Processing Option Processing Options Requiring Further Description
REPORT CONTENT:  
1. Select the transactions to be shown in detail (as opposed to summarized as a balance forward). Enter:

'0' for year-to-date (default)

'1' for current period

'2' for inception-to-date

 
PERIOD INFORMATION:  
2. Enter the fiscal year and period for which the General Ledger is to be prepared.

If left blank, the fiscal reporting year and period will be used.

Year:

Period:

 
PRINT OPTIONS:  
3. Select the account number to print:

'1' = account number (default)

'2' = short account i.d.

'3' = unstructured account

 
4. Enter '1' to print units. If left blank, only amounts will print.  
5. Enter '1' to skip to a new page when a new business unit is printed.

If left blank, the report will print without page breaks.

 
6. Enter '1' to omit accounts that have no balance or detail for the selected period.  
7. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
DOCUMENT SELECTION:  
8. Enter ledger type code to use.

If left blank, actual amounts (AA) will be used.

 
9. Enter document type to use if a selective ledger is used.

If left blank, all document types will be included.

 
10. Enter a '1' to print both posted and unposted transactions.

If left blank, only posted transactions will print.

 
SUMMARIZTION:  
11. Select business unit types for subledger summarization. Enter:

A specific business unit type

'+' to include ALL types

'*' to include all non-blank types

 
12. Enter the object account range for subledger summarization

Beginning:

Ending:

 
CURRENCY:  
13. Enter a specific currency code or an '*' for all currency codes.  

84.8 G/L by Category Code (P09470)

Processing Option Processing Options Requiring Further Description
REPORT DETAIL FROM:  
1. Select a from period at which to begin showing account balances in detail. Enter:

' ' for year-to-date (default)

'1' for current period

'2' for inception-to-date

- OR -

Enter a from date at which to begin showing account balances in detail.

If this selection is left blank then the previous selection will be used.

From Date:

 
REPORT DETAIL THRU:  
2. Enter a thru fiscal year and period for which the account balances are to be shown in detail.

Year:

Period:

- OR -

Enter a thru date for which the account balances will be shown in detail.

If selection is left blank the previous selection will be used.

Thru Date:

 
PRINT OPTIONS:  
3. Select which category code (1 - 23) to print.

Default of blank will print category code 21.

 
4. Enter a '1' to print units.

Leave blank to print amounts only.

 
5. Enter a '1' to omit printing of codes that have no balance or detail for the selected period.  
6. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
DOCUMENT SELECTION:  
7. Enter ledger type code to use, or leave blank for actual amounts (AA).  
8. Enter document type to use if a selective ledger is used.

Leave blank to include all document types.

 
9. Enter a '1' to print both posted and unposted transactions.

Leave blank to print only posted transactions.

 
DATE ORDER:  
10. Enter a '1' to print detail information in ascending date order.

Default of blank will print in descending order.

 
BUSINESS UNIT INFORMATION:  
11. Enter a '1' to print business unit description when business units change.  
AS-IF CURRENCY:  
12. Enter the currency code for as-if reporting. This option allows for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency.

If left blank, amounts will print in their database currency.

 
13. Enter the "As Of" date for processing the current exchange rate for the as-if currency.

If left blank, the Thru date will be used.

 

84.9 Transaction Journal (P09321)

Processing Option Processing Options Requiring Further Description
DATE RANGE:  
1. Enter the G/L date range to be processed:

From Date:

Thru Date:

 
ALTERNATE CHART OF ACCOUNTS:  
2. To print the account number from the alternate chart of accounts, enter the Category Code in which it is defined ('21', '22', or '23').

Leave blank to print the account in Business Unit.Object.Subsidiary format.

 
FORMAT:  
3. Enter '1' to print currency code and foreign amounts in lieu of Explanation, Address Number and Name.

Default of blank will print the above fields.

 

84.10 Trial Balance by Business Unit (P09210)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTIONS:  
1. Enter a '1' to omit displaying accounts with zero balances.  

84.11 Trial Balance by Object Account (P09214)

Processing Option Processing Options Requiring Further Description
MODEL BUSINESS UNITS:  
1. Enter a '1' to include Model Business Units in the display when a company other than company '00000' is entered.

If left blank, Model Business Units will be excluded regardless of the company entered.

 
DEFAULT PROCESSING:  
2. Enter the sequence numbers (1-2) to indicate the order in which formats will appear.

If left blank they will appear in default order:

Single Ledger Type Format

Dual Ledger Type Format

 
LEDGER TYPES AND COLUMN HEADINGS:  
3. Enter the ledger type for column 1.

Leave blank for default ledger type 'AA' - Actual Amounts.

 
4. Enter the User Defined Code key for column heading 1. Leave blank for default of 'Actual Amount'.

Note: The column titles are defined in User Defined Codes, System Code 14 Record Type CH. Specifying an Option of AA means that you have a Code value of AA in this table whose description will be used as the Column Heading on the video.

 
5. Enter a ledger type for column 2.

Leave blank for default ledger type 'CA' - Foreign Currency or 'AA' Actual Amounts, depending on whether currency is implemented or not.

 
6. Enter the User Defined Code key for column heading 2.

Leave blank for default of 'Foreign Currency' or 'Actual Amounts', depending on whether currency is implemented or not.

Note: The column titles are defined in User Defined Codes, System Code 14 Record Type CH. Specifying an option of AA means that you have a Code value of AA in this table whose description will be used as the Column Heading on the video.

 
7. Enter the scaling factor to be used.

Default of blank will use the Data Dictionary value.

 
8. Enter '1' to display the account number with account description in the fold area.

The default of blank will display the account description with account number in the fold.

Note: This applies to Dual Ledger Type Format only.

 
9. Enter '1' to display amounts without commas.

The default of blank will display amounts with commas.

 
10. Enter a '1' to omit displaying accounts with zero balances.  
11. Enter a '1' to display posting accounts only.

Default of blank will display non-posting header accounts as well as posting accounts.

 

84.12 Trial Balance by Company (P09216)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTIONS:  
1. Enter a '1' to omit displaying accounts with zero balances.  

84.13 Trial Balance by Subledger/Business Unit (P09215)

Processing Option Processing Options Requiring Further Description
Default Ledger Type  

84.14 Masked Trial Balance (P09217)

Processing Option Processing Options Requiring Further Description
WILDCARD SYMBOL:  
1. Enter the character to be used as the "wildcard" symbol.

If left blank the '*' symbol will be used.

NOTE: You cannot use the period (.) or comma (,) symbols or your account separator symbol as specified in the General Constants. If any of these are entered the default of '*' will be used.

 
DISPLAY OPTIONS:  
2. Enter a '1' to omit displaying accounts with zero balances.  

84.15 Account Ledger Inquiry (P09200)

Processing Option Processing Options Requiring Further Description
DATE PROCESSING:

1) Enter a '1' to hold the from and through dates between subsequent calls from external programs (such as Video Trial Balance by Business Unit (P09210)).

Leave blank to use the from and through dates from the external program between subsequent calls.

Note: This option will only affect processing when this program is being called upon several times from an external program.

 
PRE-LOADED DATA SELECTIONS:

2) Any values entered in the following options will be loaded upon entry into the program:

Account

From Date/Period

Thru Date/Period

Ledger Type

Sub Ledger (*=All)

Sub Ledger Type

 
OPTION 1 PROGRAM CALL:

3) Enter a '1' to exit to Journal Entries (P09101) when option 1 is entered next to a PK or PN document type.

Leave blank to exit to Manual Payment With Voucher Match (P04102) or Manual Payment Without Voucher Match (P04106).

 
DISPLAY OPTION:

4) Enter a '1' to display amounts without commas.

Leave blank to display amounts with commas.

 
DUAL LEDGER DISPLAY OPTION:

5) Enter a '1' if you wish to display a second ledger type entry field to allow you to view two ledgers at the same time.

Leave blank to display only one ledger type entry field.

AS-IF CURRENCY DISPLAY:

6) Enter the currency code for as-if currency display. This option allow for amounts to display in a currency other than the currency they are stored in. This option is activated by function key F19. Amounts will be translated and displayed in this as-if currency.

If left blank, amounts will display in their database currency.

7) Enter the "As Of" date for processing the current exchange rate for the as-if currency.

If left blank, the Thru date will be used.

 

84.16 Alternate Chart of Account Inquiry (P09218A)

Processing Option Processing Options Requiring Further Description
The first three processing options are for use with the Statutory Account Build screen. The remaining options are for the Alternate Account Inquiry screen.  
DEFAULT PROCESSING:  
1. Enter an index name to be preloaded on the Statutory Account screen.

Leave blank to not preload an index.

 
DISPLAY OPTIONS:  
2. Enter a "1" to display the Index Name, Description and Store Index (1/0) option.  
3. Enter a "1" to display the Index Name and Description only.  
4. Enter the category code (21 - 23) to inquire on.

The default of blank will use 21.

 
5. Enter a "1" to omit displaying accounts with zero balances.  
6. Enter the ledger type.

Leave blank for default ledger type 'AA' - Actual Dollars.

 
7. Initial screen format to display:

' ' = Balance format

'1' = Debit/Credit Format

 
8. Enter the scaling factor to be used on displayed amounts.

Default of blank will use the value from the Data Dictionary.

 
9. Enter the default date:

' ' = Use Current Period Date

'1' = Use Financial Reporting Date

 

84.17 Account Balance Comparison (P092121)

Processing Option Processing Options Requiring Further Description
LEDGER TYPES AND COLUMN HEADINGS:  
1. Enter the ledger type for column 1.

Leave blank for default ledger type

'BA' - Budget Amount.

 
2. Enter the User Defined Code value for

column heading 1. UDC table 14/CH

will be used for this search.

NOTE: The column heading that appears

on the screen is the description

that is assigned to the user

defined code you specify.

 
3. Enter the ledger type for column 2.

Leave blank for default ledger type

'AA' - Actual Amount.

 
4. Enter the User Defined Code value for

column heading 2. UDC table 14/CH

will be used for this search.

NOTE: The column heading that appears

on the screen is the description

that is assigned to the user

defined code you specify.

 
LEDGER COMPARISON CALCULATION:

5. Select one of the following for

column 3 calculation:

1 = Column 1 - Column 2 (Default)

2 = Column 1 / Column 2

3 = Column 1 x Column 2

4 = Column 1 + Column 2

This option applies only to the three

column screen format.

 
6. When using the three column screen

format, enter the number of decimals

to use when displaying column 3.

Default of blank will use the company

decimal positions. If a scaling

factor is used, it will override this

option.

 
DATA SEQUENCING:

7. Enter a '1' to sequence by Business

Unit, Subsidiary. (Note: This

option will not work if you are

using the Flex Chart of Accounts).

Default of blank will sequence by

Business Unit, Object.

 
DEFAULT PROCESSING:

8. Enter the Level of Detail to be

displayed. Default of blank will use

the value from the Data Dictionary.

 
9. Enter the sequence numbers (1-3) to

indicate the order in which formats

will appear. If all are left blank

they will appear in default order:

Two Column Format

Three Column Format

Four Column Format

NOTE: For the four-column format, the

ledger type and heading for

columns 1 and 3 are the same as

those for column 1, and columns 2

and 4 are the same as those for

column 2 on the two and three-

column format.

 
10. Enter the scaling factor to be used

on displayed amounts. Default of

blank will use the value from the

Data Dictionary.

 
11. Enter a '1' to display the Account

Number with the Account Description

in the fold area. Leave blank to

display the Account Description with

the Account Number in the fold area.

 
12. Enter a '1' to display amounts

without commas. Leave blank to

display amounts with commas.

 
13. Enter a '1' to omit displaying

accounts with zero balances.

 

84.18 Video Ledger Comparison (P0921)

Processing Option Processing Options Requiring Further Description
Enter the following column information.

(Defaults are as indicated - see Note on second page-Column Heading Codes)

COL. ITEM DEFAULT:

 
1. Ledger Type-Column 1 (BA)

Code for Col. 1 Heading (Col 1 LT)

 
2. Ledger Type-Column 2 (AA)

Code for Col. 2 Heading (Col 2 LT)

 
3. Calculation (+,-,/,X) (-)

Number of Decimals (0-4) (2)

Enter the desired interval. Enter a 'D' for Daily, 'W' for Weekly, or 1-7.

(Default is '7'.)

Enter a '1' to suppress the display of the processing options on the video and prevent the user from altering the options entered above from the video.

Note: Column headings will be the description associated with the User Defined Code, System Code '09', Record Type 'CH' specified for the column heading. The default is the description associated with the Ledger Type for the column, first, from System Code '09', Record Type 'CH', or second, from System Code '09', Record Type 'LT'.

 

84.19 Simple Income Statement (P10211)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal period and year.

Leave blank to use the financial reporting Year and Period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type.

If left blank, 'AA' will be used.

 
MINUS AMOUNTS:  
4. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
5. Enter a '1' to compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
INTERIM TOTALS:  
6. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
7. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
8. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
9. Enter a specific subledger or '*' for all subledgers.  
10. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
11. Enter a specific currency code or an '*' for all currency codes.  
12. Enter a '1' to omit printing acccounts with zero balance.  
ENHANCED SUBLEDGER SELECTIONS:  
13. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.20 Simple Balance Sheet (P10111)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal period and year.

Leave blank to use the financial reporting Year and Period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type.

If left blank, 'AA' will be used.

 
MINUS AMOUNTS:  
4. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
5. Enter a '1' to compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
INTERIM TOTALS:  
6. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
7. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
8. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
9. Enter a specific subledger or '*' for all subledgers.  
10. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
11. Enter a specific currency code or an '*' for all currency codes.

This option is applicable only if you post Account Balances by currency.

 
12. Enter a '1' to omit printing accounts with zero balance.  
ENHANCED SUBLEDGER SELECTIONS:  
13. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.21 Variance Analysis (P10212)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal period and year.

Leave blank to use the financial reporting Year and Period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type to be compared to the budget ledger type. If left blank, 'AA' will be used.  
4. Enter the budget ledger type. If left blank, 'BA' will be used.  
NEGATIVE AMOUNTS:  
5. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
6. Enter one of the following computation methods:

'1' - Compute Balance Sheet Net Income.

'2' - Compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
INTERIM TOTALS:  
7. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
8. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
9. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
10. Enter a specific subledger or '*' for all subledgers.  
11. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
12. Enter a specific currency code or an '*' for all currency codes.  
13. Enter a '1' to omit printing acccounts with zero balance.  
ENHANCED SUBLEDGER SELECTIONS:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.22 Variance Analysis with 5 Months (P10411)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal period and year.

Leave blank to use the financial reporting Year and Period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPES:  
3. Enter the ledger type to be compared to the budget ledger type. If left blank, 'AA' will be used.  
4. Enter the budget ledger type. If left blank, 'BA' will be used.  
NEGATIVE AMOUNTS:  
5. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
6. Enter one of the following computation methods:

'1' - Compute Balance Sheet Net Income.

'2' - Compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
INTERIM TOTALS:  
7. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
8. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
9. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
10. Enter a specific subledger or '*' for all subledgers.  
11. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
12. Enter a specific currency code or an '*' for all currency codes.  
13. Enter a '1' to omit printing accounts with zero balance.  
ENHANCED SUBLEDGER SELECTIONS:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.23 Monthly Spreadsheet (P10412)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal period and year.

Leave blank to use the financial reporting Year and Period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Specify the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type. Leave blank for Ledger Type "AA" - Actual Dollars.  
4. If selection 3 is chosen on processing option 6, enter the Remaining Budget ledger type. Leave blank for ledger type "BA".  
MINUS AMOUNTS:  
5. Enter a '1' to print expense and liability accounts as negative amounts.  
COMPUTATIONS:  
6. Enter one of the following:

'1' - Last 12 month Actual

'2' - Year-To-Date Actual plus Remaining Budget

Leave blank for Default "1"

 
7. Select one of the following:

1 - Compute Balance Sheet Net Income

2 - Compute Profit & Loss Net Income

Leave blank for no computation.

 
INTERIM TOTALS:  
8. Enter '1' to print Interim Totals as defined by "FS" AAI.  
FORMAT:  
9. Enter '1' to cause page skipping and to print headings with page number and run date on each page.

Enter '2' to cause page skipping and to print headings without page number and run date on each page.

If Blank, heading will print on the first page only.

 
10. Enter '1' to print the long form on 198 column paper or leave blank to print on 132 column paper.  
SUBLEDGER INFORMATION:  
11. Enter a specific subledger or '*' for all subledgers.  
12. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
13. Enter a specific currency code or an '*' for all currency codes.  
ENHANCED SUBLEDGER SELECTIONS:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.24 Financial Ratios (P10811)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter fiscal year and period.

Leave blank to use the financial reporting year and Period.

Year:

Period:

If you leave this processing option blank, the system uses the financial reporting date for each company if company or business unit is the first data sequence item. Otherwise, it uses the financial reporting date for company 00000.
LEDGER TYPE:  
2. Enter the Ledger Type. If left blank, Ledger Type "AA" (Actual Accounts) will be used.  
SUBLEDGERS:  
3. Enter a specific subledger or '*' for all subledgers.  
4. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
5. Enter a specific currency code or an '*' for all currency codes.  
ENHANCED SUBLEDGER SELECTIONS:  
6. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.25 Statement of Cash Flows (P10521)

Processing Option Processing Options Requiring Further Description
FISCAL DATE PATTERN COMPANY:  
1. Enter the company whose date pattern you want to use for printing the report date.

If left blank, company 00000's current period and fiscal year will be used.

 
THRU FISCAL PERIOD/YEAR:  
2. Enter the fiscal year and period for which the report is to be prepared.

If left blank, the current period and year of the above company's Financial Reporting Date will be used.

If left blank, company 00000 will be used.

Year

Period

 
LEDGER TYPE:  
3. Enter Ledger Type.

If left blank, 'AA' will be used.

 
ROUNDING FACTOR:  
4. Enter desired rounding factor:

' ' = no rounding

'0' = round to whole numbers

'1' = divide by 10

'2' = divide by 100

'3' = divide by 1,000

'4' = divide by 10,000

'5' = divide by 100,000

Amounts will be rounded to the nearest whole number. Actual amounts are used to accumulate totals.

 
RULES CODE:  
5. Enter the Rules Code to use when running the Statement of Cash Flows.  

84.26 Consolidated Income Statement - 12 Column (P103121) (Release A9.3 Update)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter the fiscal year and period.

Leave blank to use the financial reporting year and period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type.

If left blank, 'AA' will be used.

 
MINUS AMOUNTS:  
4. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
5. Enter a '1' to compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
CURRENT PERIOD:  
6. Enter a '1' for Current Period amounts only.

If left blank, Year-to-Date amounts will print.

 
INTERIM TOTALS:  
7. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
8. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
9. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
10. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field.  
SUBLEDGERS:  
11. Enter a specific subledger or '*' to select all subledgers.  
12. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
13. Enter a specific currency code or an '*' for all currency codes.  
ZERO BALANCES:  
14. Enter a '1' to omit printing accounts with zero balances.  
ENHANCED SUBLEDGER SELECTION:  
15. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.27 Consolidated Income Statement (P10312) (Release A9.3 Update)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter the fiscal year and period.

Leave blank to use the financial reporting year and period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type.

If left blank, 'AA' will be used.

 
MINUS AMOUNTS:  
4. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
5. Enter a '1' to compute Profit and Loss Net Income.

If left blank, no computations will be performed.

 
CURRENT PERIOD:  
6. Enter a '1' for Current Period amounts only.

If left blank, Year-to-Date amounts will print.

 
INTERIM TOTALS:  
7. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
8. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
9. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
10. Enter a specific subledger or '*' to select all subledgers.  
11. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
12. Enter a specific currency code or an '*' for all currency codes.  
ZERO BALANCES:  
13. Enter a '1' to omit printing accounts with zero balances.  
ENHANCED SUBLEDGER SELECTION:  
14. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.28 Consolidating Balance Sheet (P10311) (Release A9.3 Update)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR:  
1. Enter the fiscal year and period.

Leave blank to use the financial reporting year and period.

Year:

Period:

 
LEVEL OF DETAIL:  
2. Enter the lowest account level of detail to be printed (e.g., 7).  
LEDGER TYPE:  
3. Enter the ledger type.

If left blank, 'AA' will be used.

 
MINUS AMOUNTS:  
4. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

 
COMPUTATIONS:  
5. Enter a '1' to compute Balance Sheet Net Income.

If left blank, no computations will be performed.

 
INTERIM TOTALS:  
6. Enter a '1' to print Interim Totals as defined by "FS" Automatic Accounting Instructions.

If left blank, no interim totals will be printed.

 
FORMAT:  
7. Enter a '1' to cause page skipping and to print headings with page number and run date on each page.

Enter a '2' to cause page skipping and to print headings without page number and run date on each page.

If blank, heading will print on the first page only.

 
8. Enter a '1' to print the long form on 198 column paper.

If left blank, report will print within 132 columns.

 
SUBLEDGERS:  
9. Enter a specific subledger or '*' to select all subledgers.  
10. Enter a subledger type if you have selected a specific subledger above.  
CURRENCY:  
11. Enter a specific currency code or an '*' for all currency codes.  
ZERO BALANCES:  
12. Enter a '1' to omit printing accounts with zero balances.  
ENHANCED SUBLEDGER SELECTION:  
13. Enter the Enhanced Subledgers and Types you would like to select.

Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored.

Enhanced Subledger 1 . . . . . . .

Enhanced Subledger 1 Type. . . . .

Enhanced Subledger 2 . . . . . . .

Enhanced Subledger 2 Type. . . . .

Enhanced Subledger 3 . . . . . . .

Enhanced Subledger 3 Type. . . . .

Enhanced Subledger 4 . . . . . . .

Enhanced Subledger 4 Type. . . . .

 

84.29 G/L Cash Forecasting Summarization Build (P09520)

Processing Option Processing Options Requiring Further Description
CASH FORECASTING 'BEGINNING' DATE:  
1. Enter the method of calculation used to retrieve G/L Account balances.

' ' = Year to 'As Of' date

'1' = Period to 'As Of' date

'2' = Inception to 'As Of' date

 
CASH FORECASTING 'AS OF' DATE:  
2. Enter the "As Of" date to retrieve G/L Account balances.

If left blank, the current system date will be used as the 'As Of' ending date.

 
CASH TYPE:  
3. Enter the cash type to designate a G/L record in the Cash Forecasting file.

If left blank, '09' will be used as the cash type.

 

84.30 Account Balance Comparisons by Subledger (P092141) (Release A9.3 Update)

Processing Option Processing Options Requiring Further Description
LEDGER TYPES AND COLUMN HEADINGS:  
1. Enter the ledger type for column 1.

Leave blank for default ledger type 'BA' - Budget Amount.

 
2. Enter the User Defined Code value for column heading 1. UDC table 14/CH will be used for this search.

NOTE: The column heading that appears on the screen is the description that is assigned to the user defined code you specify.

 
3. Enter the ledger type for column 2.

Leave blank for default ledger type 'AA' - Actual Amount.

 
4. Enter the User Defined Code value for column heading 2. UDC table 14/CH will be used for this search.

NOTE: The column heading that appears on the screen is the description that is assigned to the user defined code you specify.

 
LEDGER COMPARISON CALCULATION:  
5. Select one of the following for column 3 calculation:

1 = Column 1 - Column 2 (Default)

2 = Column 1 / Column 2

3 = Column 1 x Column 2

4 = Column 1 + Column 2

 
6. Enter '1' to suppress the display of the processing options on the video and prevent the user from altering options entered above from the video.  
7. Enter the number of decimals to use when displaying column 3. Default of blank will use the company decimal positions. If a scaling factor is used, it will override this option.  
8. Enter the sequence numbers (1-3) to indicate the order in which formats will appear. If all are left blank they will appear in default order:

Three Column Format with Subledger

Three Column Format with Enh Sbl1

Three Column Format with Enh Sbl2

 
9. Enter the scaling factor to be used on displayed amounts. Default of blank will use the value from the Data Dictionary.  
10. Enter a '1' to display amounts without commas. Leave blank to display amounts with commas.  
11. Enter a '1' to omit displaying accounts with zero balances.