gtladmin
Active Member
   

Diving is fun, diving is fun!
Posts: 1306
Gender:
|
Weird issue (all of our are, I know!). Back in June of this year, Walter created an inventory bin called QUARANTINE that he described as "New bin from IN-L-J by WProkowiew". That bin was assigned a location QUARANTINE, and into it was transferred a specific item, #188. You can see inventory transactions for this part on the same day, qty 4 were transferred from DEFAULT to QUARANTINE. Since he created/transferred parts into that location, there are about 2600+ entries in the WC-C listing that are negative BIN UOH and zero Tot Bin UOH. The 2nd Description field in WC-C for some of these bad entries is the part description for item #188. The rest of the fields are blank in these records (item, warehouse, bin, dflt, etc). I looked at all of this in our test company from early November and all these bad entries exist in there. So this is not a recent event. I am going to guess it may be related to the creation of the bin that was done as a part of the IN-L-J transaction. Also this may or may not be related, in the ISBNMSTR table the entries have one other field populated, ISBN.MSTR.EXTRA which contains "PIA". Not sure what that means. And in the ISBNMSTR table the inventory location field for this QUARANTINE bin is blank (empty) where it should likely have something, at least DEFAULT. So, question of the day: how do I get rid of all these hundreds of bad entries easily and fix this issue? Not sure if more records are being created as they go into WC-C. Walters swears that is the case. I don't know how to know this for sure. As always, thanks in advance! Val
|