1. Accounts Receivable Implementation Guide
  2. Understanding the Refresh Cash Forecast Data Program

Understanding the Refresh Cash Forecast Data Program

When you run the Refresh Cash Forecast Data program (R00522), specify a version for these programs:

The Extract A/R Cash Forecast Data and Extract A/P Cash Forecast Data programs perform these tasks:

  • Retrieve active cash type rules for A/R and A/P from the Cash Type Rules table (F09521)

  • Extract open invoices with amounts that are not equal to 0, pay status not equal to P (paid), and a posted code D (posted), as well as posted code not equal to D and a revision of 1 from the F03B11 table.

  • Extracts open vouchers with amounts that are not equal to 0 and a pay status that is not equal to P (paid) from the F0411 table.

    To determine which open invoices and vouchers to include in the cash forecast data, the system uses processing options for the beginning and ending dates. You specify the beginning date in the Based On Date processing option. Based on the value that you specify for the Future Number of Days processing option, the system calculates the ending date. Invoices and vouchers with due dates that are between the beginning and ending dates are included in the cash forecast data.

  • Depending on whether a cash type has the Past Due option activated, do one of the following:

  • If a cash type has the Past Due option selected, the program selects due dates that are less than the based on date specified in a processing option as follows:

    The program adjusts the based-on date by the negative beginning number and the negative ending number of past-due days to derive the most recent past-due date and the oldest past-due date, respectively. The program selects transactions with due dates that are less than or equal to the most recent past-due date and transactions that are greater than or equal to the oldest past-due date and writes new A/R and A/P cash forecast records to the F09522 table.

  • If a cash type does not have the Past Due option selected, the program selects due dates that are greater than or equal to the based-on date specified in a processing option and less than or equal to the ending date and writes new A/R and A/P cash forecast records to the F09522 table.

  • For each cash type code, refresh the F09522 table with new cash forecast records that include summarized amounts by bank account and due date

The extraction programs take a conservative approach to cash forecasting. The extraction program for A/P forecasts amounts without including estimated discounts.