Performing Ongoing Administration Tasks
Perform these administrative tasks as needed on an ongoing basis.
- Load the bank balance on an ongoing basis to the OCF_Bank
Balance member for the Actual scenario. For
example, if you want to forecast starting from tomorrow, load the closing bank
balance as of today as the bank balance.
Predictive Cash Forecasting provides two methods for loading OCF_Bank Balance:
- Forms
- .
csv
templates
You can use one of the following forms to load OCF_Bank Balance:
- OCF_Periodic Bank Balance
- OCF_Daily Bank Balance
The rules associated with these forms convert the date entered in the form to the corresponding period in the Predictive Cash Forecasting application.
Alternatively, you can use the provided templates to simplify loading the data:
DailyBankBalance.csv
WeeklyBankBalance.csv
MonthlyBankBalance.csv
When you run OCF_Daily Process Forecast or OCF_Periodic Process Forecast, the rule converts the date entered in these templates to the corresponding period in the Predictive Cash Forecasting application.
- Any time you change the current year in Forecast Range Setup, you must refresh the reporting hierarchy to fully populate the Period dimension hierarchies. From the Home page, click Application and then click Configure. From the Actions menu, select Refresh Reporting Hierarchy.
-
As Cash Managers and Controllers make adjustments to forecast numbers, run the rules and data maps on a regular basis. If you are working with multiple currencies, make sure to run the currency-related conversion and rollup rules and data maps. (See Setting Up Currencies.)