1. General Accounting Implementation Guide
  2. Understanding Cash Forecast Information

Understanding Cash Forecast Information

After you refresh the F09522, you can view cash forecast amounts for one bank account or all bank accounts using the Cash Forecast Analysis program (P09522). This program provides both an online inquiry and a report that uses the refreshed data in the F09522 table, as well as this information:

  • The report structure that you defined in the F09523 table.

  • The rules that you set up for active cash types F09521 table.

  • The bank account number in the F09525 table.

    The system accesses information in the F09525 table if you use the Search button to locate a bank account number on the Cash Forecast Analysis form. If no bank accounts exist in the F09525 table, the system accesses account master information in the F0901 table instead.

The summarized amounts that appear on the Cash Forecast Analysis form and Cash Forecast Report (R095221) correspond to the based-on date that you refreshed your data. You can view the summarized amounts by day, week, or period.

If you set up cash type rules for past-due items, the system displays the past-due amounts in a separate column or combined with the amounts in the first date column, according to the rules. If you choose, you can hide the column and amounts. If you specify a weight factor for cash type rules, you can optionally view amounts with the weight factor adjustments applied to the actual amounts.

The contents of the Cash Forecast Analysis form and the Cash Forecast Report are basically the same. The report prints all detail information as if the tree structure on the Cash Forecast Analysis form is expanded at all levels, regardless of whether all levels are expanded. If the form is set to hide past due amounts, the report does not include past due cash types. You can print the report from the Cash Forecast Analysis form by selecting Print from the Report menu. The report retrieves information from the Cash Forecast Detail table (F09UI017). This table is not populated with cash forecast data until you actually select Print from the Report menu. Because of this, there might be a delay between the time you select Print and the time the report processes. The report prints data from the F09U1017 table and then subsequently deletes the table when the report finishes processing.