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.