Using the Rebuild option
Description

 TIP: We've made enhancements to this feature. If you aren't using v31 or above already you can update now > 

NOTE: Use Rebuild at your main data site when accessing data via Remote Data Access. Avoid using Rebuild to create a new company from a backup, as each Sage Accounts company has a unique ID. Copying and rebuilding can cause ID conflicts, leading to issues with SData and Remote Data Access.

The data files you can remove using Rebuild

When you open the Rebuild option, all of the following data files are automatically selected to be kept, but can be removed as required:

 TIP: Some options are dependent on other options. Where this applies, the related options will automatically select or disable as appropriate.  

Files to keep Effect within Sage Accounts Also Removes
Advanced budgets If you keep your Advanced budgets, these values remain when rebuilding your data. If you clear this check box, no other check boxes are automatically cleared.
Fixed assets When you rebuild, your fixed asset register will remain unchanged. If you clear this check box, no other check boxes are automatically cleared.
Bank feed rules Leaving this option ticked means your bank feed rules will remain after rebuilding. If you clear this check box, no other check boxes are automatically cleared.
Bank reconciliations (saved) Leave this option ticked to retain your completed bank reconciliations when rebuilding.  If you clear this check box, no other check boxes are automatically cleared.
Bank remittances Your bank remittances won't delete during the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Chart of accounts When you rebuild, your Chart of accounts will be preserved in the rebuilt data. If you clear this check box, no other check boxes are automatically cleared.
Cheques Any cheques entered into your data will remain after the rebuild.  If you clear this check box, no other check boxes are automatically cleared.
Column settings Any default column settings you've changed will be retained after the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Countries list Your countries list will remain unchanged after the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Customer records If you select to keep your customer records, all of the records will remain. The transactions related to these records only remain if you also select to keep transactions.

If you clear this box, the following boxes are automatically cleared:

  • Advanced budgets
  • Bank reconciliations
  • Bank remittances
  • Cheques
  • Invoice Payment failures
  • Matched Opayo customers
  • Project transactions
  • Transactions
Deletion Log If you select to keep your deletion log, when you run the Cleared Audit Trail Reports, all of the removed transactions appear on this report. If you clear this check box, no other check boxes are automatically cleared.
Diary Events If you select to keep your diary events, when you open the Diary module, all of the events remain. If you clear this check box, no other check boxes are automatically cleared.
Goods despatched notes If you keep your GDN's, they will remain after the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Goods received notes This option toggles if your GRN's are retained during the rebuild or not. If you clear this check box, no other check boxes are automatically cleared.
Invoice Payments failures Your Invoice Payments failures list will remain unchanged after the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Invoice Payments foreign settings Your settings for Invoice Payments, specific to foreign transactions are retained after the rebuild. If you clear this check box, no other check boxes are automatically cleared.
Invoice Payments settings Your main Invoice Payments settings won't delete during the rebuild.  If you clear this check box, the Invoice Payments foreign settings check box is also cleared. 
Invoices If you select to keep your invoices, when you open the Invoicing module, all of the records remain. This does not affect the sales invoice or sales credit transactions created when you posted the invoice or credit. If you clear this check box, no other check boxes are automatically cleared.

Matched Opayo Customers

If you select to keep your matched Sage Pay customers, when you download transactions through Opayo it retains the matched email addresses. If you clear this check box, no other check boxes are automatically cleared.
Nominal Account records If you select to keep your nominal accounts, when you open the Nominal or Bank modules, all of the records remain. The transactions related to these records only remain if you also select to keep transactions.

If you clear this box, the following boxes are automatically cleared:

  • Advanced budgets
  • Bank feed rules
  • Bank reconciliations
  • Bank remittances
  • Chart of Accounts
  • Cheques
  • Invoice Payment failures
  • Invoice Payments foreign settings
  • Invoice Payments settings
  • Project transactions
  • Transactions

Project Records

If you select to keep your project records, when you open the Projects module all of the record remain. If you clear this check box the Transactions and Project Transactions check boxes automatically clear.
Project Transactions If you select to keep your project transactions the activity remains on all of your projects If you clear this check box, no other check boxes are automatically cleared.

Purchase Orders

If you select to keep your purchase orders, when you open the Purchase orders module, all of the records remain. This does not affect any supplier invoices created when you updated the purchase order. The Project Transactions and Goods received notes check boxes also automatically clear.
Recurring invoices If you keep recurring invoices, they will remain after the rebuild completes. If you clear this check box, no other check boxes are automatically cleared.
Recurring purchase orders If you keep recurring purchase orders, they will remain after the rebuild completes. If you clear this check box, no other check boxes are automatically cleared.
Recurring sales orders If you keep recurring sales orders, they will remain after the rebuild completes. If you clear this check box, no other check boxes are automatically cleared.

Sales Orders

If you select to keep your sales orders, when you open the Sales orders module, all of the records remain. This does not affect the invoices created when you dispatched the sales order. If you clear this check box, the Goods despatched notes check box clears.
Stock records If you select to keep your stock records, when you open the Products module, all of the records remain. The transactions on these records only remain if you also select to retain stock transactions. If you clear this check box, the Stock Transactions and Project transactions check boxes automatically clear.
Stock Transactions If you select to keep your stock transactions, all of the stock history remains on the Product Records. The Project Transactions check box is automatically cleared.
Supplier records If you select to keep your supplier records, when you open the Suppliers module, all of the records remain. The transactions related to these records only remain if you also select to keep transactions.

If you clear this box, the following boxes are automatically cleared:

  • Advanced budgets
  • Bank reconciliations
  • Bank remittances
  • Cheques
  • Invoice Payment failures
  • Project transactions
  • Transactions
Transactions If you select to keep your transactions, when you open Transactions, all of the records remain.

If you clear this box, the following boxes are automatically cleared:

  • Advanced budgets
  • Bank reconciliations
  • Bank remittances
  • Cheques
  • Invoice Payment failures
  • Project transactions

Rebuild your data

 NOTE: The Rebuild option is not reversible. Ensure you take a backup of your data before proceeding. Learn how to Back up your data.

Print essential reports, such as:
  • Aged Debtors analysis (Detailed)
  • Aged Creditors analysis (Detailed)
  • Bank report - Reconciled and unreconciled
  • Audit Trail Detailed
  • Trial Balance - For the final period
  • Profit and Loss
  • Balance Sheet
  1. Click File then click Maintenance and confirm Yes to close any open windows.
  2. Click Rebuild.
  3. Click Backup now and take a backup.
  4. From the list of Files to keep, clear the check boxes for any data files you want to remove.
  5. If you've selected to rebuild your Nominal account records, select the appropriate Accounts structure in the section at the bottom.
  6. Click OK.
  7. Click Yes.

     NOTE: If you select to remove transactions, you must enter your new financial year start date, click OK then click Yes.

  8. Click OK then Close.

You have now successfully rebuilt your data files. To undo this process, you must restore the backup you took before rebuilding.

[BCB:101:Limitless - 50 Accounts - Data Corruption / Maintenance:ECB]