Process
- 1. Extract Account Balances
Specify whether to extract the account balances from the Detailed Transaction table (F0911) or from the Account Balances table (F0902) to include on the report. Values are:
Blank: Account Balances table (F0902). Selecting balances from this table pulls an amount for each month in the range selected in the begin and end date processing options.
1:Detailed Transaction table (F0911). Selecting balances from this table pulls accounts for the range selected in the begin and end date processing options by the GL date.
- 2. Override for Account Transactions
Specify an override ledger type for extracting the expense account transactions. This option is helpful if you have posted transactions to a ledger type other than actual amounts (AA). The report prints transactions only from the ledger type that you enter here. Otherwise, no actual amount transactions print.
- 3. Offset Ledger Type
Specify a ledger type for extracting offset amounts. You can enter an offset ledger type for extracting the expense account transactions. This option is helpful if you have posted adjusting transactions to a ledger type other than actual amount (AA). The amounts for the ledger type entered is added to the AA amounts with the same GL account. If this option is left blank, the system does not extract offset amounts.
- 4. Account Range Inclusion
Specify which accounts to include in the expense class. Values are:
Blank: Combine object and subsidiary accounts. Includes all accounts greater than or equal to the From object account and subsidiary, and less than or equal to the To account and subsidiary. For example, if the From values equal 5000.010 and the To values equal 59999.020, all accounts between these values are included (account 5555.040 would be included).
1: Use separate comparison for object and subsidiary accounts. Includes all accounts with object accounts between the From and To object accounts and the subsidiary accounts between the From and To subsidiary. For example, if the From values equal 5000.010 and the To values equal 59999.020, all accounts with object accounts between 5000 and 59999 and the subsidiary accounts between 010 and 020 are included (account 5555.040 would not be included).
- 5. Ledger Type Group
Specify the name of a ledger type group that contains all the ledger types that should be included in the report.
- 6. Generation Type
Specify the generation type that the system assigns to the generated records. Values are:
2: E.P. Billings. The system recognizes these billings as E.P. Billing records.
6: Estimated E.P./Recurring Billings. The system recognizes these billings as Estimated E.P./Recurring Billing records.