The CFOECHTIERS report is used to print for a company or a site grouping (non legal company) the Business Partners schedule on a defined horizon. This report includes both the real open item and the open items from the cash forecast. The open items from cash forecast could be from a manual or automatic forecast from X3 documents.

Prerequisites

List of criteria

Parameter

Parameter title

Type

societe

Company

CPY

sitedeb

Site range

FCY

bprdeb

Range of business partners

BPR

coldeb

Range of control accounts

SAC

grpcol

Control group

GSC

bandeb

Bank range

BAN

datdeb

Due date range

D

bapdeb

Good to pay range (Local menu Pending, Conflict, Delayed, Authorized to pay)

M510

devise

Selection currency

CUR

modreg

Payment method

TAM

tri

Sort order (Local menu Pay-By BP, Due date)

M922

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 CFOECHTIERS report recovers the Business Partner payment schedule by classifying the open items by BP, then by due date.

For each BP, the report displays:

  • The BP code
  • The BP description
  • The due date of the request.

For each open item, the CFOECHTIERS report displays:

  • The due date
  • The code and name of the bill-to BP
  • The dispute code (if dispute)
  • The journal type and number
  • The payment mode (BOR, LCR, ESP,...)
  • The debit amount
  • The credit amount
  • The progressive BP balance (positive or negative)

At the end of the print, the CFOECHTIERS report displays:

  • The debit total
  • The credit total
  • The total final balance.