ISTech Support Forum - Missing record in BKICLOC

Welcome, Guest. Please Login.

	05/14/25 at 08:20:11 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›

Pages: 1

Missing record in BKICLOC (Read 1013 times)

Cyndee Pappas

Senior Member

EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female

Missing record in BKICLOC
05/08/06 at 14:46:50

We have 1 part which has no BKICLOC record. All UOx fields are 0 in BKICMSTR and MTICMSTR. There should be On Hand and on Allocation. There is 0 qty everywhere in IN-A, but the book value is still there.

We have only 1 (blank) location.

All was well last Monday, when I ran the end of the month inventory value report. On Tuesday, I installed the 2/28/06 update. No errors reported. And no other problems found since then. Book value matches GL and Avg cost x units is off by the exact amount of this part's book value, so looks like an isolated incident.

How do I fix it? If Maintain Database, which files?
Do I need to run the Reconcile inventory program?

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

IP Logged

Keith

Full Member

I love YaBB 1G -
SP1!

Posts: 106

Re: Missing record in BKICLOC
Reply #1 - 05/17/06 at 08:57:22

Cyndee,

This has been happening to me for the last 3 month's and I can't get the issue resolved. For me it's "F" type items and I narrowed it down to happening when using the "convert sales orders to work orders" routine. It's gotten so bad that I had to create a crystal report to compare the BKICLOC records to transaction records and item master records so that I can keep on top of it.

For the time being I add the part(s) back to the location file with IN-L-B (this will fix the IN-A screen - eg SO's, WO's etc) then need to edit the newly created BKICLOC record for the actual units on-hand.

Hope this helps....

It's been frustrating me for a while now....... Angry

Keith

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

IP Logged

JNAPIER Active Member Evil-Evo Bad Dog! Posts: 533 Gender:	Re: Missing record in BKICLOC Reply #2 - 05/17/06 at 10:03:46 Have you tried WO-L-F and say YES to rebuild stock status? I don't have this problem so I am just guessing! J
Back to top	EVO-ERP, ISTS 3.27.08 , 2000I 10 user IP Logged

Cyndee Pappas

Senior Member

EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female

Re: Missing record in BKICLOC
Reply #3 - 05/18/06 at 08:47:51

Quote from Keith on 05/17/06 at 08:57:22:

It's gotten so bad that I had to create a crystal report to compare the BKICLOC records to transaction records and item master records so that I can keep on top of it.

Keith

Would you be willing to share your Crystal report? My email is cpappas@industrialdata.com

Anyone else having this problem? Records just disappearing really freaks me out!

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

IP Logged

Cyndee Pappas

Senior Member

EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female

Re: Missing record in BKICLOC
Reply #4 - 05/22/06 at 11:05:48

Quote from JNAPIER on 05/17/06 at 10:03:46:

Have you tried WO-L-F and say YES to rebuild stock status? I don't have this problem so I am just guessing!

J

Thought I replied to this earlier, but I don't see it. For the record, the WO-L-F rebuild (or IN-D rebuild) does not help. The BKICLOC record is completely missing, not just blank.

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

IP Logged

JEMM Administrator In two days from now, tomorrow will be yesterday. Posts: 225 Gender:	Re: Missing record in BKICLOC Reply #5 - 06/02/06 at 07:31:23 Keith, thanks to your help we were able to the fix the problem with SO-N that was causing some of the BKICLOC records to go missing. Cyndee, we found the problem in SO-N that was causing the program to occasionally hang. Mike
Back to top	Mike ISTechSupport IP Logged

Cyndee Pappas Senior Member EVO~ERP 2006.1 02/28/06 update Posts: 258 Gender:	Re: Missing record in BKICLOC Reply #6 - 06/02/06 at 07:50:14 Excellent!! I'll watch for it in the next release. Thanks, Cyndee
Back to top	« Last Edit: 06/02/06 at 13:16:56 by Cyndee Pappas » Cyndee Pappas Industrial Data Systems EVO~ERP 2006.1 with 02/28/06 update Client/Server Win2000 Server Pervasive SQL 2000i IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›