Item lookup code already exists.

Thanks for the reply. I ran the report and it showed no item and no way to change it. I ended up just query it out in visual studio.

Try running the following SQL queries

Alias With No Item

--------------------

SELECT Alias.Alias, Alias.ItemID, Item.ID, Item.ItemLookupCode FROM Alias LEFT JOIN Item ON Alias.ItemID = Item.ID WHERE (((Item.ID) Is Null));

If records show up in the above query note the number of records and then run the following

Delete Alias With No Item ID

------------------------------

DELETE FROM Alias FROM Alias LEFT JOIN Item ON Alias.ItemID = Item.ID WHERE (((Item.ID) Is Null));

I had this same problem when a NEW item was accidentally made into an EMPTY MATRIX type item. I could never get it to come back up so I could add matrix items to it. I finally just deleted it from the item table and re-made it under the same number.

If you can get it to come up in POS, try looking at the item TYPE to see if it is a matrix item..if yes, change the type to standard.

otherwise, You will have to go to the SQL table to see it.

mickie

Anth> OK What did you do exactly to find the item? I am having the same issue