Lookup Syntax Issue (2 replies)
What is the field type of field HTSCODE?
Judging from the error It would seem to be an integer type field? Try changing it to Text.
Thanks
Hmm. Both HTSCODE and ITEMNO are text fields.
What is the field type of field HTSCODE?
Judging from the error It would seem to be an integer type field? Try changing it to Text.
Thanks
Hmm. Both HTSCODE and ITEMNO are text fields.
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
Hi all, I'm getting an error when trying to use a new lookup. Looks like it might be a syntax error but I'm not sure. Your thoughts?
Goal: Return an HTS Code based on a match on Sage 300 Item Number. The Lookup is called "ITEMBYHTS"
Lookup syntax in Map Transform:
Lookup("ITEMBYHTS", "ITEMNO", %[HTSCODE], true)
When I check the syntax, it says "no errors found." But when I run the transform I get:
Resolved Function - Lookup("ITEMBYHTS", "ITEMNO", "0604.90.3000", true)
Error - Description: Incorrect syntax near '.3000'.
So there's something not right about the HTS Code that has multiple periods in it, I assume.
I also tried editing the lookup call as below but got the same error:
Lookup("ITEMBYHTS", "ITEMNO", Array(%[HTSCODE]), true)
Ideas?