This import of cash forecast allows the creation or update of the manual cash forecast. Therefore, it is only possible to manage the forecast whose types are defined by the users (see local menu 3636).
The objective is to be able to import cash forecasts that have been generated by an external application to Sage X3. This way, these cash forecasts remain incorporated into the generated ones from X3 documents.

Prerequisites

The  local menu 3636 must be defined with values >= 20. These are the values managed as manual forecast.

You must define the setup of the cash forecast by the company (Cash forecast types / company function). At this point it will define the cash forecast types managed by the company / site.

Besides, it is convenient to define first the value of the CFOBANDEF - Bank by default parameter. In this way, if the bank is not included in the import, the system will take the value defined by this parameter.

Mandatory fields in the template

In the import, the mandatory fields are the following:

Table CFOMANMVT:

  • Company (CPY field)
  • Site (FCY field)
  • Description (DES field)
  • CFO type (CFOTYP field) (By default the item n. 20 from the local menu 3636 is used)
  • Document date (DOCDAT field)
  • BP (BPRNUM field)
  • Control (SAC field) (By default the control defined in the setup of the BP is taken)
  • Bank (BAN field) (By default the bank defined in the CFOBANDEF parameter is taken)
  • Currency (CUR field) (By default the bank currency is taken)
  • Amount (AMTATI field)
  • Rate type (TYPRAT field) (By default is the first value of local menu 202)
  • Accounting date (ACCDAT field) or Forecast date (CFODAT field) (only one of them is mandatory)
  • Payment term (PTE field) (If ACCDAT field is filled)
  • Payment method (PAM field) (If CFODAT field is filled)

Only if the cash forecast is periodic (field RCP=2)

  • Periodicity (TYPPER field)
  • Increment (IRT field)
  • End date (ENDDAT field)

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

BANK [BAN]

Bank accounts

BPARTNER [BPR]

Business partner

BPEXCEPT [BPE]

BP-Company exception

CFODUDDATE [CFODD]

Cash forecast management

CFOMANMVT [CFOMM]

Cash forecast movements

CFOTYP [CFOT]

Cash forecast types

COMPANY [CPY]

Company

FACILITY [FCY]

Sites

GACM [GCM]

Account core model

GLED [LED]

Ledger

TABCUR [TCU]

Currency table