Have a client that is somehow creating bad item records that result in it not appearing in Item Maintenance or a duplicate item being created. Been happening for years, ever since getting DSD Service Center, but they say its not them. The Item Merge utility will clean it up, but how or why is it happening?
We get 2 types of bad records:
1. 2 item codes exist in CI_Item, the bad one has a period (.) at the end of it in the item code in DFDM. Don't see that period in Item Maintenance. Both items are in the item lookup, but when selecting the 2nd one (bad one with period) in Item Maintenance, it says *New* like its creating the item. To fix I have to merge the bad into the good.
2. Only the bad item exists. It also has a period (.) at the end in DFDM, can be seen in an item code lookup in Item Maintenance, but when selecting, it says *New* like it doesn't really exist. To fix this, I have to add a new item, then merge the bad into the good.
I fixed 20 about a year or two ago; I have another 12 to fix now. I don't see errors or issues at the time of creating the items in any logs. Most of the time the bad one gets created first, but I have a couple where the good item has been around for years, now a bad record exists created this year.
I believe the items are always being created via PO Entry. They have other items created the same way that work fine & when trying to reproduce it doesn't occur. They've added 647 items this year & 12 have this issue.
Screenshots of both scenarios:
------------------------------
Dana Young
Lehman Wesley & Associates
Lansing MI
------------------------------