Reindex and Compress the relevant module and clear the audit trail to 01/01/1980
NOTE: Before changing the data, back up your data files.
Make a note of the area being checked when Sage Accounts hangs or crashes. The following table advises which areas to ReIndex and Compress:
Before running the reindex and compress routine, make a note of the number of splits. This equates to the number of lines of transaction information in the data. To do this:
- Go to Help then About. Note the number of splits in the Data Information section.
After the reindex and compress routine, check the number of splits again; if the number has changed, the data hasn’t been fixed, and you’ll need to either restore an error-free backup or arrange for the data to be repaired at Sage. For more information about sending your data in for repair, contact Sage technical support.
| Area in which check data hangs or crashes | Areas to ReIndex | Areas to Compress |
| Transaction Link Integrity Ledger Transaction Links Customer Accounts Supplier Accounts Nominal Accounts Bank Accounts | Audit Trail Customer Accounts Nominal / Bank Accounts Supplier Accounts | Audit Trail Sales Ledger Purchase Ledger Nominal Ledger Bank Accounts |
| Stock Records | Stock Records | Products |
| Invoice Records | Invoices | Invoices |
| Price Lists | Price Lists | Price Lists |
| SOP Records | Sales Orders Goods Despatched Notes | Sales Orders Goods Despatched Notes |
| POP Records | Purchase Orders Goods received Notes | Purchase Orders Goods received Notes |
| Good Received Notes | Purchase Orders Goods received Notes | Purchase Orders Goods received Notes |
| Project Records | Project Records Project Transactions | Project Ledger |
To ReIndex and compress the data and clear the audit trail to 01/01/1980
- Go to File, then select Maintenance, then Reindex data files.
- Select the relevant files to reindex using the table above then click OK.
- When the confirmation message appears, click Yes.
- Select Compress Now, clear the Compress All Data Files check box, then select the relevant files to compress using the table above.
- Click Compress then OK.
- Click Close then Close again.
- Go to Tools, then select Period End.
- Select Clear Audit Trail then Next.
- Enter 01/01/1980, select Next, then Next again.
- Select Exit.
If the issue still occurs or the ReIndex and Compresses option hangs this indicates the data is corrupt. We recommend that you restore a backup of your data before the issue occurring. For more information about how to restore your data.
As a last resort you can send your data into us to be fixed. When we repair data it may involve removing several transactions; however, we may not be able to provide details of the removed transactions. Also stop processing during the repair. If you restore a backup, it may result in less time to reprocess the transactions compared to sending the data in.
For more information about sending your data in for repair, contact Sage technical support.