ISTech Support Forum - What is going on with the location file???

Keith

Full Member

I love YaBB 1G -
SP1!

Posts: 106

What is going on with the location file???
01/25/06 at 08:16:25

I posted a disappearing location thread under the "Item" section earlier today. After looking into our system further, I am finding locations called "WORK ORDER" showing up for certain parts - they now have the normal "blank" location as well as a "WORK ORDER" location. Is this normal with the most recent updates - I looked at old data file copies and this location is not present.

Please reply with any updates/suggestions concerning this.

Thanks

Keith

Back to top

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06

IP Logged

rmh148 Member Posts: 84	Re: What is going on with the location file??? Reply #1 - 01/25/06 at 11:03:30 Keith, Have you updated to the 1/12/2006 version and turn on warehouse control?
Back to top	IP Logged

Keith Full Member I love YaBB 1G - SP1! Posts: 106	Re: What is going on with the location file??? Reply #2 - 01/25/06 at 11:31:30 No I haven't. I'm not interested in wharehouse control but if that will fix the problem then I do it. What about the mysterious vanishing location records ? Will the patch fix this also? Thanks
Back to top	Keith Ruskay AI-TEK Instruments, LLC Version 2004.1 IS Tech Support Update 05/08/06 IP Logged

NovaZyg Administrator When all else fails.. Read the instructions. Posts: 789 Gender:	Re: What is going on with the location file??? Reply #3 - 01/25/06 at 13:07:54 Keith, Thanks to you and the "WORK ORDERS" tip, we found the bug, fixed it, then severely chastised the programmer for it. Will be in a patch very soon. and a utility to clean up the bogus entries will soon follow. Note: The WO-D program is the problem.
Back to top	Allen Landry Evo~ERP EvoERP and DBA Classic always Beta's of the Latest versions. IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: What is going on with the location file???
Reply #4 - 01/31/06 at 08:12:26

I just got back from a week off and we have several items with this problem of WORK ORDER location also. I know we had this problem right after the 11/18 update I did on 12/03. I consolidated inventory locations at that time and it fixed the problem, although I had to add the company name to the new blank location generated by this routine.
We do not use warehouse control and don't intend to. We rarely print a pick list either(WO-D). The quantities for these parts in this location are 0, and the parts also have the normal balnk location with the correct quantities. Is the fix for this available yet, and without doing the whole 1/12 update? (I never do an update at the end of the month- there is too much going on!)

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: What is going on with the location file???
Reply #5 - 01/31/06 at 14:35:08

Is there any way I could get an answer today- we run the reconcile tomorrow and I am going to get a new location WORK ORDER in the location master file unless I do something to get rid of these phantom locations in BKICLOC today.
I lied when I said we don't print Pick Lists. I don't, but others do, and when I tested it in the test company, WO-D did insert the WORK ORDER location in the BKICLOC file for all the parts printed in the pick list. Sorry for the misleading statement in my previous reply! embarrassed

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

NovaZyg Administrator When all else fails.. Read the instructions. Posts: 789 Gender:	Re: What is going on with the location file??? Reply #6 - 01/31/06 at 20:08:33 There is a patch for that bug, Please contact Lynn.
Back to top	Allen Landry Evo~ERP EvoERP and DBA Classic always Beta's of the Latest versions. IP Logged

joec@adcomminc.com Browser I love YaBB 1G - SP1! Posts: 9	Re: What is going on with the location file??? Reply #7 - 02/13/06 at 12:10:26 NovaZyg, do you have the patch file? Lynn is too busy, I ask her two week ago and still didn't get any answer from her. Thanks!
Back to top	IP Logged

Charlie Klihr

Member

Custom Transformer
Manufacturing

Posts: 66
Gender: male

Re: What is going on with the location file???
Reply #8 - 02/14/06 at 13:00:42

Did anyone get the promised utility program that will "fix" the blank (bogus) entries?
"Keith,

Thanks to you and the "WORK ORDERS" tip, we found the bug, fixed it, then severely chastised the programmer for it. Will be in a patch very soon. and a utility to clean up the bogus entries will soon follow.

Note: The WO-D program is the problem.
« Last Edit: Jan 25th, 2006, 3:08pm by NovaZyg » Logged

--------------------------------------------------------------------------------

Allen Landry
ISTechSupport"

Back to top

Charlie (I'm Too Old For This) Klihr
DBA Classic 2004.1, ISTS 12/28/13
25 Users
Evo~Erp 14 Users, Build- 01/02/14 T7-7iR6
PSQL v11
Crystal Reports v7.0
Windows Server 2008 R2

IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: What is going on with the location file??? Reply #9 - 02/14/06 at 13:33:14 I downloaded and installed the 01/12 update and that fixed the problem -- I suppose if you don't want to load that update for some reason, you could unzip the update to a file and copy the latest bkwod.run program into your dba folder. Lynn, or Alan, would this work?
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Charlie Klihr Member Custom Transformer Manufacturing Posts: 66 Gender:	Re: What is going on with the location file??? Reply #10 - 02/14/06 at 13:34:57 It may have fixed the problem, but it did not do any cleanup....
Back to top	Charlie (I'm Too Old For This) Klihr DBA Classic 2004.1, ISTS 12/28/13 25 Users Evo~Erp 14 Users, Build- 01/02/14 T7-7iR6 PSQL v11 Crystal Reports v7.0 Windows Server 2008 R2 IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: What is going on with the location file???
Reply #11 - 02/14/06 at 13:42:35

Well, I had already been through this once before, when I didn't know what was doing it and I fixed it by doing a global replace UT-K-B in the bkicloc file-- I replaced "work order" with a blank. (There was no work order location in the master file since we had not run the master reconciliation, which will put the location in the master file when it comes across transactions with work order as the location.)

PS field to replace is bkicloc.code

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

JEMM Administrator In two days from now, tomorrow will be yesterday. Posts: 225 Gender:	Re: What is going on with the location file??? Reply #12 - 02/14/06 at 16:24:39 Doing a replace will leave duplicate records in BKICLOC. There is a cleanup utility that will be made available very shortly. Mike
Back to top	« Last Edit: 02/15/06 at 07:53:39 by JEMM » Mike ISTechSupport IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: What is going on with the location file???
Reply #13 - 02/15/06 at 07:50:53

I know I left transactions in the bkicloc file with the replace but the values for the entries were all 0 so I just left them there. I'm sure a clean-up utility would be the better way to get there. Just don't run the reconcile inventory routine before you clean up or you will get a new location in the master file that has to be dealt with also.

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: What is going on with the location file??? Reply #14 - 02/23/06 at 07:06:36 Cleanup utility has been posted - www.istechsupport.com/dl/islocfix.zip. Unzip to DBAMFG and run ISLOCFIX (ISLOCFIX.RUN in Evo) at UT-A. Will delete the "Work Order" location records and, if BLANK is not a valid Location for your company, will also delete Blank Location records.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged