Defining the Average Daily Balance Concept Defining the
Defining the Average Daily Balance Concept
Defining the Average Daily Balance
Defining the Average Daily Balance Step 1 Begin by navigating to the Definition page. Click the Scroll Down button.
Defining the Average Daily Balance Step 2 Click the General Ledger menu.
Defining the Average Daily Balance Step 3 Click the Average Daily Balance menu.
Defining the Average Daily Balance Step 4 Click the ADB Definition menu.
Defining the Average Daily Balance Step 5 Click the Add a New Value tab.
Defining the Average Daily Balance Step 6 Click in the Average Daily Balances field.
Defining the Average Daily Balance Step 7 Enter the desired information into the Average Daily Balances field. Enter "LOCMTD".
Defining the Average Daily Balance Step 8 Click the Add button.
Defining the Average Daily Balance Step 9 Use the Definition page to identify the ledgers and their associated amount fields to be used in the definition.
Defining the Average Daily Balance Step 10 Use the Description field to enter a short description that identifies this ADB definition. Enter the desired information into the Description field. Enter "Local month to date averages".
Defining the Average Daily Balance Step 11 Click in the Comments field.
Defining the Average Daily Balance Step 12 Enter the desired information into the Comments field. Enter "Local month to date averages".
Defining the Average Daily Balance Step 13 Use the Ledger field to select the detail ledger that is to be associated with the ADB Target Ledger.
Defining the Average Daily Balance Step 14 Use the Date Code field to specify how the average daily balance is calculated. Select from the following values: • ADB Date: Calculates ADB from the daily balances posted from the ADB date. • Trade Date: Calculates ADB from the daily balances posted from the journal date. • Settlement Date: Calculates ADB from the daily balances posted from the settlement date.
Defining the Average Daily Balance Step 15 Use the Ledger field to specify the name of the detail ledger associated with the ADB ledger. Click in the Ledger field.
Defining the Average Daily Balance Step 16 Enter the desired information into the Ledger field. Enter "LOCAL".
Defining the Average Daily Balance Step 17 Use the Target Ledger field to specify the name of the ledger, which is used to store average balances. You must have created this ledger using the Detail Ledger, Detail Ledger Group, and Ledgers For A Unit pages. Click in the Target Ledger field.
Defining the Average Daily Balance Step 18 Enter the desired information into the Target Ledger field. Enter "LOCALMTD".
Defining the Average Daily Balance Step 19 Use the Work Record field to specify the name of the temporary table used during the ADB calculation process. The default work table is LED_ADBTG_TAO.
Defining the Average Daily Balance Step 20 Use the Adjustment Period Option list to specify whether the ADB calculation includes period 901. . . 998 balances. Select from these values: • As First Day of Report Period: The system treats adjustment period balances as the first day of the report period transaction (based on period type) and includes the balances in the ADB calculation. • As Last Day of Report Period: The system treats adjustment period balances as the last day of the report period 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.
Defining the Average Daily Balance Step 21 Click the Default button to populate the Map Amount Fields section automatically. The system will return default values for the Posted Transaction Amount, Posted Total Amount, and Posted Base Currency Amount fields. You can map no more than three fields. Click the Default button.
Defining the Average Daily Balance Step 22 The Map Amount Fields section connects the Amount field of the ADB ledger to the target ADB ledger amount, ending balance, and aggregate amount fields.
Defining the Average Daily Balance Step 23 Click the Rounding Adjustment tab.
Defining the Average Daily Balance Step 24 Use the Rounding Adjustment page to identify the Chart. Fields where the average daily balance rounding adjustment will be stored.
Defining the Average Daily Balance Step 25 Use the Balanced ADB option to have the system automatically verify whether selected ledger amounts balance and to adjust average balance calculations for rounding discrepancies. The system records related adjustments to the value of the rounding adjustment entry Chart. Field that you specify. To record average balances without automatic rounding adjustments, deselect the Balanced ADB option.
Defining the Average Daily Balance Step 26 If the Balanced ADB option is selected and the ADB Calculation process determines that the ADB is not balanced based on the Chart. Fields specified in the ADB Definition setup, then the ADB Calculation process issues the following message and the target ledger is not updated: “Ledger amounts for CHARTKEYS specified in the ADB (target ledger) are not balanced. Important! You must check the Batch Message Log to view this message. ”
Defining the Average Daily Balance Step 27 Click the Chart. Fields tab.
Defining the Average Daily Balance Step 28 Use the Chart. Fields page to identify the Chart. Field values from the source ledger. You need to include these values in average balance calculations.
Defining the Average Daily Balance Step 29 Click the Refresh button to retrieve all the Chart. Fields defined for the ADB ledger (the source ledger). Click the Refresh button.
Defining the Average Daily Balance Step 30 The ADB calculation process creates an average balance for every Chart. Field combination listed. To see all of the Chart. Fields, you can click the View All link.
Defining the Average Daily Balance Step 31 Use the Source Chart. Field field to specify the Chart. Field of the target ADB ledger associated with the Chart. Field of the ADB ledger.
Defining the Average Daily Balance Step 32 Use the How Specified section to specify how the Chart. Field values will be summarized for use in the ADB Calculation process.
Defining the Average Daily Balance Step 33 Use the Selection list to include all detail values of the selected Chart. Field.
Defining the Average Daily Balance Step 34 Click the Selection list.
Defining the Average Daily Balance Step 35 The Selection dropdown list values include : • All Nodes at Selected Levels - to activate the Tree and Level fields, where you can select a tree name and level name (for trees with levels). Selecting this value summarizes every node at the specified level. • Children at a Level - to activate the Tree and Level fields, where you can select a tree name and level name (for trees with levels). Selecting this value 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. Continued. .
Defining the Average Daily Balance Step 36 The other Selection drop down list values also include : • Range of Values - to summarize 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. • Selected Detail Values - to summarize the detail Chart. Field values that you select in the Value field in the Specify Values/Range of Values/Tree Node group box. • Selected Tree Nodes - to activate the Tree and Level fields, where you can select a tree name and level name (for trees with levels). Selecting this value summarizes the values rolled up by the tree node that you select in Value in the Specify Values/Range of Values/Tree Node
Defining the Average Daily Balance Step 37 Select the Detail - Selected Parents value to activate the Tree and Level fields, where you can select a tree name and level name (for trees with levels). Selecting this option summarizes the values rolled up by the parent node that you select in the Specify Values/Range of Values/Tree Node group box. Click the Detail - Selected Parents list item.
Defining the Average Daily Balance Step 38 Use the Tree field to enter a tree name if you are using trees to select your Chart. Field values for ADB processing. Click in the Tree field.
Defining the Average Daily Balance Step 39 Enter the desired information into the Tree field. Enter "ACCTROLLUP".
Defining the Average Daily Balance Step 40 Use the Value field to enter the tree node or Chart. Field value to use for ADB processing. Click in the Value field.
Defining the Average Daily Balance Step 41 Enter the desired information into the Value field. Enter "BALSHEET".
Defining the Average Daily Balance Step 42 Click the Show next row link.
Defining the Average Daily Balance Step 43 Click the Delete Row button to delete unwanted Chart. Fields. For example, if your ledger has Account, Department, Product, Program, and Project Chart. Fields but you want average balances only for Account, Department, and Product Chart. Field combinations, then you would delete the Program and Project Chart. Fields. For this example, delete the Alternate Account Chart. Field. Click the Delete row link.
Defining the Average Daily Balance Step 44 Click the OK button.
Defining the Average Daily Balance Step 45 Click the Source Chart. Field list.
Defining the Average Daily Balance Step 46 Click the Currency Code list item.
Defining the Average Daily Balance Step 47 Click the Selection list.
Defining the Average Daily Balance Step 48 Use the Selected Detail Values option to summarize the detail Chart. Field values you select in the Value field. Click the Selected Detail Values list item.
Defining the Average Daily Balance Step 49 Click in the Value field.
Defining the Average Daily Balance Step 50 Enter the desired information into the Value field. Enter "USD".
Defining the Average Daily Balance Step 51 Click the Save button.
Defining the Average Daily Balance Step 52 You have successfully specified the ledgers and Chart. Fields to use while defining an average daily balance. End of Procedure.
- Slides: 54