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) |