All types of formulas are managed here, e.g.:
- Planned time calculation formulas
- Output calculation formulas
The formula number enables assignment of a formula to time components, operations, BoM positions, thus facilitating the calculation of:
- Default times
- Material requirements
- Other technical data
The result calculated from a formula can also be allocated to a variable.
- Formula flag: Unique flag used to identify the calculation (e.g. F4711)
- Description: Describes the function or the use of the formula (comment)
- Formula string: Any mathematic and logical formula can be
entered here. All numbers and characters are permitted.
- Type Output type of formula (as text or numeric)
|
The following must be observed when using variable designations:
- Maximum length of 20 characters
- Blanks, spaces or mathematical symbols must not be used (+ - period, comma etc.)
- Variable names may not consist of reserved names (function names).
- Variables must begin with a letter
- Mutated vowel and "ß" must not be used.
- Unlike in the product configurator, variables do not have to be delimited by [ .. ].
- Formel syntax corresponds the Syntax of Datawindow (R) - Interpreter of Sybase (R)
- The number of variables is not limited
|
If a formula is selected or created new, a new window opens:
Tab "Formula"
Field
|
Description
|
Formula
|
Formula name
|
Match code
|
Match code
|
Description
|
Formula description
|
Formula string
|
Definition of formula
|
Type
|
Output of formula ("numeric", "string" or "yes|no")
|
Dec
|
Number of decimals (for numeric type)
|
Tab "Variables"
(Definition variables of used in formula)
The syntax is the same as the DataWindow syntax.
See: Datawindow-Syntax
Field
|
Description
|
Variable
|
Variable name
|
Description
|
Description of variables
|
Type
|
Output of formula (numeric or string)
|
Dec
|
Quantity of decimals, necessary by type "Number" (numeric)
|
UoM
|
Unit of measurement
|
Origin type
|
- Formula
- Table
- Variant (from product configuration)
- Field from Item
- Order (Sales Order)
- Order line
- Manually (enter manually at run time)
- Beas-Script
For details see Formula Types
|
|
Origin name
|
Object name from origin type
|
Change
|
Allow changes at run time
|
Validity
|
Validity of variable:
- local (only within the formula and all formulas and tables called by it)
- shared (within the assembly and for all following items, but not sub-assemblies)
- global (in complete structure from the moment of calculation)
|
Operation
|
Mark, to save the variable globally with prefix "agbez_". Then it can be accessed in a description of an operation.
see Operation Variables
|
Cross reference
|
Enter a link
(Only useful with origin type "manually" or "Change")
|
Sorting
|
Order of processing variables
|
Test button: Press this button to test the formula in the the window that opens:
Window caft_testeval.psr
Field Descriptions
Field
|
Description
|
Item
|
Select an item from the drop-down.
|
Work order document
|
Select a Work order from the list.
|
Work Order Pos.
|
Insert work order position
|
Prod. Order no.
|
Select Production Order number
|
Line No.
|
Insert Prod. order line number
|
Active
|
|
Quantity
|
Insert quantity
|
Origin type
|
Select origin type:
- Formula
- Variant
- Field from item
- order
- order line
- Manually
- Script
|
Origin name
|
Select value from the drop-down list. The values in the list correspond with the selected value in Origin type.
|
Defaults Save button: Save selected values as default for Test
Help URL: https://help.beascloud.com/beas202109/index.html?formulas.htm
|