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
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
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
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?