Use this function to define calculation formulas.

Calculation formulas are written, or structured as Sage X3 language expressions combining, for example, variables, constants, fields extracted from tables and functions.

Each formula is identified with a specific 3-character code. This code identifies the type of functionality in which the formula is used, for example in the calculation of overheads or tax, and in routing operations. The functionality types are defined in Local menu 213 (Formula Type).

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The Formulas function contains a header information section and a single block for the formula.

Entry screen

Use this screen to assign the type of functionality in which this formula is to be used, for example in the calculation of overheads or tax, and in routing operations and the code that will identify this calculation formula.

You can then type in the structure of your calculation formula or use the Formula wizard to generate it for you.

Block number 1

Formula type (field FORTYP)

Use this field to assign the type of functionality in which this formula is to be used, for example in the calculation of overheads or tax, or in routing operations.
Code (field FORCOD)

Code used to identify the calculation formula. A calculation formula is a short code calling on an expression to evaluate a result used in various functions of the product.

Block number 2

Description (field DES)

This long description is used as a title in screens and reports.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.
Short description (field DESSHO)

Title used in some screens or reports when there is not enough space to view the long title.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.

Formula

field FORFOR1

Use this field (and any subsequent fields, if available) to structure a calculation expression.

The syntax is validated when you save the expression and when the formula is used. It can be defined over one or two lines.
field LEG1

Reports

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

  PRTSCR : Screen print

This can be changed using a different setup.

Specific actions

Copy

Click the Copy action to copy this calculation formula to an additional folder.

Error messages

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

Incorrect expression
[Sage X3 error message]

A syntax error has been detected. The error detail is provided in the second line of the message. Examples include an incorrect number of arguments in a function or brackets missing from the expression.

Tables used

SEEREFERTTO Refer to documentation Implementation