Using the Rebuild option
Description

Using the Rebuild option instead of copying or deleting files simplifies the process and saves time in v31 and above. If you aren't using v31 or above already, you can upgrade now.


NOTE: Use Rebuild at your main data site when accessing data via Remote Data Access (RDA). 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 RDA.


The data files you can remove using Rebuild

The Rebuild Data Files window with all options selected.

Opening the Rebuild option automatically selects the following data files to keep. Deselect as required to remove them.

 TIP: Some options depend 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. Clearing this check box doesn't automatically clear any other check boxes.
Fixed assets When you rebuild, your fixed asset register will remain unchanged. Clearing this check box doesn't automatically clear any other check boxes.
Bank feed rules Leaving this option ticked means your bank feed rules will remain after rebuilding. Clearing this check box doesn't automatically clear any other check boxes.
Bank reconciliations (saved) Leave this option ticked to retain your completed bank reconciliations when rebuilding.  Clearing this check box doesn't automatically clear any other check boxes.
Bank remittances Your bank remittances will not delete during the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
Chart of accounts When you rebuild, your Chart of accounts will still exist in the rebuilt data. Clearing this check box doesn't automatically clear any other check boxes.
Cheques Any cheques entered into your data will remain after the rebuild.  Clearing this check box doesn't automatically clear any other check boxes.
Column settings Any default column settings you've changed will remain after the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
Countries list Your countries list will remain unchanged after the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
Customer records If you select to keep your customer records, all 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 automatically clear:

  • 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 the removed transactions appear on this report. Clearing this check box doesn't automatically clear any other check boxes.
Diary Events If you select to keep your diary events, when you open the Diary module, all the events remain. Clearing this check box doesn't automatically clear any other check boxes.
Goods despatched notes If you keep your GDNs, they'll remain after the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
Goods received notes This option changes if your GRNs remain during the rebuild or not. Clearing this check box doesn't automatically clear any other check boxes.
Invoice Payments failures Your Invoice Payments failures list will remain unchanged after the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
Invoice Payments foreign settings Your settings for Invoice Payments, specific to foreign transactions remain after the rebuild. Clearing this check box doesn't automatically clear any other check boxes.
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 also clears. 
Invoices If you select to keep your invoices, when you open the Invoicing module, all the records remain. This doesn't affect the sales invoice or sales credit transactions created when you posted the invoice or credit. Clearing this check box doesn't automatically clear any other check boxes.

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. Clearing this check box doesn't automatically clear any other check boxes.
Nominal Account records If you select to keep your nominal accounts, when you open the Nominal or Bank modules, all  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 clear automatically:

  • 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 the records remain. Clearing this check box means the Transactions and Project Transactions check boxes automatically clear.
Project Transactions Select to keep your project transactions and the activity remains on all of your projects. Clearing this check box doesn't automatically clear any other check boxes.

Purchase Orders

If you select to keep your purchase orders, when you open the Purchase orders module, all the records remain. This doesn't 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'll remain after the rebuild completes. Clearing this check box doesn't automatically clear any other check boxes.
Recurring purchase orders If you keep recurring purchase orders, they'll remain after the rebuild completes. Clearing this check box doesn't automatically clear any other check boxes.
Recurring sales orders If you keep recurring sales orders, they'll remain after the rebuild completes. Clearing this check box doesn't automatically clear any other check boxes.

Sales Orders

If you select to keep your sales orders, when you open the Sales orders module, all the records remain. This doesn't 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 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 the stock history remains on the Product Records. The Project Transactions check box clears automatically.
Supplier records If you select to keep your supplier records, when you open the Suppliers module, all 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 clear automatically:

  • 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 the records remain.

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

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

Rebuild your data

 NOTE: The Rebuild option isn't 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. In the Files to keep section, clear the check boxes to remove those files.
  5. If you chose to rebuild your Nominal account records, select the appropriate Accounts structure at the bottom of the window.
  6. Click OK.
  7. Click Yes.

     NOTE: If you choose to remove transactions, 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]