01604 420057



A highly experienced IT services team that will go the extra mile for you

Argh! Sage Data Errors! What Shall I Do?

First things first, don't panic ...


POSTED BY ALISON MEAD ON 26/11/2018 @ 9:00AM

There is nothing quite like the sinking feeling you get when you run a data check and find you have Sage data errors. We go months with no one having any problems at all then have we get several enquiries close together ...

If you're getting Sage data errors and are wondering what to do then don't panic!

If you're getting Sage data errors and are wondering what to do then don't panic!

copyright: dolgachov / 123rf

Sage data errors can happen at any time and usually when you are least have time for them. If you are a Sage 50 user and don't actually know what I am talking about then you need to learn some housekeeping basics. But what can you do if your Sage data has errors?

"First things first, don't panic!"

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, 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 fine.

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 useful 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.

"How do the Sage Recovery Tools work?"

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 eight options 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 the attempt to fix your data fails, 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 it will take 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, but it is worth calling us and asking for our opinion.

"Would you like to know more?"

So, if you have Sage data errors then don't panic, but do give me a call on 01604 420057 or click here to ping me an email and let's see how I can help you.

Until next time ...



If anything I've written here resonates with you, why not visit  www.siliconbullet.com to discover how we can help you?

Share the blog love ...

Share this to Google+Share this to FacebookShare this to TwitterShare this via BufferShare this to LinkedInShare this to Pinterest
Click here to Share, Email or Bookmark this website

Précis (0)

More about Alison Mead ...

Alison loves bookkeeping. She has been helping clients to be better bookkeepers in Sage 50 for over 22 years and has more recently added Xero Accreditation to her list of skills.

She specialises in a very unique hand-holding method of training, helping bookkeepers and business owners to use their accounts software as and when they need support in setting up and producing their invoices, reports and financial information.

Alison combines her role at Silicon Bullet with running two network marketing businesses and is also a Regional Leader for 4Networking as she likes to keep busy.

You know what they say, if you want something done well ask a busy person!


01604 420057



More blog posts for you to enjoy ...

Why Use Access Rights In Sage 50?
Single-user or multi-user?

Are You Using The Right Version For Your Sage Cover?
You really should check ...

Sage 50 Invoice CSV Import Tool
A great add-on from Adept ...

Good Housekeeping In Sage 50
You can avoid the costs of data repair ...

HMRC And The Art Of Reactive Tax Codes
Be sure to check for W1 M1 ...

Sage Instant Crashing When Running Year End
This only happens on Windows 10 ...

Choosing An Accounts Package For Your Business
There are many options available ...

What Needs To Go On An Invoice?
And why is it so important?

By Category ...

Case Studies (5)

General (5)

Guest Posts (1)

Sage (5)

Windows (1)

Xero (1)

By Popularity ...

VAT, Making Tax Digital And Sage 50

Silicon Bullet: Welcome To Our Bran ...

How To Correctly Post Your Salary J ...

The Importance Of Windows Updates

Are You Using The Right Version For ...

Case Study: MD Autocare Vs Sage Dri ...

Sage 50 Invoice CSV Import Tool

Argh! Sage Data Errors! What Shall ...

Guidelines For Company Functions An ...

Why Use Access Rights In Sage 50?

Quote of the day ...

"When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile"

Login ...

Remember me