Since a couple of days, we see duplicate item_no in the Item Maintenance screen. I looked into the imitmidx_sql table and the item_no are duplicates. I did some test to find out what is causing the duplication and here is what I found. Each time we click on the Item Location button in the Item Maintenance screen, another record with the same data is added in the imitmidx_sql table. That means we can have multiple time the same item_no.
It never happened before. Can someone help on this odd issue?
Thanks in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.