Sage 50 Crash on VAT Reconciliation

[arazas]

I am running Sage 50 Professional v28.1.404.0

While calculating VAT Return, when progress bar reaches to "Validating Audit Trail VAT Values", after about 50-80% completion on progress bar, Sage is crashing (program closing automatically).

I am able to run VAT return trouble free in other companies including demo data.

I did run CHECK DATA several times, and maintenance tools. Even re-indexing of all one by one but no luck.

From VAT menu I am able to pull VAT audit trail reports without an error.

But when running VAT return, Sage crashing itself. I am unable to fix and need technical advise.

If I do not select option include reconciled vat transactions, then vat return may give results, but moment i click on reconcile vat, program crashes.

please guide

[brucedenney]

Looks like you have a lot of transactions in the Audit Trail.

It could be a subtle data error.

If you have a lot of very old transactions, then clearing some of the audit trail might get it to work, however, there are some substantial risks involved as you need to make sure that you will not clear anything entered since the last year end was done, even backdated transactions must be left in place. So act with extreme caution and check the TB does not change.

Take a full backup first because it is quite likely things may get worse before they get better.

If you still can't get it to work, then you could use my data fix service.
https://www.makingithappen.co.uk/sage-s ... ervice.htm