Having issues scanning barcodes that are generated from RMS when the Item Lookup Code is in lowercase. I have changed a few items in HQ manager that had lowercase Lookup Codes to uppercase and after I synced the SO Database and printed off a new Label and the barcode scans fine. So now I am wondering if I can just generate a SQL Query with the Item lookup Code and Item ID and export it to Excel. Use Excels UPPER Formula to change all Item Lookup Codes to Uppercase and then export the data into the HQ Database. This seems a little far-fetched but it seems like it could work. Just would like anyone?s help or input before I try this. And if the is something I can do in HQ to make the Lookup Code all Uppercase I would not be opposed to doing that. I always backup before doing anything.
Change Item Lookup Code to Uppercase
Jun 21, 2006
2 Replies
make sure you back up your DB before running the query below or any other sql queries against it
you can accomplish this without first exporting to excel, just run this query:
UPDATE Item SET ItemLookupCode = UPPER(ItemLookupCode)
and this will accomplish what you need. you could run this against your HQ database, then use a worksheet to send the changes in the itemlookupcode to all your stores
hth kevin
"nt8378" wrote:
I guess I got it. I used this command:
UPDATE "Item" SET ItemLookupCode = upper( ItemLookupCode )
And it updated all of my lookup codes to uppercase.
"nt8378" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required