Create Cash Flow Model

This document explains how you define a a cash flow model, that is a template used to automatically select and filter values when creating a cash flow plan.

Outcome

A cash flow model is created, defining which lines should be included in the cash flow plan. The model also defines which accounts should be included from the cash flow budget used.

The picture below gives an overview of the structure of the model and where values are retrieved for the cash flow plan:

The model can be reviewed in 'Cash Flow Model. Open' (CFS020).

The model is saved in the parameter file (CSYTAB).

Use this model when creating a cash flow plan in 'Cash Flow Plan. Open' (CFS200). The values retrieved are totaled per line.

Before You Start

A cash flow budget must be created in 'Cash Flow Budget. Create from Budget' (CFS100).
An object access group must be created in 'Object Access Group. Open' (CRS006).

Follow These Steps

Define Basic Data ("Header")

Start 'Cash Flow Model. Open' (CFS020/B).

Panel B displays the following information for all previously created models: Object access group, exchange rate type, number of decimals, rounding off code, budget number and budget version.
On the B panel, set the panel sequence.

This instruction is based on panel sequence E1.
Enter an identity for the model; the identity can consist of up to eight alphanumeric characters. Press Enter.
On the E panel, enter a description (required) and a name.
Enter object access group, exchange rate type, rounding off code in the 'Column value presentation' field, and number of decimal places for amount.
On the same panel, enter the number and version of the cash flow budget. Press Enter.

Define Lines to Be Included in the Cash Flow Plan

In 'Cash Flow Model. Open Lines' (CFS021/B), open one of the standard lines.
On the E panel, adjust the standard name of the line, which will be printed in the plan.
If the line should be active, that is included in the plan, select the 'Active line' check box.

Define and Connect Elements to Line

Select option 11 = Elements for one of the three lines to which elements can be connected (001, 180 or 280) to call 'Cash Flow Model. Open Elements' (CFS022).
In (CFS022/B), create an element by entering an identity; this can consist of up to eight alpha-numeric characters. Click New.
(CFS022/E), enter a description (required) and a name. Press Enter to call 'Cash Flow Model. Open Account Ranges' (CFS023).

Define Account Ranges for Element

In (CFS023/B), create a range of accounts by giving it a number between 001 and 999. Click New.
On the E panel, enter a description (required) and a name.
Define the range of accounts by entering From account and To account. Press Enter.
Create a range of accounts in (CFS023/B) for each range. Press Finish.
Repeat the activities from Define and Connect Elements to Line for the remaining lines.

Parameters to Set


Program ID/ Panel	Field	The field indicates...
CFS020/E	Object access group	... the group of users that are allowed to use this particular cash flow model when creating a cash flow plan.
CFS020/E	Exchange rate type	... how payments and payments received in foreign currency should be converted into the currency selected for the cash flow plan.
CFS020/E	Budget number, version	... the cash flow budget to use when retrieving values for lines 180 and 280 in the cash flow plan.
CFS020/E	Column value field	... how values should be rounded off in the cash flow plan. Default value is no rounding off.
CFS020/E	Decimal places amount	... the number of decimals to be used in the cash flow plan. Default value is no decimals.
CFS021/B	Line number	... the identity of a line, that is, a record, in the cash flow plan. The standard setup is retrieved by pressing F14=Standard in panel (CFS021/B), if this has not been done before. The setup consists of these lines:

Standard Lines and Values


Line	Comment
001 Opening balance	The line will display an opening balance retrieved via one or several user-defined account ranges from the general ledger.
Expected Payments Received
100 Expected payments received
110 Customer orders	The line will display a value based on the following customer orders: a) Orders that are confirmed but not invoiced, that is with order line status 22–66 b) Orders with status 77 (Invoiced), provided the invoicing has not updated the financial system. The payment date is based on the confirmed delivery date. It can be adjusted automatically due to how the payment terms and the bank days are defined. The earliest expected payment date is calculated from the date the cash flow plan is created.
120 Customer invoices	The line will display the amount of all open customer invoices in accounts receivable. The due date or revised due date is used as payment date in the cash flow plan.
130 Customer drafts
140 Service agreements
180 Other payments received	The line will display a budgeted value retrieved via one or several user-defined account ranges from the cash flow budget.
190 Total
Expected Payments
200 Expected payments
210 Purchase orders	The line will display the amount of all purchase orders with order line status 11–98.
220 Supplier invoices	The line is similar to line 120 but for supplier invoices instead.
230 Supplier drafts
240 Recurring payments	The line will display the amount of all payments registered as recurring in 'Payment. Open Recurring' (APS095).
280 Other payments	The line is similar to line 180 but for payments instead.
290 Total
Balance Information
500 Closing balance 1
800 Past due customer invoices	The line is used like line 120 but it is only the amount for past due invoices that will be displayed.
810 Past due supplier invoices	The line is used like line 120 but it is only the amount for past due invoices that will be displayed.
820 Blocked customer invoices	The line is used like line 120 but it is only the amount of all blocked invoices that will be displayed.
830 Blocked supplier invoices	The line is used like line 120 but for supplier invoices instead. The difference is that it is only the amount of all blocked invoices that will be displayed.
900 Closing balance 2
Element	... a group of one or several account ranges in the cash flow budget (valid for lines 180 and 280) or the general ledger (line 001).
Range	... a range of accounts connected to an element. The accounts must correspond to the relevant accounts in the cash flow budget and the general ledger.