Welcome, Guest. Please Login.
05/24/25 at 13:21:07
News:
Home Help Search Login


Pages: 1
Send Topic Print
SM-J-J  Cons of purging Sales Orders (Read 970 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
SM-J-J  Cons of purging Sales Orders
11/05/10 at 10:46:24
 
What  (if any) are the cons of purging SOs?
How often should this be done?
How many years should I keep before purging?
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: SM-J-J  Cons of purging Sales Orders
Reply #1 - 11/05/10 at 11:29:40
 
If you updated to the current version you would have the option of archiving rather than purging which would clean up the clutter in the active file but keep the closed orders available for reference.  That said, there really isn't much risk with purging the old closed sales orders because all the important information relating to what was actually shipped is in the Invoice files and purging or archiving sales orders does not touch the invoice files.  As for how far back to keep, everybody is different.  It depends on how much you are likely to go back and look at a closed order and if you do that a lot, can you retrain yourself to use SO-H that looks at the invoice(s) that came from the order rather than SO-A/SO-T to look at the order itself.
Back to top
 
 

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




Posts: 985
Gender: female
Re: SM-J-J  Cons of purging Sales Orders
Reply #2 - 11/06/10 at 06:35:56
 
Myfolks are complaining that it takes too long to print an acknowledgement.  
1) Does purging SOs make printing Acknowldgements faster?
2) Would this new option of archiving SAles Orders make printing Acknowledgement faster?
3) what else would make printing Acknowledgements faster?
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: SM-J-J  Cons of purging Sales Orders
Reply #3 - 11/06/10 at 08:41:58
 
If you are printing Acknlowledgements one at a time or a range of consecutive orders together and specifying the Sales Order number(s) then it is using the index and the number of records in the file really shouldn't matter.   Reindexing BKARINV might help.
 
Purging or archiving sales and work orders will speed up the Rebuild Stock Status that occurs in IN-A and is an option on a number of reports.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print