Reports > Module Financials > Report CFOBALAGEGRP (Aged balance cash forecast) 

The report indicates for each BP the distribution of their balance in "not overdue" terms and by time groups of the late payments. This report includes both the real open items and the open items from the cash forecast. The open items from cash forecast can be from a manual or a automatic forecast from X3 documents.

Prerequisites

List of criteria

Parameter

Parameter title

Type

societe

Company

CPY

sitedeb

Site range

FCY

coldeb

Range of control accounts

SAC

grpcol

Control group

GSC

tiersdeb

Range of business partners

BPR

bandeb

Bank range

BAN

borne1

No. of days 1

C

borne2

No. of days 2

C

borne3

No. of days 3

C

depasse

Open item overrun (Local menu No, Yes)

M1

datref

Pivot date

D

sens

Sign (Local menu Debit, Credit)

M626

detpce

Detail by open item (Local menu No, Yes)

M1

tri

Sort order (Local menu Number, Title, Short title)

M676

typcur

Rate type (Local menu Daily rate, Monthly rate, Average rate...)

M202

datcours

Rate reference date

D

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 header of the CFOBALAGEGRP report displays the following information:

  • The selected company
  • The currency used (company currency)
  • The reference date

This report classifies the posted entries by BP. For each BP, the CFOBALAGEGRP report displays:

  • The BP code
  • The BP name
  • The telephone number
  • The partial balance for each open item horizon
  • The final total balance of the BP account

For each open item, the report indicates if the "Detail by open item" has been selected:

  • The Type/Document number
  • The due date
  • The difference in days with reference date
  • The open item amount if above nd3 days late
  • The open item amount if ranging from nd2+1 and nd3 days late
  • The open item amount if ranging from nd1+1 and nd2 days late
  • The open item amount if ranging between the reference date and nd1 day late
  • The open item amount if not overdue
  • The open item balance

If the "Detail by open item" has not been selected, the CFOBALAGEGRP report then gives back for each BP:

  • The total amount of the open items if above nd3 days late
  • The total amount of the open items if ranging from nd2+1 and nd3 days late
  • The total amount of the open items if ranging from nd1+1 and nd2 days late.
  • The total amount of the open items if ranging between the reference date and nd1 day late
  • The total amount of the open items not overdue
  • The total balance of the open items

The report also displays the following information at company level:

  • A general total amount by open item horizon
  • Its balance