Cash forecast management

Use this function to see and modify the cash forecast generated automatically from Sage X3 documents, which is detailed in the Cash forecast generation function (FUNTRTCFO). With this function, you can also create, see, and modify manual cash forecasts that do not originate from an existing Sage X3 document. By using these manual forecasts, you can create cash forecasts such as payment forecasts for payroll, rents, loans, and so on.

Sage X3 document forecast

Cash forecasts are created automatically through Cash forecast generation. Important features of this type of forecast include:

  • Number and line: The number is equal to the Sage X3 document number and the line is a forecast counter created from the same Sage X3 document. For example, a unique sales order could generate several forecasts if it has different delivery dates.
  • It cannot define a forecast that runs periodically.
  • This forecast is always defined by an accounting date and a payment term. These concepts are defined by the Sage X3 document.

Manual forecast

You create these forecasts manually, or by importing from an external application:

  • The number is defined by the assigned counter in the Sequence number assignment function (GESTCA).
  • You can set up forecasts that run periodically.
  • The cash forecast can be defined by accounting date + payment term or by forecast date + payment method.

In any case, creating a cash forecast generates open items that you can enter on the Open items tab. The open items that already exist in the GACCDUDATE table can provide information about the treasury forecast. Three reports manage all this information:

The cash forecast definitions are created in the CFOMANMVT table and the open items generated are created in the CFODUDDATE table.

Prerequisites

Refer to the documentation on Implementation.

Screen management

Cash forecast management

Company (CPY)

Enter the company for the cash forecasts. This field is mandatory and it cannot be modified for a forecast generated automatically.

Site (FCY)

Enter the financial site for the cash forecast. Entering this data automatically updates the company code. This field is mandatory and it cannot be modified for a forecast generated automatically.

Description (DES)

Enter a short description of the cash forecast. This field is mandatory and it cannot be modified for a forecast generated automatically.

Criteria

Status (CFOSTA)

This field displays the cash forecast status. The possible values are:

Active: The operation is included in the cash forecast management.

Inactive: The system generates a forecast movement but the forecast open item is not generated. You can find this operation in the CFORPT report. This is mainly used to evaluate the impact of an operation without deleting the forecast.

Modified: This status applies to all manually modified cash forecasts. The forecast movement is then protected and cannot be replaced by a new forecast generation. This mainly applies to the forecasts based on Sage X3 documents such as purchase orders, sales invoices, and so on.

Obsolete: This status applies when the forecast date is earlier than the current date. The forecast open items are no longer generated.

You can delete the forecast if the status is Inactive or Obsolete.

In creation:

  • Active: The forecast open items are generated.
  • Inactive: The forecast open items are not generated.

In modification:

  • Active or Inactive:
    • Modified: An automatic modification when a forecast data is modified.
    • Obsolete: The forecast open items are not generated.
Forecast type (CFOTYP)

Cash forecast type, in modifiable local menu. This field is mandatory and you can only enter values for a manual forecast.

Sign (SNS)

Balance of the cash forecast: Expense or Revenue. For a manual forecast, this field is based on the value set up in the Cash forecast types function (GESCFT).

Document date (DOCDAT)

Sage X3 document date or the creation date for a manual forecast.

Periodic (RCR)

This field indicates whether the cash forecast runs periodically or not. If Yes, the fields under Frequency are enabled and you can define the frequency. It is only available for manual forecasts.

Data tab

BP DATA

BP (BPRNUM)

The BP code to which the forecast is attributed. The BP must be active, authorized for the company, and authorized in forecast management. The authorization status for the forecast management is defined at the BP or BP/Company level.
Control (SAC)

Short code of the BP control account, generated by default with the accounting code of the supplier if the forecast is an expense, or with the accounting code of the customer if the forecast is a revenue.

The Control account field is defined by default based on the presence or absence of the BP/Company tab on the BP record.

BP/Company tab missing on the BP record

When the customer/supplier code is specified, the Control account defaults to the control account located on line 1 of its accounting code on the Financial tab.

BP/Company tab present on the BP record

The BP record is searched and if an exception line has been created for the company entered in the BP/Company tab it identifies the customer/supplier accounting code. The account of the line 1 of the accounting code is used.

If there is no exception line for the entered company, the BP record on the Financial tab is used to identify its code.
Bank (BAN)

Treasury or bank account for the payment (expense) or the collection (revenue).

This field is mandatory. By default, the bank specified in the customer/supplier record of the Financial tab is used. If no value is entered in this field, the value defaults to the company bank, which is defined by the CFOBANDEF - Default bank parameter (TRS chapter, CAS group).

Currency (CUR)

Currency the cash forecast amount is expressed in. The bank currency is suggested by default.

Amount (AMTATI)

Corresponds to the total amount (incl. tax) that will be perceived (revenue) or paid (expenses). In the case of a periodical forecast, it is this amount that repeats on each recurrence.

If the forecast is an invoice with a determined payment term, this amount is distributed on the miscellaneous open items, depending on the payment terms.

