Extract G/L Cash Forecast Data Program

The Extract G/L Cash Forecast Data program extracts posted account balances from the F0911 and F0902 tables for each account that is associated with an active GL cash type rule for the based-on date balance. It does not include non-posting accounts or inactive accounts. The program increases the based-on date in a processing option by one day to derive an adjusted date and then retrieves posted F0911 transactions for the cash type rules using that adjusted date. Then the program refreshes the F09522 table with new GL cash forecast records using the adjusted date.

The program repeats this process until it has written records for the bank accounts for all days greater than or equal to the based-on date and all days less than or equal to the ending date. Then, it resets the adjusted date to the based-on date and repeats the process for the next GL cash type. If the program finds an account with a zero balance, it writes the zero balance to the F09522 table for the based-on date.

The program always writes the based-on date balance for each bank account to the F09522 table. This balance is used as the beginning book balance for the bank account, even if it is zero. However, for subsequent adjusted dates after the based-on date, the program does not write records to the F09522 table for an adjusted date if the F0911 transactions are not posted. The program writes net F0911 amounts for adjusted dates to the F09522 table only if there are posted F0911 transactions for that specific date. When you access the Cash Forecast Analysis program, any F0911 net amounts on adjusted dates are accumulated and applied to one of these balances:

• The based-on date book balance in the F09522

• The based-on date bank statement balance in the F09616 and F09617 tables.

You specify the based-on date to use for the opening balance in a processing option for the Cash Forecast Analysis program.