Item lookup code already exists.

  • Thread starter Steven @ S&S Tire Service
  • Start date

S

Steven @ S&S Tire Service

I have an alias that RMS saids that is already exists, but yet if you do a
search for that number it comes up blank.
Any way to delete that number or pull a report of all lookup codes and their
aliases?
Thanks,
 
Ad

Advertisements

C

convoluted

Steven - try running the alias report but make sure you include both active
and inactive items - hope this helps, Check that alias against both the
alias and itemlookup code fields - hope this helps
 
S

Steven @ S&S Tire Service

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.
 
A

Anthony Laidler

OK What did you do exactly to find the item? I am having the same issue
trying to find it and I have done every type of query I could find and
nothing...
 
M

Michael

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));


--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.
 
M

Mickie

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
 
Ad

Advertisements

M

Mickie

Whoops...wrong thread sorry!
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

item Lookup Code 1
Item Lookup Code 2
Duplicate Item Lookup Code 0
Automated Item lookup code 3
Change the item lookup code 2
Matrix Items/Lookup Codes 2
Lookup Codes 8
Remove old Item Lookup Codes 1

Top