Preparing Your System for Average Daily Balancing

To prepare your system for average daily balancing, use the ADB Definition component (ADB_DEFN).

This section discusses how to:

Identify the ledgers.
Identify rounding adjustments.
Identify the ChartFields.

Pages Used to Set Up Average Balances

Page Name	Definition Name	Navigation	Usage
ADB Definition - Definition (average daily balance definition - definition)	ADB_DEFN	General Ledger, Average Daily Balance, ADB Definition	Identify the ledgers and their amount fields to be used in the definition.
ADB Definition - Rounding Adjustment (average daily balance definition - rounding adjustment)	ADB_ADJ	General Ledger, Average Daily Balance, ADB Definition, Rounding Adjustment	Identify the ChartFields in which the ADB rounding adjustment is stored. When averages are calculated from balanced ledger data, the calculated averages may not be in balance because of rounding. However, daily balances must be balanced. The ADB process creates rounding adjustments in order to bring the calculated averages back into balance.
ADB Definition - ChartFields (average daily balance definition - ChartFields)	ADB_CF	General Ledger, Average Daily Balance, ADB Definition, ChartFields	Identify the ChartField values from the ADB ledger that you include in the average balance calculations.

ADB Definition - Definition page

Use the ADB Definition - Definition (average daily balance definition - definition) page (ADB_DEFN) to identify the ledgers and their amount fields to be used in the definition.

Navigation

General Ledger, Average Daily Balance, ADB Definition

Image: ADB Definition page

This example illustrates the fields and controls on the ADB Definition page. You can find definitions for the fields and controls later on this page.

ADB Type (average daily balance type)

Select from the following values:

Management Balances: Calculates ADB from the daily balances posted from the ADB date.

Regulatory Balances: Calculates the ADB from the daily balances posted from the journal date.

Ledger

Enter the name of the detail ledger associated with the ADB ledger.

Target Ledger

Select the ledger that stores average balances. (You must have created this ledger using the Detail Ledger, Detail Ledger Group, and Ledgers For A Unit pages.

Batch Work Record

Enter the name of the temporary table used during the ADB Calculation process. The default work table is LED_ADBTG_TAO

Adjustment Period Option

Select whether the ADB calculation includes the Period 998 balances. Values are:

As First Day of Report Period: The system treats the period 998 balances as the first day of the report period's transaction (based on period type) and includes the balances in the ADB calculation.

As Last Day of Report Period: The system treats the Period 998 balances as the last day of the report period's transaction (based on period type) and includes the balances in the ADB calculation.

No Adjustment Period: The ADB calculation does not include period 998 balances.

Map Amount Fields

This section connects the Amount field of the ADB ledger to the target ADB ledger's amount, ending balance, and aggregate amount fields. Refresh returns default amount fields for the posted transaction amount, posted total amount, and posted base amount fields. You can map up to three amount fields.

Ledger ADB Amount (ledger average daily balance amount)

Displays the column in the ADB Amount Record table where the system stores daily balances for this ledger.

When you click the Refresh button, all the amount fields for the ADB ledger appear. Click the Remove button to delete the amount fields for which you do not want to create average balances.

Target ADB Amount (target average daily balance amount)

Displays the column in the target ledger's table where the system stores the average balance.

Target Ending Balance

Displays the column in the target ledger's table where the system stores the ending balance.

Target Aggregate Amount

Displays the column in the target ledger's table where the system stores the aggregate amount.

ADB Definition - Rounding Adjustment Page

Use the ADB Definition - Rounding Adjustment (average daily balance definition - rounding adjustment) page (ADB_ADJ) to identify the ChartFields in which the ADB rounding adjustment is stored.

When averages are calculated from balanced ledger data, the calculated averages may not be in balance because of rounding. However, daily balances must be balanced. The ADB process creates rounding adjustments in order to bring the calculated averages back into balance.

Navigation

General Ledger, Average Daily Balance, ADB Definition, Rounding Adjustment

Image: ADB Rounding Adjustment page

This example illustrates the fields and controls on the ADB Rounding Adjustment page. You can find definitions for the fields and controls later on this page.

Balanced ADB (balanced average daily balance)

Select this check box to have the system automatically verify whether selected ledger amounts balance and to adjust average balance calculations for rounding discrepancies. The system also records related adjustments to the value of the rounding adjustment entry ChartField that you specify. To record average balances without automatic rounding adjustments, deselect the Balanced ADB check box.

Note: If the Balanced ADB check box is selected, and the ADB Calculation process determines that the ADB is not balanced based on the ChartFields specified in the ADB Definition setup, the ADB Calculation process issues the following message and the target ledger is not updated: "Ledger amounts for ChartFields specified in the ADB (target ledger) is not balanced. Important! You must check the Batch Message Log to view this message."

ChartField

Locate the ChartField to use for automatic rounding adjustments.

ChartField Value

Specify a value for the ChartField to use for automatic rounding adjustments.

ADB Definition - ChartFields Page

Use the ADB Definition - ChartFields (average daily balance definition - ChartFields) page (ADB_CF) to identify the ChartField values from the ADB ledger that you include in the average balance calculations.

Navigation

General Ledger, Average Daily Balance, ADB Definition, ChartFields

Image: ADB Definition - ChartFields page

This example illustrates the fields and controls on the ADB Definition - ChartFields page. You can find definitions for the fields and controls later on this page.

Click this button to retrieve all the ChartFields defined for the ADB ledger (the source ledger). Click View All to display all of the ChartFields.

The ADB calculation process creates an average balance for every ChartField combination listed. Click the Remove button (next to the Detail Ledger ChartField field) to delete unwanted ChartFields.

For example, if your ledger has Account, Department, Product, Program, and Project ChartFields, but you want to have only average balances for Account/Department/Product ChartField combinations, delete the Program and Project ChartFields.

ADB ChartFields (average daily balance ChartFields)

Use to associate the ADB ledger ChartField with the target ADB ledger ChartField.

Detail Ledger ChartField

Enter the ChartField of the target ADB ledger associated with the ChartField of the ADB ledger.

How Specified

Specify how the ChartField values are to be summarized for use in the ADB Calculation process.

All Detail Values

Include all detail values of the selected ChartField.

Selected Detail Values

Summarizes the detail ChartField values that you select in the Value field in Specify Values/Range of Values/Tree Node group box.

Range of Values

Summarizes the range of values that you select in the Value and To Value fields in the Specify Values/Range of Values/Tree Node group box.

Detail - Selected Parents

Activates the Tree and Level fields in which you can select a tree name and level name (for trees with levels). Summarizes the values rolled up by the parent node that you select in the Specify Values/Range of Values/Tree Node group box.

Selected Tree Nodes

Activates the Tree and Level fields in which you can select a tree name and level name (for trees with levels). Summarizes the values rolled up by the tree node that you select in Value in the Specify Values/Range of Values/Tree Node group box.

Children at a Level

Activates the Tree and Level fields in which you can select a tree name and level name (for trees with levels). Summarizes every node at the specified level that is a child of the parent node that you select in the Specify Values/Range of Values/Tree Node group box.

All Nodes at Selected Levels

Activates the Tree and Level fields in which you can select a tree name and level name (for trees with levels). Summarizes every node at the specified level.

Tree

Enter a tree name if you are using trees to select your ChartField values for ADB processing.

Level

Enter a level if you are using trees to select your ChartField values for ADB processing, and the tree that you selected uses levels.

Value

Enter the tree node or ChartField value to use for ADB processing.

To Value

If you selected Range of Values in the How Specified group box, enter the to value of the range here.