Welcome, Guest. Please Login.
05/08/25 at 07:17:06
News:
Home Help Search Login


Pages: 1
Send Topic Print
part# will not stay active? (Read 1008 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
part# will not stay active?
06/18/03 at 13:04:04
 
I have some part#s that are unfindable when I search by item#, or class, or any search variable  in IN-B.
 
They can be found if you go to the item that is chronologically after the desired item and press F7. or if you go to a prior item and scroll with F8.
 
They can also be found if you go to print Vendor prices.
 
When you find them by scrolling F7 or F8 thru IN-B, they show inactive and the class description is blank, until you enter down to the part# description, and then the active is now Y and the class description is displayed.
 
But I can't get it to stay that way!!!
 
 F10ing after flagging as ACTIVE and having the class description displayed  does nothing.
 
Any and all help appreciated.
 
Thanks,
Laura
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: part# will not stay active?
Reply #1 - 06/21/03 at 10:37:24
 
I would suggest some database maintenance on the primary part master databases BKICMSTR and MTICMSTR, as well as on the CLASS database, as it sounds like the db's are not reading quite correctly.
 
Just like a machine, databases require some regular maintence.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: part# will not stay active?
Reply #2 - 06/23/03 at 06:16:38
 
What are the various routines that should be performed?  How often?
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: part# will not stay active?
Reply #3 - 06/23/03 at 07:57:26
 
Try Reconcile Inventory (SM-J-C in 2002.4).  It sounds like the BKICMSTR record exists but the MTICMSTR does not.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: part# will not stay active?
Reply #4 - 06/23/03 at 11:54:23
 
I would also suggest the Pervasive database Rebuild routine.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Pages: 1
Send Topic Print