Setting/automailxdesc: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
A price value for the invoice item can be specified after a second pipe (|) symbol, this can be used to calculate a price using template variables. | A price value for the invoice item can be specified after a second pipe (|) symbol, this can be used to calculate a price using template variables. | ||
If the price value in the description field is zero or absent, the numeric value from the amount field will be used. | If the price value in the description field is zero or absent, the numeric value from the amount field will be used. | ||
*Description|Status|Price|VAT | |||
Special characters ^~ should be used when there is an IF statement in the calculation, as the standard separators :| in the calculation will break the calculation. | |||
Tourist Tax|Stayfee|[IF>^[NUMNIGHTS][*][NUMADULT][*]2[*]1.03^7[*][NUMADULT][*]2[*]1.03^7[*][NUMADULT][*]2[*]1.03~[NUMNIGHTS][*][NUMADULT][*]2[*]1.03] | |||
When using one of the 'Change' options, then use the format below, text has to be an exact match. | When using one of the 'Change' options, then use the format below, text has to be an exact match. | ||
*findThisDescription^replaceWithThisDescription | *findThisDescription^replaceWithThisDescription | ||
Revision as of 09:36, 3 November 2025
Description to add with the invoice item. Template variables can be used
A status value for the invoice item can be specified after the description by adding a pipe (|) symbol.
A price value for the invoice item can be specified after a second pipe (|) symbol, this can be used to calculate a price using template variables. If the price value in the description field is zero or absent, the numeric value from the amount field will be used.
- Description|Status|Price|VAT
Special characters ^~ should be used when there is an IF statement in the calculation, as the standard separators :| in the calculation will break the calculation.
Tourist Tax|Stayfee|[IF>^[NUMNIGHTS][*][NUMADULT][*]2[*]1.03^7[*][NUMADULT][*]2[*]1.03^7[*][NUMADULT][*]2[*]1.03~[NUMNIGHTS][*][NUMADULT][*]2[*]1.03]
When using one of the 'Change' options, then use the format below, text has to be an exact match.
- findThisDescription^replaceWithThisDescription