Welcome, Guest. Please Login.
05/11/25 at 15:44:46
News:
Home Help Search Login


Pages: 1
Send Topic Print
DELETE PART NUMBERS (Read 2031 times)
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
DELETE PART NUMBERS
06/09/14 at 09:38:01
 
Good morning,
What is the best way to delete part numbers? Some of the items we want to erase have history. We want to know the best practice as recommended by IS tech.  
 
Thanks!
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: DELETE PART NUMBERS
Reply #1 - 06/09/14 at 10:01:28
 
Why don't you make the Obsolete?
 
 Cool
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: DELETE PART NUMBERS
Reply #2 - 06/09/14 at 11:30:26
 
Thanks Kelloggs! We have a lot of obsolete parts right now, I think we are trying to get rid of some of those as well.
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: DELETE PART NUMBERS
Reply #3 - 06/09/14 at 12:05:26
 
You can use SM-J-L to transfer the inv tran, bom, etc, etc to a new Part ID
 
Then you can delete the "old" Part ID.
 
See if that would work for you.
 
 Wink
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: DELETE PART NUMBERS
Reply #4 - 06/10/14 at 07:25:30
 
If you make them Obsolete, you can archive them using IN-L-O which removes them from the live database.  What Kellogs is suggesting just turns them into something else, doesn't really get rid of them.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: DELETE PART NUMBERS
Reply #5 - 06/10/14 at 07:38:58
 
Thank you so much!!!
Back to top
 
 
  IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: DELETE PART NUMBERS
Reply #6 - 06/10/14 at 16:04:03
 
I don't see any reason to ever delete company history.
 
You may not need that info but someone may need it some day.
 
Back to top
 
 
WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: DELETE PART NUMBERS
Reply #7 - 06/11/14 at 14:14:54
 
I agree with shadowcaster.  I prefer to make a new company and then archive the older stuff.  Then I still have the old stuff unarchived on an earlier company.
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
Pages: 1
Send Topic Print