Copying a Budget Concept Copying a Budget Copying
Copying a Budget Concept
Copying a Budget
Copying a Budget Step 1 Begin by navigating to the Pool page. Click the Scroll Down arrow.
Copying a Budget Step 2 Click the General Ledger menu.
Copying a Budget Step 3 Click the Maintain Standard Budgets menu.
Copying a Budget Step 4 Click the Budget Copy Definition menu.
Copying a Budget Step 5 Click the Add a New Value tab.
Copying a Budget Step 6 Click in the Process Step field.
Copying a Budget Step 7 Enter the desired information into the Process Step field. Enter "CLASSD".
Copying a Budget Step 8 Click the Add button.
Copying a Budget Step 9 Use the Pool page to specify the pool records, selection criteria, and method for the copy. You can copy or update an entire ledger or any combination of Chart. Field values from a source ledger to an unbalanced ledger within the same business unit. After you set up the pages in the Budget Copy Definition component, you save and then reuse them.
Copying a Budget Step 10 Use the Effective Date field to define the date from which this record is valid. It defaults to the current system date, but can be overridden if necessary. Click in the Effective Date field.
Copying a Budget Step 11 Use the Effective Date field to define the date from which this record is valid. The default is the current system date, but you can override this value. Enter the desired information into the Effective Date field. Enter "01/01/2013".
Copying a Budget Step 12 Click in the Description field.
Copying a Budget Step 13 Enter the desired information into the Description field. Enter "Copy from Budgets to Initial".
Copying a Budget Step 14 Use the Ledger field to enter or select the source ledger for the new budget. Click in the Ledger field.
Copying a Budget Step 15 Enter the desired information into the Ledger field. Enter "BUDGETS".
Copying a Budget Step 16 Use the Time. Span field to specify the period, relative to the current fiscal year and accounting period, for which to retrieve source records. Enter a single or multi-period time span to determine the accounting periods to use for the copy. Use relative time spans, such as PER (current period activity), to retrieve amounts relative to the specified date. Use ALLYEAR to specify a year. Click in the Time. Span field.
Copying a Budget Step 17 Enter the desired information into the Time. Span field. Enter "ALLYEAR".
Copying a Budget Step 18 Use the Pool factor field to enter a factor that the system uses to increase or decrease the amounts copied to the target ledger. You can enter positive or negative values. For example, to increase 1, 000. 00 USD to 1, 100. 00 USD (10 percent), enter 10; to decrease the amount by 10 percent, enter – 10.
Copying a Budget Step 19 Use the Pool Fields grid to select the field name that the system uses to select rows from the pool record to be copied. The pool record name is the same as the ledger record name defined in the ledger template. If the pool record uses a subrecord to define the Chart. Fields, then the prompt table for the field name does not list these Chart. Fields. However, you still can enter the Chart. Fields. When you save the budget copy definition, the system checks the record to validate the field name you entered.
Copying a Budget Step 20 You need to add an additional pool field. Click the Add a new row button.
Copying a Budget Step 21 Use the Field Name list to specify a field name for the system to use when it selects only certain pool rows from the pool record for copying. Click the Field Name list.
Copying a Budget Step 22 Click the Account list item.
Copying a Budget Step 23 The How Specified section enables you to specify individual pool field values, use trees to select Chart. Field values from specified levels and nodes, or specify a range of field values. Use trees whenever possible to reduce future maintenance in case your Chart. Field values change.
Copying a Budget Step 24 Select the Selected Detail Values option to use detail values.
Copying a Budget Step 25 Select the Selected Tree Nodes option to activate the tree information fields. Click the Selected Tree Nodes option.
Copying a Budget Step 26 The Tree Type field defines the tree information for the pool field. The default value is Detail. You select Detail to enter a range of detail values for a node. You select Dynamic to include the range of detail values defined by a table in the database.
Copying a Budget Step 27 For this example, accept the default value.
Copying a Budget Step 28 Enter each tree node. The tree level is optional. If the tree has levels, you can limit prompting in this field to selected levels. Click in the Tree field.
Copying a Budget Step 29 Enter the desired information into the Tree field. Enter "ACCTROLLUP".
Copying a Budget Step 30 Select the Range of Values option to activate the From and To fields to enter the start and end pool field values. If you leave the From field blank, the system selects all pool field values that are less than or equal to the value in the To field. Do not leave the To field blank. If the field is blank, the system uses the lowest possible value.
Copying a Budget Step 31 The fields in the Specify Values/Range of Values/Tree Nodes grid define the value, node, or range of values for the pool field. This grid enables you to enter multiple entries.
Copying a Budget Step 32 Click in the Value field.
Copying a Budget Step 33 Enter the desired information into the Value field. Enter "EXPENSES".
Copying a Budget Step 34 Click the Target tab.
Copying a Budget Step 35 Use the Target page to specify the destination for the copy of the target records and field values.
Copying a Budget Step 36 The fields in the Target Record section identify the target ledger, time span, and time span option for the effective date shown.
Copying a Budget Step 37 Use the Ledger field to specify the target ledger to update. The system populates the Specify Field Values grid with the target ledger Chart. Fields. Changing the value in the Ledger field causes the data in the target fields to be deleted as the new values are populated. To ensure a one-to-one copy, all Chart. Fields that are common to both the target ledger and the pool ledger must appear in the Specify Field Values grid, and the value in the Source field must be Pool. Click in the Ledger field.
Copying a Budget Step 38 Enter the desired information into the Ledger field. Enter "BUDGETS".
Copying a Budget Step 39 Use the Time. Span field to specify the time span for the target ledger. For this example, you are copying the 2006 budget to 2007. Click in the Time. Span field.
Copying a Budget Step 40 Enter the desired information into the Time. Span field. Enter "ALLYEAR+1".
Copying a Budget Step 41 The fields in the Specify Field Values grid identify the target field names and the source of the values. To ensure a one-to-one copy, all Chart. Fields that are common to both the target ledger and the pool ledger must appear in the Specify Field Values grid, and the value in the Source field must be Pool.
Copying a Budget Step 42 The Field Name field displays the Chart. Field names from the target ledger specified in the Ledger field.
Copying a Budget Step 43 In the Source field, select Pool to copy the field from the source ledger. Select Value if the defined target field does not already exist in the target ledger. If you select Value, the Field Value field appears.
Copying a Budget Step 44 Click the View All link.
Copying a Budget Step 45 Click the vertical scrollbar.
Copying a Budget Step 46 The Scenario field, which is the target field, exists only in the budget ledger. Therefore, you cannot derive its value from the pool. You need to change its source to Value. Click the Source list.
Copying a Budget Step 47 Click the Value list item.
Copying a Budget Step 48 You need to copy from Budgets to Initial, therefore, you need to enter Initial in the Field Value field. Click in the Field Value field.
Copying a Budget Step 49 Enter the desired information into the Field Value field. Enter "INITIAL".
Copying a Budget Step 50 Use the Source field to specify the source for the Ledger field. Click the Source list.
Copying a Budget Step 51 Click the Value list item.
Copying a Budget Step 52 When you specify Value as the source for the Ledger field, the Field Value field is already specified.
Copying a Budget Step 53 Click the Save button.
Copying a Budget Step 54 You successfully created a budget copy definition by identifying the pool records, selection criteria, and copy method for the new budget. End of Procedure.
- Slides: 56