Processing Average Balances Concept Processing Average Balances Processing
Processing Average Balances Concept
Processing Average Balances
Processing Average Balances Step 1 Begin by navigating to the ADB Process Request page. Click the Scroll Down button.
Processing Average Balances Step 2 Click the General Ledger menu.
Processing Average Balances Step 3 Click the Average Daily Balance menu.
Processing Average Balances Step 4 Click the ADB Process menu.
Processing Average Balances Step 5 Use the ADB Process page to process the ADB ledgers according to the ADB defintiions as well as the parameters that you specify on the run control.
Processing Average Balances Step 6 You can run this process by searching for an existing Run Control ID or you can add a new value. Creating a Run Control ID that is relevant to the process may help you remember it for future use. Click the Add a New Value tab.
Processing Average Balances Step 7 Enter the desired information into the Run Control ID field. Enter "ADBMTD 1".
Processing Average Balances Step 8 Click the Add button.
Processing Average Balances Step 9 Use the ADB Process Request page to identify the business unit, ADB definition, and period type of the ADB you want to process. You also can specify if you want to recalculate existing average daily balances.
Processing Average Balances Step 10 Use the Process Frequency field to define the process frequency for running the ADB process request. Click the Process Frequency list.
Processing Average Balances Step 11 Click the Always list item.
Processing Average Balances Step 12 Use the ADB field to enter the ADB definition. This field works in combination with the Period Type field to determine which calculation method the system uses. Click in the ADB field.
Processing Average Balances Step 13 Enter the desired information into the ADB field. Enter "LOCALMTD".
Processing Average Balances Step 14 Use the Request Type field to select one of the following options: • Calc Each Per (calculate for each period): Generate average daily balances for multiple periods, one for each day of the reporting period. • Calc End of Per (calculate for period end date): Calculate the average daily balance for only one period. The average balance is for the period end date.
Processing Average Balances Step 15 Use the Period Type field to define the time period for the ADB calculation. In combination with the ADB field, this field determines which calculation method the system uses. Values are: • DTD (date to date) • MTD (month to date) • QTD (quarter to date) • Reg Date (regular date) • Reg Per (regular period) • YTD (year to date)
Processing Average Balances Step 16 Click the Period Type list.
Processing Average Balances Step 17 Click the Month to Date list item.
Processing Average Balances Step 18 Use the Request Date Option list to specify the date option for the ADB process. Values are: • As-Of Date: Uses the date that you specify in the As of Date field, which appears when you select this option. If As of Date is selected in the Request Date Option field, then the As of Date field and Update As Of Date button appear above the Process Request group box. Click the Update As Of Date button to update the as-of date globally for requests that use the As-Of Date option. If you want to update the as-of date for only one ledger, use the as-of date in the process request row. • Process Date: Uses the process date of the business unit as the request date for the ADB process. • SYSDATE: Uses the system date as the request date for the ADB process.
Processing Average Balances Step 19 Use the Tree Date Optn (tree date option) list to select the effective date of the tree used to select the Chart. Field values to be processed. Values are: • Use End. Dt (use period end date): Sets the effective date to the end of the accounting period. • Use Over. Dt (use override date): Activates a field in which you can enter a date other than the period end date.
Processing Average Balances Step 20 Select the Adhoc option if you want to recalculate average balances using the ad hoc method.
Processing Average Balances Step 21 Click the Run button.
Processing Average Balances Step 22 Use the Process Scheduler Request page to enter or update parameters, such as server name and process output format.
Processing Average Balances Step 23 You must select a Server Name to identify the server on which the process will run. If you use the same Run Control ID for subsequent processes, the server name that you last used will appear by default in this field. Click the Server Name list.
Processing Average Balances Step 24 Click the PSNT list item.
Processing Average Balances Step 25 Click the OK button.
Processing Average Balances Step 26 Note that a Process Instance number appears. This number helps you identify the process you have run when you check its status.
Processing Average Balances Step 27 Click the Process Monitor link.
Processing Average Balances Step 28 Use the Process List page to view the status of submitted process requests.
Processing Average Balances Step 29 The process is finished when the Run Status is Success. If the status has not completed, continue to click the Refresh button until the Run Status is Success.
Processing Average Balances Step 30 You have successfully identified the business unit, ADB definition, and period type for processing average daily balances. End of Procedure.
- Slides: 32