Sage 50 Accounts V28 Data Corruption but no error messages or warnings

I have a client company on Sage 50 v 28.02  running through RDA (have several but only one with this issue)  Autoentry posted about 100 supplier invoices over today, the desktop sync is on our server, some of them were showing as posted on the client site, some were not.  I logged into our server and found that once again the Sage company needed the Sage ID entered for authenticating again!! so much for every 90 days.

Anyway I authenticated and logged in, the data synced through the RDA to the various sites, then I could see all the invoices in the transaction window but noticed a lot of the invoices were not pulling through to the VAT Return, I looked into one of the supplier accounts which had most of the invoices posted today and none of the invoices posted showed in the account.

I ran the check data and got the usual errors about headers not linked to ledgers, I ran the recovery tools and then another check data and all errors were cleared, at this point the supplier account that had the obvious issue did have an increase in the balance due by the invoice amounts but still none of the invoices showed in the account or pulled through to the VAT Return.

I thought I would try editing one of the supplier invoices to move it to another supplier account to check if it would show in there, it didn't so changed it back to the original account, oddly the two deleted transactions now show in both accounts but the live transaction still does not show.

I have now ran the reset transactions recovery tool and still no joy.

I need suggestions as to why this has happened, how to fix it and hopefully not have it happen again.  I really do not want to have to export the audit trail, restore the backup and import the transactions as we also have bank feed imports and reconciles that will all have to be done again and the VAT Return has to be lodged by Friday.