Business partner cash forecast

Use this report to print the Business Partners schedule on a defined horizon for a company or a site grouping (non legal company). 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 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
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: Pending, Conflict, Delayed, Authorized to pay	M510
devise	Selection currency	CUR
modreg	Payment method	TAM
tri	Sort order: Pay-By BP, Due date	M922
impselections	Print selections: No, Yes	M1

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

This 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 report displays:

• The due date
  
• The code and name of the bill-to BP
• The dispute code (if applicable)
• 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 report, the CFOECHTIERS report displays:

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