There is nothing quite like that sinking feeling you get when you run a Sage Data check and find there are Errors in your Sage Data. We go months with no one having any problems at all – then have some months where we get several enquiries close together. Sage errors can happen at any time and usually when you are least have time for them.
If you are a Sage 50 or Sage Instant user and don’t actually know what I am talking about – then you need to learn some Sage housekeeping basics.
But what can you do if your Sage 50 or Sage Instant Accounts data has errors?
First things first – don’t panic.
First of all – take a backup of your data, so that if anything goes wrong with your attempts to fix the data you can always get back to how your accounts look today. I would change the name of the file to include ‘with errors’ in the name, so as to easily identify it.
If you have a version of Sage older than Sage 50 2012 you can use the Fix button on the File Maintenance report to attempt to fix the data. This often fixes the problem by Sage rebuilding your data again from scratch using your original transactions. If you ‘Fix’ the data and no errors show up when the data check is run again then you can carry on as usual. I would make sure, though, that bank balances are correct and would check balances on all or a random selection of customer and supplier accounts, just to make sure everything is OK.
In Sage 50 2012 and newer versions you are faced with the new Recovery Tools option. Next to Recovery Tools is a link called “How to fix errors & warnings in your Sage data” which takes you to the My Data area on the My Sage website. Here you will find information on how to avoid corruption, a list of non-fixable errors, and Sage’s Data Repair Service. There are also links to help articles about data repair and updating your software . To access this help, you will need to have a login to the Sage website set up; if you don’t have Sage Cover then you will not have access to some of these areas and links, in which case your local Sage Reseller will be able to help you out.
If you click on the Recovery Tools option you will first be prompted to take a backup before you can do anything else. The following screen then gives you 8 options of tools which could fix your data. You do get guidance on which area the error is in so it should be fairly obvious which tool is required.
If your attempts to fix your data fail, and you still have errors listed, then you can go back to your last clean backup (one with no errors) and restore the data. You will then need to re-key any data that you had entered since that date. There are more tricks which are too detailed to go into here.
If you do not have a clean backup, or the time taken to re-key data is just not practical, then we do offer an alternative to the Sage Data Repair Services through a business partner who was a developer at Sage for many years. The service offered is cheaper than Sage and the data in previous cases has been fixed out of hours for us and returned to the client for the next morning, meaning any disruption could be kept to a minimum. This depends on the availability of our business partner.
So, if you have errors in your data, don’t panic, but do something about it to remove them. For further advice on steps to take, have a look at the Leyburn Solutions Website.