Lookup issue (1 reply)
Subtle error but you have different quote marks.
Replace the “ and ” with "
Subtle error but you have different quote marks.
Replace the “ and ” with "
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
Any reason you can see why this lookup would be failing. I tried many variation of the where clause, but still get the error below.
Error whilst evaluating field [ITEMLINENO] on transaction type [OE0500]. Resolved Function - Lookup("TESTLINENOI”, “LINENUM”, Array("33384769", "T21-7278"), true) Error - Description: Expected ')' Source Line: Lookup("TESTLINENOI”, “LINENUM”, Array("33384769", "T21-7278"), true) . ^ Line=1 Pos=40