This chapter contains these topics:
Section 84.7, "General Ledger with Subledger Totals (P09422),"
Section 84.13, "Trial Balance by Subledger/Business Unit (P09215),"
Section 84.16, "Alternate Chart of Account Inquiry (P09218A),"
Section 84.26, "Consolidated Income Statement - 12 Column (P103121) (Release A9.3 Update),"
Section 84.27, "Consolidated Income Statement (P10312) (Release A9.3 Update),"
Section 84.28, "Consolidating Balance Sheet (P10311) (Release A9.3 Update),"
Section 84.29, "G/L Cash Forecasting Summarization Build (P09520),"
Section 84.30, "Account Balance Comparisons by Subledger (P092141) (Release A9.3 Update)."
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. |
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: |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
Processing Option | Processing Options Requiring Further Description |
---|---|
DISPLAY OPTIONS: | |
1. Enter a '1' to omit displaying accounts with zero balances. |
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. |
Processing Option | Processing Options Requiring Further Description |
---|---|
DISPLAY OPTIONS: | |
1. Enter a '1' to omit displaying accounts with zero balances. |
Processing Option | Processing Options Requiring Further Description |
---|---|
Default Ledger Type |
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. |
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. |
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 |
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. |
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'. |
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. . . . . |
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. . . . . |
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. . . . . |
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. . . . . |
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. . . . . |
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. . . . . |
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. |
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. . . . . |
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. . . . . |
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. . . . . |
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. |
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. |