ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Wrong Bin Loc (sometimes) on Packing List
http://www.istechforum.com/YaBB.pl?num=1254860492

Message started by gtladmin on 10/06/09 at 13:21:32

Title: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 10/06/09 at 13:21:32

Sometimes when a packing list is printed, it 's pulling an old, non-existent bin location for a part. About 6 months ago Walter got rid of a bin location M1 and move all parts in that location to new bin locations. If you look up the part in inventory, it shows the correct, new bin location. But when you print it on a packing slip, it shows the old, incorrect bin location. The report format being used isn't doing it wrong for all parts, just these parts that were once in the M1 bin location.

How do we track down what is causing this anomaly? :-/ It's really causing a problem when the shippers go to pick the parts......

Thanks,

Val

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 10/06/09 at 13:38:25

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.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 10/07/09 at 06:40:33

Yes we (accounting) run it periodically. This is interesting - if you use IN-A and go thru part by part, you can find the parts with the bin loc listed as M1 (which Walter changed using Warehouse control about 6 months ago). Yet, if you run a bin loc report from WC none of these parts are showing on that report. What are the tables each of these processes is using? Is that indicative of the SM-J-C bug?

Thanks

Val

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by dameng on 10/07/09 at 13:07:06

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.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 10/07/09 at 14:05:16

Check the BKICLOC file for entries with with your M1 location. You can manually delete them with maintain database (make a backup of the file first to be safe). SM-J-C would create these inventory location records. I believe it has been fixed with the latest updates. The reason it won't show up on your bin loc report is because the location does not exsist.
We had this problem until we consolidated transactions that had the deleted locations in them.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 10/07/09 at 14:31:11

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

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 10/08/09 at 06:12:18

Val,

We deleted the BKICLOC records for the non-exsistent locations. You may also have to check that your on-hand quantities are correct. We were keeping non-consolidated transactions back two years, Therefore, two years after we deleted the locations and consolidated the transactions, the problem went away. If SM-J-C logic has been fixed in the newest update, then you should no longer have this issue.
We always run SM-J-C in report mode first to see what it wants to correct. That way, if something stands out as being really odd, it can be investigated.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 10/08/09 at 08:38:06

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

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 10/08/09 at 09:37:09

We fixed this problem sometime ago, and as we only have one location, it has not been a problem for us. I don't know if running SM-J-C will delete records for locations that don't exsist anymore, one of the programmers would have to answer that.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 11/06/09 at 10:52:19

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

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 11/10/09 at 08:37:25

Should have worked. That's how we did it. Is it possible you pulled up the wrong company's BKICLOC record?

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 11/16/09 at 08:42:57

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.

?????

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by Vman on 11/16/09 at 15:32:12

Val,

Might have to have one of the programmer-types chime in. As far as I know the BKICLOC file is where the location(s) and quantities are kept. If there is no entry there, it should not show up in IN-A. :-/

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by GasGiant on 11/17/09 at 05:51:45

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.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 12/02/09 at 15:02:30

Ugh - I desperately need more help with this. Walter is really upset this has not been resolved for him. Does ANYONE have any definitive answer here for us? What shall we try to do here? Lynn, any help? Please????

Colin, there's no way in 7734 we'll ever get production to not back out of an issue they started that was incorrect. They do it regularly from what I hear. So if that is in fact a true cause, then it needs to be fixed--there are plenty of people who probably have an occasion to back out of of WO-I, I'm sure.

Thanks

Val

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by GasGiant on 12/02/09 at 16:27:20

We just got it norrowed down to items with Lot numbers causing the problem. A fix is imminent.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 12/03/09 at 14:51:31

That's VERY good to know - but will we also have a solution to fix the records already messed up (phantom records we can seem to get rid of), and the like? That's what's causing us a big headache right now.

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 04/27/10 at 09:09:31

BRINGING UP THIS ISSUE AGAIN.

This is still a problem and we have not been able to figure out why it is occurring, and we really, really, really, really really, really need some help, it's driving us nuts.

Anybody have ANY ideas?

Val

Title: Re: Wrong Bin Loc (sometimes) on Packing List
Post by gtladmin on 05/03/10 at 08:24:41

Isn't anyone else seeing this? Or does no one print packing slips?