My experience with Company Data Archive from Professional Advantage was overall good. The gain in speed from removing all of the prior years (first pass removed 8 prior fiscal years) was even better than I expected. Many of the GP users were unhappy with their experience using GP because of the extreme latency in populating some inquiry screens and reports. All of that disappeared after the initial archiving was completed.
Another motivation to implement the Company Data Archive was that we were preparing to upgrade from v9.0 to v2010. We benchmarked the data conversion process with results that were completely unacceptable. After CDA, the benchmark time was about 20% of the unarchived database.
Now, each year, when year-end closing is complete, we have the new open year and two prior years. At that point, CDA is run to remove the oldest closed year, keeping us in the best possible condition for daily operations.”
Application Support | Project Management Institute, Inc.
We started using Professional Advantage Company Data Archive for G/L and Purchasing/AP in 2015. The archived database is set up as an "Archive" company. We kept 4 years plus the current year in the production database. Otherwise, there would be a lot of switching back and forth between company databases. There is an inquiry option in Purchasing/AP (Multiple Company Payables Transaction Inquiry) that comes with the software that allows you to see your production company and archive company on one screen. Very nice!
Project Accountant | Consumer Support Services, Inc.