The parameters used in the formula field are:
Name |
Description |
P1 |
Transaction total (Incl. VAT) |
P2 |
Transaction total (excl. VAT) |
P3 |
Total VAT |
P4 |
Remaining total |
P5 |
Paid total |
P6 |
Surcharges total |
The parameters used in the condition field are:
Name |
Description |
P1 |
Transaction total (Incl. VAT) |
P2 |
Transaction total (excl. VAT) |
P3 |
Total VAT |
P4 |
Remaining total |
P5 |
Paid total |
P6 |
Surcharges total |
P7 |
Day of transaction (example: generates the value 31 for the invoice dated 31/12/2005.) |
P8 |
Month of transaction (example: generates the value 12 for the invoice dated 31/12/2005.) |
P9 |
Year of transaction (example: generates the value 2005 for the invoice dated 31/12/2005.) |
P10 |
Date of transaction (YYYYMMDD) (example: generates the value 20050101 for the invoice dated 01/01/2005.) |
P11 |
Trading Group |
Functions
The arithmetical and logical functions to be used are:
Name |
Usage |
Description |
MIN |
MIN ( , ) |
Returns the parameter with the lower value. |
MAX |
MAX ( , ) |
Returns the parameter with the higher value. |
ABS |
ABS ( ) |
Shows the absolute value of the number. |
AND |
... AND ... |
If all the conditions are true |
OR |
... OR ... |
If at least one of the conditions is true |
MOD |
MOD ( , ) |
Shows the remainder of the division. |
DIV |
DIV ( , ) |
Indicates the integer part of the division result. |
> |
... > ... |
Greater than |
< |
... < ... |
Smaller than |
>= |
... >=... |
If greater or equal |
<= |
... <= ... |
If smaller or equal |
= |
... = ... |
If equal |
<> |
... <> ... |
If different (not equal) |