"Out of Memory" when trying to do the VAT return

SOLVED

Hi

I'm trying to do the VAT return but it gets half way through running it and then stops and gives me the error message "out of memory". The only option is then to press ok. The box disappears and then sage has crashed so i have to force quit out and start again.

I spoke to sage and they suggested it was because we have too much data which is slowing it down and making it hard for it to run. They told me i should do a clear audit trail.

I know we have a huge amount of data but honestly with the amount of times we have problems with sage i dont really want to start deleting data as i just dont trust it. 

Has anyone else had this issue? Is there another way around fixing it without deleting old files?

Thanks!