Understanding the Refresh Cash Forecast Data Program
You must refresh the data in the Cash Forecast Data table (F09522) so that you have the most current information available when you analyze and forecast amounts for your cash accounts using the Cash Forecast Analysis program (P09522). You can refresh your data for a fiscal period, as well as daily or weekly.
When you run the Refresh Cash Forecast Data program (R00522), you specify in the processing options a based-on date and the future number of days in which to create cash forecast data. The system then calculates the ending date. To refresh data from the JD Edwards EnterpriseOne Accounts Receivable, JD Edwards EnterpriseOne Accounts Payable, and JD Edwards EnterpriseOne General Accounting systems in the F09522 table, you specify a version for each of these programs:
Extract A/R Cash Forecast Data (R03B522).
Extract A/P Cash Forecast Data (R04522).
Extract G/L Cash Forecast Data (R09522).
The extraction programs perform these tasks:
Retrieve active cash type rules for AR, AP, and GL from the F09521 table.
Extract cash forecast detail from the F03B11, F0411, and F0911 tables.
Refresh the F09522 table with new cash forecast records.
For each cash type, the Refresh Cash Forecast Data program refreshes the F09522 table with summarized amounts for active cash types by bank account and due date. If more than one bank account or due date meets the selection criteria for a cash type, the program produces multiple summarized amounts. For each unique bank account ID in the F09522 table, the Refresh Cash Forecast Data program creates a bank account record 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.
You can set a processing option to purge existing cash forecast records for prior based-on dates. The system purges the data in the F09522 table before it refreshes the table with the new cash forecast data.
The Cash Forecast Data Refresh program refreshes the F09525 table with bank accounts from all GL cash type rules, and not only for cash type rules in the reporting structure.