Sage 2012 - Database corruption - Invoices 'missing'

[ontracks]

Good Morning Bruce and All,

We recently upgraded to Sage Line 50, 2012.
We have a multi user application of the Financial Controller version.
Current version is (it updated with update patch No 6 this morning after we spotted this problem last week). 18.1.0.20

We use Windows 7 PC running the 64 bit version.
We switched in November 2011 from Sage 2010.

We use the system heavily from products and stock records to SOPs created from our website and from that invoices and accounts/VAT.

We've had two strange data corruption issues, first one was a block of 9 sequential SOPs suddenly had the wrong products listed on the body of the SOP compared to what had been originally set up on them. Although the SOP value total was showing the correct original figures. Data maintenance could not fix the problem. We paid for sage support, sent to them for fixing and they returned the file with 99% of all live and open SOPs deleted as their only 'fix' of the data!
So Sage refunded the Support fee and we re-created the SOPs manually from back up records.

This week we've found a more worrying problem and think we again have a serious data corruption issue. We've run Data Maintenance and it's not fixed the problem.

We have 10 invoices waiting for payment from a particular customer - they are spread over the last 2 months. All the invoices are showing on the Invoice screen and have been posted.
If we run a statement 4 of the invoices do not show on the statement. They are not immediately sequential numbers (i.e. other customers have been invoiced between them) but are all the invoices spread across a 20 day period. Invoices earlier and later appear on the statement.

We've then checked the outstanding £ balance and our total excludes these missing invoices.
We've looked at the transaction log and the invoices are missing from this log - not deleted just missing. Transactions on the log either side of these invoices are there.We don't use the edit log tool, so we never attempt to delete transactions etc. We don't use any 3rd party integrations except two tools which pick up CSV files and import them as SOPs. We've been using them for 8 plus years and both work fine with the new version after they were upgraded and tested by the original suppliers.

As the invoices have been updated we can't try to repost them, and obviously I am worried that although we've found one customer effected in this way, it could effect others or may do so in the future.

I'm not convinced paying Sage to look at the corruption is worthwhile after my last experience, so can I ask for some advise (and possibly paid help)
1. Has anyone heard of problems with the data integrity of the latest version of Sage line 50 2012?
2. Can someone help resolve this problem and suggest how we can monitor future issues of this type?

Thanks
Tim

[brucedenney]

All versions of Sage have corruption issues.

V2012 is a lot better than most.

You are not the only people with this sort of corruption.

Check data needs to be run for every backup, if there are any errors, you need to be prepared to restore the previous backup and the fix routines do not always work.

Don't add more data into a broken data set.

It sounds to me as if some sales invoices have not got posted from the invoicing module into the financials module.

I would reconcile the two as follows:-

Send all the invoices to excel from the Financials module

Sort them by invoice ref.

Add a formula to subtract this inve ref from the previous line inv ref, this should return a column of nothing but 1's (as they are all one more than previous)

Use a filter to hide all lines with 1 thereby showing up any potential errors.