List of cash forecasts
This report allows obtaining a list of all the cash forecast that are managed in the CFO object (Cash forecast management). It includes manual cash forecast and generated from X3 documents cash forecast.
Prerequisites
Access to the report
This report can be accessed from the report menu of the group Treasury.
It is also called by default from the following functions :
A/P-A/R accounting > Open items > Cash forecast management
List of criteria
| Parameter |
Parameter title |
Type |
|---|---|---|
|
societe |
Company |
|
|
sitedeb |
Site range |
|
|
bprdeb |
Range of business partners |
|
|
cfodeb |
Forecast type (Local menu Purchase requests, Purchase contracts...) |
|
|
stadeb |
Status (Local menu Active, Inactive, Modified, Obsolete) |
|
|
bandeb |
Bank range |
|
|
datdeb |
Date range |
D |
|
impdetail |
Print detail (Local menu No, Yes) |
|
|
impselections |
Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function GESCFO (Cash forecast management).
Description of the report
The report is sorted with breaks by Site / Bank / Cash forecast type.
The detail displays the following information:
- Document (Number + line)
- Document date
- BP
- Amount + Currency
- Accounting date + Payment term / Forecast date + Payment method
Furthermore, if the report is executed with the "print detail" option, the detail displays the following information for each cash forecast (information about the open items generated by the forecast):
- Amount
- Forecast date + Payment method
On the last page of the report, a summary grid displays the total amounts by currency and totals by Site, Bank and Cash forecast type.