| Restore to an error free backup and reprocess |
Description | If your data is corrupt, and the Check Data report is showing unfixable errors we recommend you restore your most recent error free backup and reprocess. You may be able to export or print reports to help you do this. Don't worry, we'll take you though each step in the section below. |
Resolution | Step 1 - Back up your data and note your data information- On the menu bar click Help, then click About.
- Under Data Information make a note of the following figures: Headers, Splits, Invoices, Sales Orders and Purchase Orders.
- On the menu bar, click File then click Back up and, if prompted, click No to the check data message.
- Enter a file name for your backup, then click Browse.
- Browse to where you want to save it and click OK.
- Select the Data Files check box and click OK then click No and click OK.
Step 2 - Identify and restore the last error free backupCheck for the most recent error free backup in Backup Manager and restore:
- Open Sage Accounts and log on as MANAGER.
- Click File then click Schedule back up and click Check data results tab.
- Find the latest error free backup of the required company and make a note of the Date and time.
TIP: Error free backups show a green tick in the Status column. - Click the Backup files tab and find the backup for the required company for the date and time noted in step 3.
- Make a note of the Filename and path then click Close.
If you store your data on a different computer, the backup paths refer to the computer where your data is stored rather than your local computer. - Click File then click Restore and Browse to the backup noted in step 3.
- Click Open then click OK and click Yes and click OK.
If you don't have any backups in Backup Manager, please follow the steps below: - Click File then click Restore and Browse to your previous backup then click Open and click OK.
- Click File then click Maintenance and click Check data.
- If there are no errors, use this backup.
If there are still errors, repeat steps 1 and 2 until you find an error free backup.
NOTE: If you don't have an error free backup to restore, for further help please contact Sage support.
Step 3 - Note the last transaction number on the error free backup Make a note of the last transaction number on the error free backup and if require the last invoice, credit and order numbers.
Transactions | Click Transactions and note the last number in the No column. |
---|
Optional: |
| Invoices and credits | Click Invoices and credits and note the last invoice number. |
---|
Sales orders | Click Sales orders and note the last order number. |
---|
Purchase orders | Click Purchase orders and note the last order number. |
---|
Step 5 - Run any relevant reports depending on what is to be reprocessedExport the following reportsAll reports should be checked before re-entering as they may not be accurate due to the corruption. Depending on the extent of corruption, some transactions may not export. Transactions NOTE: If the report is opened in Excel it can reformat and cause errors when importing, if you need to view the contents open the report in Notepad. - Click Transactions then click Reports and click Transactions.
Sage 50 Accounts v25 or below - Click Transactions then click Reports and click My Transaction reports. - Click Transaction CSV (PP=>PA AND SR=>SA) report and click Export.
- Click the Save as type drop-down and click CSV Files (*.csv) then browse to a location of your choice and click Save.
- In Criteria Values for Transaction No click Between (Inclusive) enter one after the transaction number noted in step 3, (? + 1 = ?) and 9999999 then click OK.
Customer, supplier and product recordsExport the following reports as a CSV files. - Customer records - Customers > Reports > Customer details > Customer Record CSV report
- Supplier records - Suppliers > Reports > Supplier details > Supplier Record CSV report
- Product records - Products and services > Reports > Product details > Product Record CSV report
To export to CSV file: - Browse to and click the relevant report then click Export.
- Click the Save as type drop-down and click CSV Files (*.csv) then browse to a location of your choice and click Save then click OK.
Invoices and ordersIf you use Invoices and credits, sales orders or purchase orders, print any invoices or orders after the numbers noted in step 3: Last invoice number: |
|
---|
Last sales order number: |
|
---|
Last purchase order number: |
|
---|
StockOnce reprocessing is complete, run a product details report to check stock levels. - Click Products and services then click Reports and click Product details.
- Click the Product Details report and either Print or Export as required.
Step 6 - Print any VAT Returns or bank reconciliations that have been run since the error free backupVAT Return- Click VAT then click the required Return and click VAT Return.
- Click Print and select the VAT Return, Summary and Detailed check boxes.
- Click Printer then click Run then click OK.
- Repeat from step 1 for all affected VAT Returns.
Bank Reconciliation- Click Bank Accounts and open the required bank account.
- Click the Memo tab and open the Statements folder.
- Double-click and print the required statements.
Step 7 - Restore the error free back up from step 2- On the menu bar, click File then click Restore.
- Click Browse then browse to where you saved your backup, click it then click Open.
- Click OK then click Yes.
- Click OK, enter your logon name and password then click OK.
- Now you've restored your backup, we recommend you check your data.
Step 8 - Set up Schedule backups The Backup Manager makes managing your backups simple. You can schedule backups to run automatically so you don't need to worry about it, and you can still work in Sage Accounts while your backups are running. You don't even need to have Sage Accounts open. Check data runs automatically and you can manage backups and check data results for all companies in one place.
To set up a backup schedule: - Open Sage Accounts and log in using the manager logon name and password.
- On the menu bar click File, click Schedule back up then click the Settings tab.
- Enter your backup schedule settings as required. using the Manage your scheduled backups and check data results guide.
Step 9 - Reprocess using the reports madeImport any customers, suppliers or productsIf new customers, suppliers or product codes have been added since the error free back up, import the relevant CSV report from step 5 or manually add the new records required. - On the menu bar click File then click Import then click Next.
- In the Data type window, select the type of data you want to import then click Next.
- In the Data source window, click Comma separated (*.csv).
- Click Browse and locate and select the file to import then click Open then click Next.
- Click Load Map then open Shared mappings and click the extended map, for example Customer record (extended).map then click Open.
- Click Next then click Import or Finish.
- If the import is successful, a list of transactions imported appears in the Record Imported pane. Click Close.
If the import is unsuccessful, a list of import errors appear in the Records not Imported pane. If available click Edit import to amend the original import file, click Close, then attempt to import again
Re-enter invoices and ordersRe-enter any Invoices and credits and/or Sales orders, and Purchase orders you printed in step 5. When reprocessing, if you update the ledger for these invoices and orders, you must delete the transactions to avoid duplication when importing your audit trail. NOTE: If you use Sales orders, when you update these, a corresponding invoice is created. Avoid re-entering the invoice again as this creates a duplicate. Import audit trail NOTE: Before you import, please check that the data you're about to import is correct, as due to initial corruption some transactions potentially could be wrong. Any that are wrong you should remove from the import spreadsheet and manually reprocess instead. If you've cancelled transactions on your exported audit trail you may need to update your import file to ensure these are imported correctly. For more information on Cancelled transactions, please refer to the Transaction details guide. To import your audit trail file: - On the menu bar click File then click Import then click Next.
- Click Audit Trail transactions then click Next.
- In the Data source window, click Comma separated (*.csv).
- Click Browse and locate and select the file to import then click Open then click Next.
- Click Load Map then open Shared mappings and click Transaction (extended).map then click Open.
- Click Next then click Import or Finish.
- If the import is successful, a list of transactions imported appears in the Records Imported pane. Click Close.
If the import is unsuccessful, a list of import errors appear in the Records not Imported pane. If available, click Edit import to amend the original import file, click Close, then attempt to import again.
TIP: If you are importing .csv files, be aware that Excel may count credits as a negative value which can affect your import. It is recommended negative values be converted to positive values before importing. Reprocess VAT ReturnsReprocess and reconcile any VAT Returns and mark as submitted if applicable. You don't need to resubmit the return to HMRC. You don't need to post the VAT transfer or post any payment or receipt as these are included in t the audit trail you imported. Bank reconciliationReprocess any bank reconciliations based on the reports you printed in the section Step 6 - Print any VAT Returns or bank reconciliations that have been run since the error free backup. StockCheck Product details report you ran in step 5. If any stock levels are different adjust them accordingly.
Once you have completed the steps, check your data, backup and then start processing as normal.
|
|