Conversion failed when converting the varchar value (3 replies)
Can you send a screenshot of the Lookup (in Setup)?
Please see attached 🙂
Change the where clause to (note the single quotes):
PLPostedSupplierTran.TransactionReference = '%1'
Thanks
Resolved Function - Lookup("CHKSUPREF","SupplierRef","1221159180 ",false)
Error - Description: Conversion failed when converting the varchar value '24/7 concrete' to data type int.
Hey guys
the field is set to type text yet I am getting the above error....any ideas?