Physical inventory Can we Change This??

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