| | Description | The integrity of your data is really important to ensure your financial values are correct. Data corruption is a serious risk to any business and any resulting data loss can be very costly. You can use the options within Recovery Tools to repair corruption in your data, reducing the risk and ensuring the integrity of your data is intact.
|
| Resolution | How to access the Recovery tools- Ensure all other users are logged out of the relevant company in Sage Accounts.
- On the menu bar click File, then click Maintenance.
- Click Recovery Tools then in the Backup window take a backup of your data, then click OK.
 NOTE: The Recovery tools option is not available at a Remote Data Access remote site, it is only available at the main site.
The Recovery Tools window appears:
- Click the option you want to run, then click OK
- Repeat step 4 for any other option required, then click Close.
- When prompted to check your data, if required click Yes, if not click No.
- Click Close, then click Close.
What each option does >
| Reindex and Compress All | This rebuilds the information in the index data files for the following:- Customers
- Customer Delivery Addresses
- Suppliers
- Supplier Delivery Addresses
- Company Delivery Addresses
- Nominal Ledger
- Bank
- Invoices
- Sales Orders
- Purchase Orders
- Projects
- Project (and Project Only) Transactions
- Products
- Advanced Budgets
- Contact Histories
- Audit Trail (splits)
This corrects any potential problems with the index data files. It also compresses all of the data files to ensure they are the correct size for the amount of data they hold. |
|---|
| Recalculate Transaction History | This is the equivalent of running a clear audit trail to 01/01/1970. It rebuilds the balance of all records which have transactions assigned. |
|---|
| Recalculate Period Values | This recalculates the following:- All values in the Sales tab within each customer record
- All values in the Purchases tab within each supplier record
- All values in the Details tab within each nominal record
|
|---|
| Reset Transaction Status | This checks for any transactions which should be allocated but are not and changes the transaction type as follows:- SR becomes SA
- PP becomes PA
- SD becomes SC
- PD becomes PC
|
|---|
| Recalculate Order Allocations | This resets the Allocated and On Order box values within all stock records, using the sales order, purchase order and project allocation values. |
|---|
| Recalculate Stock | This is the equivalent of running clear stock to 01/01/1970. It links all stock transactions to the correct stock records. It also resets the Assembly Level and Link Level in the BOM tab on all stock records and recalculates the stock quantities. |
|---|
| Recalculate Project History | This rebuilds the project transactions and recalculates the values in the Analysis tab on all project records. NOTE: The project audit trail is renumbered when you run this process. |
|---|
| Recreate CIS History | If any CIS Returns have not submitted correctly, this option removes them from the CIS data files. |
|---|
| Reset Bank Reconciliations | This tries to fix corruption related to the Reverse Bank Reconciliation files as follows:- If a non-reconcilable transaction contains a reconciliation ID, it removes the ID
- If an unreconciled transaction contains a reconciliation ID, it removes the ID
- If a reconciled transaction contains a reconciliation ID, but no bank reconciliation record exists for that ID, it removes the ID
- If a bank reconciliation record has no links to any transaction, it removes the record
- If a bank reconciliation record has no links to any bank, it removes the record
|
|---|
[BCB:101:Limitless - 50 Accounts - Data Corruption / Maintenance:ECB]
|
|