Welcome, Guest. Please Login.
11/02/24 at 09:24:29
News:
Home Help Search Login


Pages: 1
Send Topic Print
Missing records (Read 489 times)
RPCAdmin
Active Member
*****


Please save me from
the Users!!!!!!!

Posts: 521
Gender: male
Missing records
12/07/09 at 06:50:29
 
I have been noticing some strange behavior.  Sometimes, receiving will try to PO-C a part on a PO...or Purchasing will try to enter a part onto an PO (not sure if I remember if there are problems with entering the part on an SO) and they will get an error that the part cannot be received or entered because there is no record in MTICMSTR.  I look, and sure enough the part is not in that file (even though I know it exists in the system).  I then do an IN-B, the part exists, but there is no entry in the used defined field.  I enter the correct user defined field and save the part and now the part is in MTICMSTR and can be received or ordered.
 
What is strange is that very few people here use IN-B and they all know that the user defined field should be filled in. (now people can of course make omissions, but I am wondering if this is an indication of something funny going on in the background (something getting deleted by DBA/EVO?))
Back to top
 
 

Mike Nessen
Sr. Engineer/IT Manager/Anything else I need to be
EVO-Erp Build (always the latest) Client/Server
Pervasive 2000i on NT4 Server 15 users
Email 272531373   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Missing records
Reply #1 - 12/07/09 at 08:00:36
 
Each item has a record in BKICMSTR, MTICMSTR, and BKILOC (at least) and what you are experience is data loss from the MTICMSTR table, where some of the item info is stored. It may be time to do some maintenance like reindexing and cleaning up the binary zeroes. I have lost a few records over time from one or the other nnICMSTR table. It is disconcerting, but it seems to happen much less often after maintenance.  
 
Hopefully Lynn will make a more detailed recommendation than my vague answer above :/
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: Missing records
Reply #2 - 12/08/09 at 21:41:20
 
in addition, i would reccommend running the Master Inventory Reconciliation SM-J-C. that will add record back to MTICMSTR IF the Item Record is already in the BKICMSTR.
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print