Rate type (TYPRAT)

Rate type, the local menu for which the standard values can be modified, used to carry out a conversion if the currency is different from the company currency. The program suggests the type of rate set up in the Forecast type definition.

Accounting data

Accounting date (ACCDAT)

Provisional date of the document generating the cash movements. This field populates when the forecast is linked to the existence of a document generating open items, for example, if the forecast is associated with a future invoice. The generated open items must be applied to the date specified in the payment terms.

This field is not compatible with the Forecast date field.
Payment term (PTE)

Document payment terms. The document generates treasury movements. This field is mandatory when the field Accounting date is entered.

This field populates when the forecast is linked to the existence of a document generating open items, for example, if the forecast is associated with a future invoice. The generated open items must be applied to the accounting date of this payment term.
Forecast date (CFODAT)

Provisional date for the treasury movement. This field is entered when the forecast is directly linked to the treasury movement and that no document will generate this treasury movement, for example, a forecast on a salary payment.

This field is not compatible with the Accounting date field.
Payment method (PAM)

Payment method for the treasury movement or the forecast. This field is entered when the forecast is directly linked to the treasury movement and that no document will generate this treasury movement, for example, a forecast on a salary payment.

Comment

Text (TEX)

Use this field to add information on the forecasts if necessary.

Frequency

Frequency (TYPPER)

You can set the period or frequency when the Periodic field is set to Yes.

Weekly: The forecast is repeated every N weeks. Select the field listing the days to select the day, or days, of the event.

Monthly: The forecast is repeated every N months. The event occurs on the day of the month that corresponds to the accounting date or to the forecast date.

First: Select First and select a day. The forecast occurs on the first day of the month, for example, the first Monday of the month.

Last: Select Last and select a day. The forecast occurs on the last day of the month, for example, the last Friday of the month.

The value of N must be specified in the Increment field.
Increment (IRT)

Indicates the frequency in weeks, or in months, that a periodical forecast is repeated.

For example, if the frequency is every two weeks, the frequency type is Weekly with an increment of 2.
End date (ENDDAT)

End date for the forecast frequency.

For example, if the frequency is every two months and the forecast ends at the end of the year, the end date is 31/12/2014. Forecasts are generated on: 28/02/14, 30/04/14, 30/06/14, 31/08/14, 30/10/14 and 31/12/14.
DAYS

Select a day, or days, to define the forecast frequency.

  • Weekly: The forecast generates the selected day or days of each week.
  • First: The forecast generates the first selected day or days of each month.
  • Last: The forecast generates the last selected day or days of each month.

Open items tab

The number of lines in the grid depends on the cash forecast definition on the Data tab. A non‑periodic forecast based on a future invoice generates the same number of treasury lines as those defined in the payment term.

Open items are calculated and generated based on the cash forecast calculation date.

Open items grid

Due date (DAT)

Forecast date for the treasury movements. This date can be modified. In this case, the status of the payment forecast becomes Modified.
Amount (AMTCUR)

Amount for each treasury movement generated by the forecast. The amount is equal to the one defined in the Data tab, unless the forecast is associated with a payment term that distributes this amount in several movements.

This value can be modified. In this case, the payment forecast status changes to Modified.

Payment method (PAMDET)

Payment method for each treasury movement generated by forecasts. The payment is defined by the payment method Data tab or by the payment conditions.

This value can be modified. In that case, the payment forecast status changes to Modified.

Reports

By default, the following reports are associated with this function:

This can be changed using a different setup.

Specific Buttons

Zoom

This button is available when the selected cash forecast has been automatically created in the Cash forecast generation function (FUNTRTCFO).

Select Zoom to access the document that generated the cash forecast. For example, if the cash forecast is based on a sales order, selecting Zoom takes you to this sales order in the Order management function (GESSOH).

Error messages

In addition to the generic error messages, the following messages can appear during the entry:

Module A/P-A/R accounting Sequence number assignment not found

A counter has not been assigned for the creation of a cash forecast. The counter must be assigned in the A/P-A/R accounting module.

Problem on recovering the sequence number

There is an error upon assigning the counter to the cash forecast that is created manually.

The cash forecast type is not valid for this company/site

In the manual creation of a cash forecast, a forecast type that has not been set up for the indicated company or site is used.

Business partner not authorized for this company

In the manual creation of a cash forecast, a Business partner that is not authorized for the indicated company is used.

The BP is excluded from the cash management

In the manual creation of a cash forecast, a Business partner that does not have authorized the cash management is used.

This is not a company's bank.

In the manual creation of a cash forecast, a Bank that is not authorized for the indicated company is used.

The bank is excluded from the cash management

In the manual creation of a cash forecast, a Bank that does not have authorized the cash management is used.

The date is earlier than the past months

The accounting date is lower than the first day of analysis period defined for the forecast type.

The end date must not be less than the start date.

The end date of a periodical forecast must be upper than the date in which the forecast starts.

Tables used

Refer to the documentation on Implementation.