Hi, I have a little problem. I have a hand held scanner (scanpal 2) and it works great with RMS. but when I, import the file . it doesn't find the Items and is Because is looking for the Item lookup Code and not the Aliases.(UPC). how can I change or ad on the field type (Field matching) the "Aliases". thanks jose
This is going to take you a few minutes...
From Store Ops Admin, run the following query: SELECT ItemID, Alias FROM Alias
Export the result to a .csv file. If you have any alias (and you probably do) that are all numeric and start with a zero, open the CSV with Word (or Wordpad or Notepad) then copy/paste into Excel. Use the Text to columns feature to separate the two fields. Sort by ItemID.
From Store Ops Admin, run the following query: SELECT ID, ItemLookupCode FROM Item
Repeat the procedure above, pasting into the same worksheet as the Alias query results. Sort these columns by ID.
You should have something like this: Column A = Alias.ItemID Column B = Alias.Alias Column C = Item.ID Column D = Item.ItemLookupCode
In Column E (let's call it Item.Alias) you can now use the VLOOKUP function (use the function wizard if you need help) to associate the Alias with the appropriate ILC.
You will have three columns that matter after you have successfully completed the VLOOKUP. Item.ID, Item.ILC, Item.Alias. Sort by Item.Alias and delete the ILCs that don't have an Alias.
Now, on your Physical count worksheet, use VLOOKUP again to associate the Aliases you scanned with the ILC you want. You can then sort the list by the VLOOKUP column and copy the ILCs over the Aliases - or better yet, copy and Paste Values into a blank worksheet.
Like I said, this will take a few minutes but it's better than counting by hand...
GL, Tom
Thank you Tom, I see where you are going with these. I am not good with excel, but I will figure it out. Thanks again jose
The import will match aliases to their Item Lookup Codes and import successfully.
To test I just created an item with ILC = 123456 and an Alias = 987654. Then I created an import file in notepad with the line 987654,4 which is the alias and qty of 4. I imported that via Physical Inventory and it matched correctly to the ILC code.
Rick Brown DataBasics
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.