Setting Up a Ledger Type Rule

Access the Ledger Type Rules Setup form.

Units Ledger Type

Enter a value for Units Ledger Type. The units ledger is relational to the amount ledger. The first character in both ledgers is the same. The second character in the units ledger is a U.

The one exception to this rule is the AZ (Cash Basis) amount ledger. If you do not fill in a units ledger for the AZ amount ledger, a default units ledger of ZU is used by the G/L Post. The units ledger must be a valid ledger type.

With the exception of the AZ ledger, you typically set up the unit ledger type with the same first character as the actual amounts ledger type to which it applies. For example, the units ledger for AA is AU. You can set up a units ledger to be used with any of the ledgers that you set up in UDC 09/LT. However, unit ledger types FU, HU, and IU can be used only with the FA, HA, and IA ledgers, respectively. For example, you cannot set up an FX ledger for actual amounts and use it with the FU ledger for units.

Close to Retained Earnings Account

Select this option to denote that retained earnings should be calculated for this ledger during the Annual Close. This flag must be selected for the AA and AZ ledgers.

This option specifies whether the Annual Close program (R098201) closes accounts in this ledger to a retained earnings account.

Ledger is Required to Balance

Select this check box if entries for this ledger must be in balance (net to zero). Unlike the Create Intercompany Settlements check box, this check box does not ensure that companies within this ledger are in balance. This check box ensures only that entries for this ledger are in balance.

Create Intercompany Settlements

Select this check box if you want the system to create balancing entries when a transaction that involves multiple companies is entered for this ledger. This check box works with the intercompany settlement method on the General Accounting Constants form. If this check box is selected, the system validates that entries for this ledger are in balance by company when posted. If companies are out of balance, the system uses the intercompany settlement method to bring them into balance. If this check box is selected and the intercompany settlement method is set to N (no intercompany transactions), the system does not post a transaction that involves multiple companies if those companies are out of balance. If this check box is not selected, the system does not validate that companies within this ledger are in balance.

Prevent Direct Balance Update

Select this check box to prevent users from entering amounts directly in the Account Balances table (F0902) for this ledger.

Note: You must select this check box for ledger types AA, CA, and AZ. Otherwise, the system displays an error message. If an amount ledger has a unit ledger associated with it, the check box value for the unit ledger type must be the same as the amount ledger. You must select this check box for the AA ledger type so that users cannot access a budget program, for example, change the ledger type, and change the account balances. However, you might not want to select this check box for the AC ledger because the Compute Restated Balances program (R11414) directly updates this ledger.

For example, if you enter amounts for ledger type BA, do not select this check box so that you can enter amounts using the budget programs. Then when finished, select this check box to prevent future updates to the F0902 table.

Roll Original Budget to Next Year

For budget ledger types, select this check box to designate that the original budget can be rolled forward in the Annual Close program.

The Job Cost system uses this functionality.

Override Budget Do Not Spread Code

For budget ledger types, select this check box for the Spread Annual to Periods program (R14801) to override the DNS (Do Not Spread) code and evenly distribute annual budget amounts among the periods for accounts that are assigned the DNS code.

If this check box is not selected, the Spread Annual to Periods program does not distribute annual budget amounts for accounts that are assigned the DNS code. You must distribute the amounts manually.

Prevent Creation of Journal Entry

Select this check box to specify whether the system should prevent journal entries from being created for this ledger. You receive an error if you attempt to prevent the creation of journal entries for the AA, CA, or AZ ledgers.

Upper

Enter the first line of description used in column headings on a report or form. This description should be no larger than the data item size, if possible. If the column heading is only one line, it should be placed in this column. Use the second line of the Column Title when one is not sufficient.

Lower

Enter the second line of description used in column headings on a report or form. This description should be no larger than the data item size, if possible. If the column heading is only one line, it should be placed in the first column.