Formulas - Mexico

Formula is the set of expressions that may contain functions, table fields, mnemonics, constants and inclusion of other formulas, already existing.

This file allows the maintenance of these formulas, so they are used in the Calculation Procedure of the Personnel Management environment, which includes the specific calculation to comply with collective agreements, and other particularities of the company or category.

The result of a formula is always stored in a mnemonic previously registered in the Mnemonic Register.

The formulas registered in this file are classified according to their caption, that define if the formula is the user's or the system's.

TOTVS sends formulas to all their clients to calculate a Payroll with no need to create other formulas, once they comply with the effective ruling of each country and, that way, cannot be altered, the are called system formulas.

With the need to alter system formulas for any reason, TOTVS makes changes and sends them to update data base.

To include formulas in this register, you need to know several necessary stages and concepts in the development of formulas in this register.

Formulas and use formula use options are exemplified in item Using Formulas.

Formula structure

Formulas used in the Personnel Management System have a structure following the description of items:

Condition
Bond
Execution

You must define the structure for each item with:

Operators (1, 2 and 3)
Expressions (1st and 2nd)
Result

In each structure option, according to table of possibilities, you may use:

Arithmetic operators
Logical operators
Joining operators
Roles
Fields
Constant
Mnemonics
Other formulas