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 Sage X3 documents.

Prerequisites

Access to the report

This report can be accessed from the Treasury report menu.

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: No, Yes	M1
datref	Pivot date	D
sens	Sign: Debit, Credit	M626
detpce	Detail by open item: No, Yes	M1
tri	Sort order: Number, Title, Short title	M676
typcur	Rate type: Daily rate, Monthly rate, Average rate...	M202
datcours	Rate reference date	D
impselections	Print selections: 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 this 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 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, if the Detail by open item was selected:

• The document number and type
• 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 was not selected, for each BP, the report displays:

• 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 the company level:

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