This chapter contains these topics:
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| REPORTING PERIOD: | |
| 1. Beginning month: (mandatory)
Beginning year: (mandatory) Ending month: (mandatory) Ending year: (mandatory) |
|
| LEDGER TYPE SELECTION: | |
| 2. Enter the requested Ledger Type.
The default is 'AA'. For multiple Ledger Types, enter the User Defined Codes file in which they are listed. System Code: Record Type: |
|
| SUBLEDGER INFORMATION: | |
| 3. Enter '1' to print the Subledger and Subledger Type on the report.
Leave blank to omit these columns. |
|
| BUSINESS UNITS: | |
| 4. Enter '1' to print the Business Unit on the report.
Leave blank to omit this column. |
|
| 5. Enter the model Business Unit to use to retrieve the account descriptions.
By default, the transaction description will be printed. |
|
| POSTING: | |
| 6. Enter '1' to print unposted transactions.
Leave blank to print only posted transactions. |
|
| 7. Enter '1' to print a total for posted transactions and a total for unposted transactions.
By default, these totals will not be printed. |
|
| ZERO BALANCES: | |
| 8. Enter '1' to print the accounts with a zero balance in the period and year requested.
By default, these accounts will not be printed. |
|
| FORMAT SELECTION: | |
| 9. Enter '1' to print the G/L Registration Number and Currency Code instead of Batch Number and Batch Type. | |
| PROOF OR FINAL MODE: | |
| 10. Enter '1' to run the report in final mode.
In final mode, only records that have been printed in final mode on the Trial Balance report (P7409C3) will be printed. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| REPORTING PERIOD: | |
| 1. Beginning month: (mandatory)
Beginning year: (mandatory) Ending month: (mandatory) Ending year: (mandatory) |
|
| LEDGER TYPE SELECTION: | |
| 2. Enter the requested Ledger Type. The default is 'AA'.
For multiple Ledger Types, enter the User Defined Codes file in which they are listed. System Code: Record Type: |
|
| ALTERNATE CHART OF ACCOUNTS: | |
| 3. Enter the first Profit and Loss account for the alternate chart of accounts. | |
| 4. Enter the Category Code used for the alternate chart of accounts. (R021, R022 or R023) | |
| SUBLEDGER INFORMATION: | |
| 5. Enter '1' to print the Subledger and Subledger Type on the report.
Leave blank to omit these columns. |
|
| BUSINESS UNITS: | |
| 6. Enter '1' to print the Business Unit on the report.
Leave blank to omit this column. |
|
| POSTING: | |
| 7. Enter '1' to print unposted transactions.
Leave blank to print only posted transactions. |
|
| 8. Enter '1' to print a total for the posted transactions and a total for the unposted transactions.
By default these totals will not be printed. |
|
| ZERO BALANCES: | |
| 9. Enter '1' to print the accounts with a zero balance in the requested period.
By default, these accounts will not be printed. |
|
| DREAM WRITER VERSION: | |
| 10. Enter the DREAM Writer Version of the General Ledger report program (P7409C2A) to run.
By default, the version will be 'XJDE0001'. Depending on which category code is used, the DREAM Writer version of this program has a different data selection. |
|
| REPORT SELECTION: | |
| 11. Enter '1' to print the G/L Registration Number and Currency Code instead of Batch Number and Batch Type. | |
| PROOF OR FINAL MODE: | |
| 12. Enter '1' to run the report in final mode.
In final mode, only records that have been printed in final mode on the Trial Balance report (P7409C4) will be printed. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| REPORTING PERIOD: | |
| 1. Enter the accounting period and the fiscal year.
Leave blank to use the period and fiscal year of the Financial Reporting Date. Period: Year: |
|
| LEDGER TYPE SELECTION: | |
| 2 Enter the requested Ledger Type.
The default is 'AA'. For multiple Ledger Types, enter the User Defined Codes file in which they are listed. System Code: Record Type: |
|
| MODEL BUSINESS UNIT: | |
| 3. Enter the model Business Unit to be used for retrieving the account descriptions.
By default, the transaction descriptions will be used. |
|
| ZERO BALANCE: | |
| 4. Enter '1' to print the accounts with a zero balance in the requested period.
By default, these accounts will not be printed. |
|
| TOTALING LEVEL: | |
| 5. Enter the totaling level for the account (1 to 4 characters). The default level is 2.
Example: totaling level 2 = class total (1) sub-class total (10) |
|
| PROOF OR FINAL MODE: | |
| 6. Enter '1' to run the report in final mode.
Caution: The report can be run in final mode ONLY ONCE for the selected period and fiscal year. The transactions printed will not appear again on subsequent executions. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| REPORTING PERIOD: | |
| 1. Enter the accounting period and the fiscal year.
Leave blank to use the period and fiscal year of the Financial Reporting Date. Period: Year: |
|
| LEDGER TYPE SELECTION: | |
| 2. Enter the requested Ledger Type.
The default 'AA'. For multiple Ledger Types, enter the User Defined Codes file in which they are listed. System Code: Record Type: |
|
| ALTERNATE CHART OF ACCOUNTS: | |
| 3. Enter the first P&L account for the alternate chart of accounts. | |
| 4. Enter the category code used for the alternate chart of accounts. (R021, R022 or R023) | |
| ZERO BALANCES: | |
| 5. Enter '1' to print the accounts with a zero balance in the requested period.
By default, these accounts will not be printed. |
|
| TOTALING LEVEL: | |
| 6. Enter the totaling level for the account (1 to 4 characters). The default level is 2.
Example: totaling level 2 = class total (1) sub-class total (10) |
|
| PROOF OR FINAL MODE: | |
| 7. Enter '1' to run the report in final mode.
Caution: The report can be run in final mode ONLY ONCE for the selected period and fiscal year. The transactions printed will not appear again on subsequent executions. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| REPORTING PERIOD: | |
| 1. Enter the beginning and ending year and period, or beginning and ending date.
Beginning Period. . . Beginning Year. . . Ending Period. . . Ending Year. . . - OR - Beginning Date. . . Ending Date. . . |
|
| LEDGER TYPE SELECTION: | |
| 2. Enter the requested Ledger Type.
The default is AA'. For multiple Ledger Types, enter the User Defined Codes file in which they are listed. System Code. . . Record Type. . . |
|
| ACCOUNT NUMBER TO PRINT: | |
| 3. The default account to print is the Object/Subsidiary. To print the alternate account number, enter the category code where it is stored ('21', '22' or '23'). | |
| OPTIONAL COLUMNS: | |
| 4. Enter '1' to print these columns on the report:
Business Unit. . . Subledger. . . |
|
| SUMMARIZATION OF ENTRIES: | |
| 5. Enter '1' to summarize entries to the same Account in multiple Business Units.
Leave blank to print in detail. In either case, debits and credits on the same account will not be summarized. |
|
| MODEL BUSINESS UNIT: | |
| 6. If the Object/Subsidiary account is being printed, enter a model Business Unit from which to retrieve the account description.
If left blank, the transaction account description will be used. If you are using the account in category code 21, 22, or 23, the description from the User Defined Code file will be used. |
|
| PROOF OR FINAL MODE: | |
| 7. Enter '1' to run the report in final mode. In final mode, only records that have been printed in final mode on the Trial Balance report (P7409C3 or P7409C4) will be printed. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| ACCOUNTING PERIOD AND FISCAL YEAR: | |
| 1. Enter the date OR the accounting period and fiscal year to select the data.
If left blank, the current accounting period and fiscal year will be used. Date: -OR- Period: Year: |
|
| LEDGER TYPE: | |
| 2. Enter the User Defined Codes file containing the ledger types to process.
If left blank, only ledger type AA will be processed. System Code: Record Type: |
|
| PROFIT AND LOSS ACCOUNTS: | |
| 3. Enter the range of accounts to select the Profit and Loss Accounts.
If left blank, the automatic accounting instructions GLG6 to GLG12 will be used as defaults. Beginning Account: Ending Account: |
|
| FRENCH CHART OF ACCOUNTS: | |
| 4. Enter one of the following values to indicate where the French Chart of accounts is defined:
1 - in object 2 - in object.subsidiary 21,22,23 - in category code |
|
| MODEL BUSINESS UNIT: | |
| 5. Enter the model business unit to retrieve the account description. | |
| BEGINNING BALANCE: | |
| 6. Enter the number of fiscal years for which the beginning balance needs to be loaded (maximum 3 years).
By default, no previous year beginning balance will be retrieved. |
|
| ACCOUNTS WITH ZERO BALANCE: | |
| 7. Enter 1 to select only the accounts with an active balance.
The default zero and will select all of the accounts. |
|
| MULTI-MEMBER FILE: | |
| 8. Enter the name of the member to be created in the file F7409FI.
If left blank F7409FI will be used as default. |
| Processing Option | Processing Option Requiring Further Description |
|---|---|
| PERIOD INFORMATION | |
| 1. Enter the Fiscal Year | |
| 2. Enter the Fiscal Period Number (01 thru 14) | The system generates the audit number from the last number processed in the fiscal year to the period entered in this processing option. |
| OPENING BALANCE | |
| 3. Ledger Type
Neither AA nor Blank values allowed |
Enter the ledger type for opening balances. |
| 4. Document Type
Blank not allowed |
Enter the document type for opening balances. |
| COMPANY | |
| 5. Enter the Company Number to be used in order to retrieve G/L transactions.
Blanks or 00000 not allowed. |
|
| PROCESSING MODE | |
| 6. Enter 1 to run in Final Mode and update files or Blanks to run in Proof Mode.
Default value: Proof Mode |
|
| ADDRESS NUMBER DESCRIPTION | |
| 7. Enter
1 = Alpha Name from F0101 file 2 = Mailing Name from F0111 file |
The value that you enter here will appear in field 8 (CompAuxLib) of the generated file. |
| FRENCH CHART OF ACCOUNTS | |
| 8. Enter the account format to be used:
Blank = G/L Account format (ANI) 1 = G/L Account format 21 = Category Code 21 22 = Category Code 22 23 = Category Code 23 Default value: Blank |
Specify where the French chart of accounts is set up. |
| Processing Options | Processing Options Requiring Further Explanation |
|---|---|
| FISCAL YEAR (required) | |
| 1. Format yyyy | The system issues an error message and stops processing if the fiscal year specified is not set up for the Company specified in processing option 5. |
| PERIOD NUMBER (Required) | The system issues an error message and stops processing if the periods specified are not closed periods. |
| 2. From | |
| 3. To | |
| COMPANY (Required) | |
| 5. Enter the company | The system issues an error message and stops processing if the company number entered is invalid. |
| FRENCH CHART OF ACCOUNTS | |
| 4. Enter the Account format to be used.
1: BusinessUnit.Object.Sub (ANI) 21: Category Code 21 22: Category Code 22 23: Category Code 23 Default value is 1 (ANI). |
The system issues an error message and stops processing if you enter an invalid value. |
| ADDRESS NUMBER DESCRIPTION | |
| 6. Enter the description to use in field "CompAuxLib"
'1' Alpha Name (F0101.ABALPH) '2' Mailing Name (F0111.WWMLNM) Default value is '1'. |
The CompAuxLib field is for the subsidiary ledger account number. |
| EXTRACTION MODE | |
| 7. Enter the mode to extract information
Blank: By ex post Sequenced Number 1: By Document Number & Type |
If you enter 1 in this processing option, the system does not use the sequencing generated by the P76B906 program. You must complete processing options 8 and 9. |
| OPENING BALANCE | These processing options are required if you entered 1 in extraction mode processing option.
The system issues an error message and stops processing if the opening balances for the period are not in the F0911 table. |
| 8. Opening Balance Ledger Type (LT) | |
| 9. Opening Balance Document Type (DCT) |