Reindex and Compress the relevant module and clear the audit trail to 01/01/1980
NOTE: Before changing the data, take a backup of the data files. For more information about how to back up your data.
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:
- Help > About > Data Information > note the number of splits
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 crashesAreas to ReIndexAreas to CompressTransaction Link Integrity
Ledger Transaction Links
Customer Accounts
Supplier Accounts
Nominal Accounts
Bank AccountsAudit Trail
Customer Accounts
Nominal / Bank Accounts
Supplier AccountsAudit Trail
Sales Ledger
Purchase Ledger
Nominal Ledger
Bank AccountsStock RecordsStock RecordsProductsInvoice RecordsInvoicesInvoicesPrice ListsPrice ListsPrice ListsSOP RecordsSales Orders
Goods Despatched NotesSales Orders
Goods Despatched NotesPOP RecordsPurchase Orders
Goods received NotesPurchase Orders
Goods received NotesGood Received NotesPurchase Orders
Goods received NotesPurchase Orders
Goods received NotesProject RecordsProject Records
Project TransactionsProject Ledger
To ReIndex and compress the data and clear the audit trail to 01/01/1980
- File > Maintenance > Reindex data files.
- Select the relevant files to reindex using the table above > OK > when the confirmation message appears, click Yes.
- Compress Now > clear the Compress All Data Files check box > select the relevant files to compress using the table above.
- Compress > OK > Close > Close.
- Tools > Period End > Clear Audit Trail > Next.
- Enter 01/01/1980 > Next > Next > 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.