Rebuilding average daily balance
Run this action to rebuild the average daily balance reports.
Caution:
Rebuilding removes
existing average daily balance records permanently. This action cannot be
undone.
- Select Financials > Global Ledger > Processing > Average Daily Balance > Rebuild Average Daily Balance.
- Specify this information:
- Finance Enterprise Group
- Select the finance enterprise group for which to rebuild average daily balance records. The finance enterprise group from the user context is the default value.
- Rebuild Option
-
Select the rebuild option:
- Reset ADB: Purge all existing daily balance and aggregate balance records from database. This option also resets the last run date to its initial state. After resetting, you must run average daily balance as if running it for the first time. You can also clear the Average Daily Balance check box for the reporting basis.
- Rebuild ADB for URE: Rebuild average daily balances for your URE account. Perform this action if transactions have been posted before turning on URE inclusion to average daily balance calculation.
- Rebuild ADB Account: Rebuild average daily balances for an account.
- Rebuild Previous Year ADB: Rebuild average daily balances for a previous year.
- Rebuild Current Year ADB: Rebuild average daily balances for the current year.
- Reporting Basis
- Select a basis for which to rebuild average daily balances if you selected one
of these rebuild options:
- Rebuild ADB for URE
- Rebuild ADB Account
- Rebuild Previous Year ADB
- Rebuild Current Year ADB
- Fiscal Year
- Select a fiscal year to update if you selected one of these rebuild options:
- Rebuild ADB for URE
- Rebuild ADB Account
- Rebuild Previous Year ADB
- Accounting Entity
- If you selected Rebuild ADB Account for the Rebuild Option, select the accounting entity.
- Account
- If you selected Rebuild ADB Account for the Rebuild Option, select the account.
- Accounting Unit
- If you selected Rebuild ADB Account for the Rebuild Option, select the accounting unit. This field is displayed if your average daily balance selection is Account and Accounting Unit in your finance enterprise group setup.
- Dimension 1
- If you selected Rebuild ADB Account for the Rebuild Option, select the accounting unit. This field is displayed if your average daily balance selection is Account and Dimension 1 in your finance enterprise group setup.
- Click Submit.