List of cash forecasts
This report allows obtaining a list of all the cash forecast that are managed in the Cash forecast management function. It includes manual and automatic forecasts from Sage X3 documents.
Prerequisites
Access to the report
This report can be accessed from the Treasury report menu.
You can also access this report from Cash forecast management function.
List of criteria
|
Parameter |
Parameter title |
Type |
|---|---|---|
|
societe |
Company |
|
|
sitedeb |
Site range |
|
|
bprdeb |
Range of business partners |
|
|
cfodeb |
Forecast type: Purchase requests, Purchase contracts... |
|
|
stadeb |
Status: Active, Inactive, Modified, Obsolete |
|
|
bandeb |
Bank range |
|
|
datdeb |
Date range |
D |
|
impdetail |
Print detail: No, Yes |
|
|
impselections |
Print selections: No, Yes |
Comments
The data is filtered by site according to the rights granted to the user in the Cash forecast management function.
Description of the report
The report is sorted with breaks for site, bank, and 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
If you select to print details, the following information for each cash forecast 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.