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

CPY

sitedeb

Site range

FCY

bprdeb

Range of business partners

BPR

cfodeb

Forecast type (Local menu Purchase requests, Purchase contracts...)

M3636

stadeb

Status (Local menu Active, Inactive, Modified, Obsolete)

M3637

bandeb

Bank range

BAN

datdeb

Date range

D

impdetail

Print detail (Local menu No, Yes)

M1

impselections

Print selections (Local menu No, Yes)

M1

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.