re-entering item numbers

First of all you done or delete the item before noticing that these contain transactional data may be check the alias table also, and I suggest you to check the Item table from query to anlaysize that already item is there or not. it happen to me last week and i had spend 4 hrs to solve one small issue my integration tool was not working and updating the items due to this issue: run the query and give new item code:

select * from item where itemlookupcode='XXXXX' xxxx is your item code. see if it return you anything.

"Kent" wrote:

Did you delete them or make them inactive? Inactive items won't show up in the items list or be found with the Find feature. Use the Inventory Wizard to re-activate inactive items.

If you deleted items with transaction history, you have more problems than 'ghost' ILC duplicates.

Akber's 'select' query is a good idea - inactive items are still in the item table.

You might also try: select * from alias where alias = 'x' where x = your ILC.

I would discourage you from deleting items in the future. Make them inactive instead.

Tom

I actually deleted them, they were Lot Matrix items. I know now not to delete items, but it seems like I could re-enter an item with the same number. I am thinking that SQL keeps a list of item numbers for a fast search, and when deleting the item, the information about that item is gone, but the search number in SQL is still there. Is there a way to initialize the search numberes so invalid numbers are gone? By the way, thanks for the feed back. I appreciate it.

I do not have access to those queries. Is it possible to forward them to me? Thanks snipped-for-privacy@ponoroff.com

Sorry wrong post