Remove Invalid Character (2 replies)
I have managed to resolve this. I missed separating each array member with a space as well as a comma.
We've added this as a bug.
I have managed to resolve this. I missed separating each array member with a space as well as a comma.
We've added this as a bug.
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
I have a formula in a map transform that evaluates ok using the Check button but when I preview the results using the Refresh button, I get the following error:
Error whilst evaluating field [TransactionCount] on transaction type [Record].
Resolved Function - LOOKUP("CHECKPLTRANS","TransactionCount",Array(120758,CDate("30/01/2019"),%[SupplierRef],119.99),false)
Error - Description: Invalid character
Source Line: LOOKUP("CHECKPLTRANS","TransactionCount",Array(120758,CDate("30/01/2019"),%[SupplierRef],119.99),false)
. ^
Line=1 Pos=74
How do I resolve this?