I never complete the archive when I am running the year end routine. Its never caused me a problem but I am wondering if I am missing a trick by not doing it? Can anyone advise the pros and cons?
Thanks loads
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Sage's data is stored internally as a number of related databases - and the more data in them, the longer some reports can take to run (and the more scope there is for something to go wrong, with an error creeping in; a data corruption).
Archiving allows you to retain a prior year's accounts data in an easily accessible form, while pruning the 'live' data to keep the potential for slowness or mishaps to a minimum. (Before the 'archiving' option was added, the only way to access previous year's data if you also wanted to prune the live data would be to restore backups).
That said, for some companies, the amount of data they build up in Sage simply isn't that much, so neither is a significant problem.
(As long as adequate backups are kept!)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Hi Vince
Thanks for the info. I've got a variety of scenarios, one who uses an ancient (and I mean really really old, 2003 ish) sage that has never been archived and is as slow as a sloth, but can't recall now if it's even has the archive option. Was going to look at this and compressing, but hoping to have persuaded them onto dragging them into the 21st century!!
Most of my others are not at the stage whereby it's slowing anything down and I've always pulled loads of reports off and saved them before/ after running the year end reports, but following the archive process is probably a better option. Although no doubt I will still pull the reports.....a habit plus belt and braces backup for me I guess.
Good point on the data corruption, so another reason to use archive option.
You should know I'm the backup Queen......I always have numerous copies of backups, wouldn't be right not to, after telling so many peeps on here to backup, backup and backup again. Plus test them, of course!!! In fact I drive my son mad with my obsessional backing up of things.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
I'm as bad when it comes to back ups, and driven people mad with it.
Some of them have since learned their lesson - when they were bit in the bum by their own lack of back ups when things went wrong. Although one of those, having learnt their lesson and became very good about backing up, has eventually fallen back into old habits. :/
It's closely related/very similar to the perennial security problem: The balance between 'convenience' and 'security' - the more you have of one, the less you have of the other, and most people seem to favour the former until the lack of the latter affects them in some way.
Anyway, to Sage, archives, and pruning old data.
That 2003 one is interesting - because a long time back I dealt with a company who was in that situation. They had a huge amount of data in it, going back many years. Some functions were ridiculously slow, and there were problems showing up on the data validation tool. It was Sage 50 Professional, but I can't remember which version and for some reason, the option to clear old data didn't work; it would only remove a very small fraction of the relevant data. I suspect the data files were so big that it just couldn't cope.
My recommendation was to backup, run off all the key reports, and start afresh, keying in just the opening balances/live data.
As an aside, a downside with archiving is that it does mean the backups just get bigger and bigger each year. If there are no yearly archives, and instead data is pruned and backups for each year taken and kept on hand for access purposes, the backups don't get quite so big. The flip side is that it's less convenient to access the data for those prior years. (So there's another variation on that problem: Smaller backups versus convenience!)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
That 2003 one is interesting - because a long time back I dealt with a company who was in that situation. They had a huge amount of data in it, going back many years. Some functions were ridiculously slow, and there were problems showing up on the data validation tool. It was Sage 50 Professional, but I can't remember which version and for some reason, the option to clear old data didn't work; it would only remove a very small fraction of the relevant data. I suspect the data files were so big that it just couldn't cope.
My recommendation was to backup, run off all the key reports, and start afresh, keying in just the opening balances/live data.
Hi Vince
Have you looked after my client before and they ignored you? Plus probably a few other bookkeepers inbetween until they took this poor defenceless fool on board (ie me!). Actually no - I know you havent as ...what a mess.
Ive suggested exactly the same to them. They have IT support and they have suggested we speak to Sage to do the upgrade to a new one.....I actually used the expression 'but garbage in means garbage out'. Im just trying to clear up the year end (end Feb and a nightmare - much like doing a jigsaw puzzle in the dark,without knowing what the picture is and with a load of pieces missing - oh how I love jisgaws!! ). I actually cant wait to get my sticky mits on a brand new sage to get it right from the start. Although - its still going to be a mahoosive job - one I frankly have no capacity for right now! But who needs sleep hey.
Thanks for the archive info, helps!
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position