re-entering item numbers

I have previously deleted certain items from my database in RMS 2.0, Now I want to re-enter that same product with the same Item number, and RMS always replys that the number is already being used, and must be unique. A search proves that the number is gone, but I still can not re-enter the previously used number. What to do??

Reply to
Kent
Loading thread data ...

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:

Reply to
Akber Alwani

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

Reply to
Terrible 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.

Reply to
Kent

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

Reply to
Butch

Sorry wrong post

Reply to
Butch

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.