82 Forecast A/P Cash Flow
This chapter contains the following topic:
82.1 Forecasting A/P Cash Flow
From Accounts Payable (G04), enter 27
From A/P Advanced & Technical Operations (G0431), choose A/P Cash Forecasting
A/P Cash Forecasting is a DREAM Writer program that generates a Cash Summarization table (F0032). The information in this table consists of:
-
Total amount of all open vouchers
-
Due dates of open vouchers
-
Amount required to pay vouchers
The Cash Summarization table contains summary information from G/L, A/P, and A/R. The cash type designates the system in which the information originated. A cash type is alphanumeric and can be up to five characters. The default cash type for A/P records is 04. JD Edwards World recommends that you use the same cash type each time you run the program. If you run the program again with a different cash type, there will be two sets of A/P information in the Cash Summarization table.
You can use World Writer to view the information created by this program. The information can also be downloaded to a standard spreadsheet program or used by custom programs to perform cash analysis.
When you run A/P cash forecasting, the system:
-
Consolidates open vouchers from the A/P Ledger table (F0411).
-
Summarizes information by business unit, company, due date, and currency.
-
Deletes existing records in the Cash Summarization table with the cash type you specify in a processing option.
-
Updates the Cash Summarization table with the new information.
The following graphic illustrates the cash forecasting process.
82.1.1 What You Should Know About
| Topic | Description |
|---|---|
| Multi-Currency | When using multiple currencies, vouchers are summarized by both the domestic and foreign currencies. In the Cash Summarization table, the domestic currency code appears in the Currency Code field. The foreign currency code appears in the To Currency Code field. When you process domestic vouchers, the foreign amount and currency code are the same as the domestic amount and currency code. |