Extract A/R Cash Forecast Data and Extract A/P Cash Forecast Data Programs

The Extract A/R Cash Forecast Data program extracts open invoices with amounts that are not equal to 0, pay status not equal to P (paid), and a posted code D (posted) for active AR cash type rules from the F03B11 table. The Extract A/P Cash Forecast Data program extracts open vouchers with amounts that are not equal to 0 and a pay status that is not equal to P (paid) for active AP cash type rules from the F0411 table.

To determine which open invoices and vouchers to include in your cash forecast data, you specify a based-on date and a future number of days in the processing options. Invoices and vouchers with due dates that are between the beginning and ending dates are included in your cash forecast data.

Depending on whether a cash type has the Past Due option selected, one of these situations applies:

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

    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 as well as transactions that are greater than or equal to the oldest past due date and writes new AR and AP cash forecast records to the F09522.

  • If a cash type does not have the Past Due option selected, the program chooses 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 AR and AP cash forecast records to the F09522.