Automatic Account and Basis Amount Generation

Depending on the number of accounts for which you forecast budget amounts, running the Generate Forecast Basis program (R1403) might be more efficient than using the Revise Forecast Basis program to manually enter account information.

The Generate Forecast Basis program automatically updates the F1403 table with a range of accounts, based on AAI item GLGxx for expense and revenue, and basis amounts from the F0902 table. In the processing options, you specify the revision number, the ledger type, the fiscal year, the range of periods, and whether to roll up subledger balances.

You can also retrieve account balances for up to 12 or 14 consecutive periods for one or two fiscal years and ledger types. For example, you could retrieve balances from periods 01 through 06 for fiscal year 05 and ledger type AA, and periods 07 through 12 for fiscal year 06 and ledger type BA. Alternatively, you could retrieve balances for fiscal years 05 and 06 for the same ledger type.