Welcome, Guest. Please Login.
11/01/24 at 11:33:40
News:
Home Help Search Login


Pages: 1
Send Topic Print
Archiving (Read 943 times)
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Archiving
09/17/03 at 14:57:46
 
How about some feedback/opinions/maybe even votes of support for creating additional archiving capabilities for things such as the SO history (Invoiced SO's), PO's, and especially the G/L transactions?
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: Archiving
Reply #1 - 09/18/03 at 10:38:28
 
Well, if there was a "Smiley Face" with a sheepish look, I'd use it.  We haven't archived anything yet.  I know I need to look into it to see what we should be doing.
I am sure that any added capabilities can do nothing but enhance the product.
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
susanna
Browser
*




Posts: 3
Gender: female
Re: Archiving
Reply #2 - 12/28/04 at 16:06:55
 
Wink I would love to be able to archive the sales orders
Back to top
 
 
Email   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 379
Re: Archiving
Reply #3 - 12/29/04 at 06:01:57
 
Does DBA Classic automatically archive GL Transactions?
One can only call up GL transaction history (GL-E) for 2 years earlier than current fiscal year start date.   We have been using DBA since 1998 and cannot access GL-E history for calendar years 1998, 1999, 2000, and 2001.  Also, one can only print Financial Statements for the current year and 2 years past.
 
Doesn't this indicate that some sort of archiving is already taking place? ???
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Archiving
Reply #4 - 12/29/04 at 09:19:42
 
lmk223a,
 
No. The GL transactions are not archived automatically. In fact they are not archived at all. The 2 year limit is simply a programmed limitation not a data limitation.
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Archiving
Reply #5 - 12/29/04 at 10:31:03
 
GL Transactions are retained forever unless you run AM-I to consolidate them.  You can see the transactions prior to 2 years past in GL-C and GL-D.
 
As for the other archiving, once a Sales Order is closed, the detail is retained in the Invoice files that came from the order so I am not sure what purpose there would be in a Sales Order archive, it already exists inthe invoice files.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Archiving
Reply #6 - 12/29/04 at 10:43:20
 
Does anyone have an archiving strategy for DBA?  Is it needed?  
 
I'd like to have as much data as possible available for immediate lookup and reporting purposes.  Our DBA folder is currently about a Gigabyte and will have five full years of data in January.  I don't plan to do any archiving unless there is some great speed benefit.
 
Some of our sales reports that look at the transaction files take a while to run but that's propably more due to the report writer than the size of the files.
 
Wondering what other peoples thoughts are ???.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Archiving
Reply #7 - 01/03/05 at 11:36:48
 
Quote from Lynn Pantic   on 12/29/04 at 10:31:03:
I am not sure what purpose there would be in a Sales Order archive, it already exists inthe invoice files.

 
Actually, what the Invoice file shows is Shipments, not orders. If you make multiple shipments from the same SO it can be difficult to reconstruct.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
HB
Full Member
***


I love DBA

Posts: 216
Gender: male
Re: Archiving
Reply #8 - 01/03/05 at 18:09:10
 
here is how I handle "archiving":
I create a company called "03" for year 2003 or "02" for 2002 etc by copying all data form the live company. Then I eliminate all data from years that should not be in that particular year.
Back to top
 
 

Helmut Bode
General Pencil Co.
DBA Classic 2004.1 w/IS Tech update 7/25/13
EVO-ERP
Pervasive 11
Win2008 Server
Terminal Server
12 Users
Email   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Archiving
Reply #9 - 01/04/05 at 07:43:47
 
HB:
 
So by doing this you create a snapshot of each year.  I can see the logic in that but does the "current" company still contain all the data?  Do you have to change companies to look things up?
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
alphadave
Browser
*


I love YaBB 1G -
SP1!

Posts: 15
Re: Archiving
Reply #10 - 01/04/05 at 09:32:22
 
We have been using accounting and manufacturing for about 5 years and have deleted, archived or consolidated very little information due to our ignorance on the pros and cons. A white paper or a detailed description of what can be done, when it can be done, and what you gain and lose would be great. (I think our files total about 1 gig.)
Back to top
 
 
  IP Logged
HB
Full Member
***


I love DBA

Posts: 216
Gender: male
Re: Archiving
Reply #11 - 01/04/05 at 12:31:36
 
We like to retain SO and Invoices for 2 years (that means we have a total of 3 years by the end of every year).  
The copy of the company contains 3 years if it was created on Jan 1 of a new year.
Example:
Our current live company contains info for 2002, 2003, 2004 on Jan 01.  
I have created a company called "02" with data containing 02,03 and 04.
After creating the new "02" company I will purge from the live company data pertaining to 2002 (SM-J-J and SM-J-K etc).
This leaves me with data for 2 years, i.e. 2003 and 2004 plus new data from 2005 in the live company.  
 
I repeat above steps at the end of 2005
Back to top
 
 

Helmut Bode
General Pencil Co.
DBA Classic 2004.1 w/IS Tech update 7/25/13
EVO-ERP
Pervasive 11
Win2008 Server
Terminal Server
12 Users
Email   IP Logged
Pages: 1
Send Topic Print