Do you run SM-J-C (Reconcile inventory)? There is a bug in the program, supposedly fixed in the latest update/patches where the program would recreate BKICLOC entries for parts for a location that had been consolidated but no longer exsist.

did you apply the SP2 for the 9/16/09 update? it fixed a bug in sm-j-c that involved some of the improved logic changes that they made, as well as making sure the memory buffers cleared after posting the changes. i don't know if there was an issue involving bin loc, but am not certain there are any reconciliation made to bin loc files/fields. at least by the documentation it doesn't.

Dave, we are not yet on the Sept. update, but I did already see there were some fixes for SM-J-C in there.  I asked Lynn if it specifically fixed this issue but have not yet got that question answered.
 
Vman, I took a look at the BKICLOC file and can find the 39 records--but I didn't yet delete them.  I can see for most of these 39 items there are at most 4 location records--default plus two or three other location records.  I would assume I delete the default, but I will have to check with Walter first (which is why I didn't do anything yet...)
 
What exactly did you do to fix this? You first deleted the records in BKICLOC, and then what?
 
Appreciate the input to this, it's a relief to know someone else had had to deal with this issue before!
 
Val
 

So just to confirm, all you did was delete the specific records in BKICLOC via Maintain Database? You did not run SM-J-C afterwards as part of the fix?
 
 
Once I update with the new SM-J-C, I want to take care of this issue.  I just want to be sure I understand all that you did.
 
Thanks,
 
Val

Ok, so I just tried the fix on this to see in our test company.  I went into the test company, into Maintain DB, to the BKICLOC table for the test company. There were 4 records for the parts have have the old (removed) bin location in IN-A.  I removed the first location record (blank location). Exited out, went into IN-A, looked up the part and it still shows the old bin loc.  Went back into MDB three add'l times to remove one by one the other records, but after each time IN-A was still showing the old bin location.  Now there are no records in the BKICLOC for that part, yet IN-A still shows the old bin location?  So we decided to run SM-J-C to see if it would suggest any changes, either A or B mode, for the part, and nothing came up.
 
Mystery!!!!  How come this isn't working?
 
Val

I double-checked that.  It's the correct one.  The records no longer exist in the test company file, but were definitely still there in the real company, so I picked the correct one.
 
?????

BKICLOC and BKICMSTR interact in interesting ways during the dreaded Rebuilding Stock Status. If there is no record for the part in BKICLOC then one will be created. If there are quantities in stock locations in BKICLOC they will be used to update the total UOH in BKICMSTR. Lately we have seen some blank location entries appear in BKICLOC and some duplicate entries appear in BKICMSTR, but with no info except the item code. Seems to be related to backing out WO receipts with WO-I.