QAID # 13348 Published
Question / Problem:
I am working with the Database Lookup in KTM/AXP, working with a variety of sizes for a VendorID. All VendorIDs seem to be found without issue, except for 4-digit VendorIDs, which are not found through the DBLookup. In order to find these VendorIDs, I have to enter all 4 digits exactly and then the DBLookup is able to find the entry.
How can I resolve this issue?
Answer / Solution:
This situation is working as designed. Strings of four characters or less typically require an exact match, whereas strings of four or greater do not.
It is recommended to increase the length of the VendorIDs for the fuzzy lookup to function as expected.