Setup > General parameters > Formulas 

This function is used to define the calculation formulas in the form of expressions in the Sage X3 language (which includes variables, constants, fields extracted from tables, functions, etc.).
The Formula can later on be called using a shortened code of three characters. This code is associated with a formula-type code defining the location where the formulas can be used (in calculations of overheads or tax, in routing operations, etc.).

The complete list of the where-used cases is mentioned by the local menu 213.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

This screen is used to enter in these three fields: 

  • a qualifying title,
  • a short title,
  • the calculation formula: entry of this formula is facilitated in client-server mode thanks to the formula editor.

Entry screen

Fields

The following fields are present on this tab :

Block number 1

  • Formula type (field FORTYP)

Block number 2

  • Description (field DES)

 

  • Short description (field DESSHO)

 

Formula

  • field FORFOR1

This field is used to specify the formula used to calculate promptings. This formula can be based on the following elements:

  • item data (ITEM table) such as the price.
  • item container data (ITEMCTR data) such as the weight or volume.
  • data cumulated in CUs of the output movements (from picking or reserve locations), input movements (to picking or reserve locations) or replenishment movements by item or item container over the calculation period (CLRVAL table).

Example of a formula taking into account the number of CUs of the input movements on picking + input movements on reserve + output movements on picking + output movements on reserve: [F:CLV]INMPICUUC+[F:CLV]INMRESUUC+[F:CLV]OUMPICUUC+[F:CLV]OUMRESUUC

Note: if no formula is entered, the promptings will correspond by default to the sum of the CUs of the input movements (picking + reserve), output movements (picking + reserve) and replenishment movements.

 

  • field FORFOR2

 

 

  • field FORFOR3

 

 

  • field FORFOR4

 

 

  • field FORFOR5

 

 

  • field FORFOR6

 

 

  • field FORFOR7

 

 

  • field FORFOR8

 

 

  • field FORFOR9

 

 

  • field FORFOR10

 

 

  • field FORFOR11

 

 

  • field FORFOR12

 

 

  • field FORFOR13

 

 

  • field FORFOR14

 

 

  • field FORFOR15

 

 

  • field FORFOR16

 

 

  • field FORFOR17

 

 

  • field FORFOR18

 

 

  • field FORFOR19

 

 

  • field FORFOR20

 

 

Close

 

Reports

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

 PRTSCR : Screen print

This can be changed using a different setup.

Specific Buttons

This button allows copy of the formula to another folder.

Error messages

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

Incorrect expression
…Sage X3 error message…

In this case, a syntax error has been detected, the detail being given in the second line of the message. This can be for instance an incorrect number of arguments in a function, brackets that are missing etc...

Tables used

SEEREFERTTO Refer to documentation Implementation