Understanding Business Unit Fee Tables
Use these guidelines when setting up business unit fee tables:
When you set up a revenue fee type in UDC table 15/FE, you must specify the appropriate type, either CCAR (business unit - accounts receivable) or CCGL (business unit - general ledger) in the Description 2 field.
You must specify a bill code for a single account, such as RRTL, in the Rev B Cd (revenue bill code) field for related revenue. For an account range, specify the automatic accounting instruction (AAI) that is related to the beginning account, such as 001B. The system automatically identifies the AAI for the end of the range.
The AAIs for an account range are PM001B (beginning account) and PM001E (ending account). You can define up to 999 different ranges (for example, PM999B and PM999E).
You can define a detail line for an accounts receivable invoice, accounts payable voucher, or general ledger transactions.
The system always creates journal entries in the general ledger. This action is controlled by the GM (generation mode) field and the accounting fields.
For an accounts receivable invoice, the account number identifies the revenue account to be credited, and the bill code identifies the general ledger offset account for accounts receivable to be debited.
For an accounts payable voucher, the account number identifies the expense account to be debited, and the bill code identifies the general ledger offset account for accounts payable to be credited.
For offsetting general ledger transactions, the system creates journal entries to debit the expense account and credit the revenue account associated with the invoice and voucher specifications.
The system uses this formula to calculate the fee amount: Revenue amount × fee rate.
The fee limits that are specified in the Minimum Amount and Maximum Amount fields are based on monthly amounts.
The Billing Control ID, assigned by Next Numbers, relates to the last time that a record was generated based on the batch number, billing period, and fiscal year for that record, and is used to compare the previous billing to the last billing during processing.
The system stores this information in the Revenue Fee Generation History table (F1505HB).
Set the Fee Type Screen Format processing option to blank for business unit fee tables.
Note: If you select the arrow next to Business Unit Fee Information on the G1526 menu and select Values, you can leave the Fee Type Screen Format processing option blank. If you set this processing option from the menu, you can always access the business unit fee information version of the Revenue Fee Master Revisions form from this navigation: Revenue Fees (G1526), Business Unit Fee Information.
See Deleting Unposted Revenue Fee Batches.
When you set up fee tables, the system stores the information in the Management Fee Master table (F1505B). This information controls the generation of the revenue fees.