Any body field on the vendor, employee or bill payment record may be used in an expression. The syntax is as follows:
{recordID.fieldID} operator {recordID.fieldID}
+Operator
The + operator may used on string and numeric values.
1. To add two string values.
E.g. Bank Code is 556677 and Bank Account Number is 01234567
Expression:
{vendor. custentity_vbankrefcode}+{vendor.custentity_vbankaccountnum}
Result:
55667701234567
2. To add two numeric values.
E.g. Payment Total is 12.50
Expression:
{vendorpayment.total}+{vendorpayment.total}
Result:
25.00
-, *, / Operators
The -, *, and / operators may only be used on numeric values.
E.g. Payment Total is 12.50
Expression:
{vendorpayment.total}*5
Result:
72.50
NB.
- Numeric and string values cannot be combined within a single expression.
- Correct spelling of record and field IDs is essential.
