Restore your reports only backup

If you've taken a backup that includes reports, you can restore your customised documents.

If your backup also includes data files, these overwrite your current data. Make sure you take a current data only backup before restoring. You can then restore this after you restore your reports and layouts.

1. On the menu bar, click File then click Restore.
2. Click Browse then browse to where you saved your backup and click Open.
3. Click OK then click Yes.
4. Click OK, enter your logon name and password then click OK.
5. Check to see if the customised layout is there. Repeat this process until you've found a backup that contains the missing custom report or layout.

NOTE: Once you find your missing report or layout, if the back up you restored includes data files, restore your up to date data files only back up. This will bring your data back up to date without affecting the re-discovered reports and layouts.

TIP: Once you find a back up with the missing customised report or layout, take a reports and layout backup and label it accordingly so you know you have one for future reference.

Copy the files into your data directory

If you can locate the customised files, for example on another machine or in the previous versions reports directory, you can restore the document..

1. Open Sage 50 Accounts and log into the company you want to save the document to.
2. Double click the customised file, then enter the company login details to access Report Designer.
3. Click File, then click Save As.
   Report Designer automatically directs to the correct folder.
4. Click Save.
   
   

Check Use Data path for reports

If you have a multi-user licence, you can choose whether your company runs its reports from your local directory, or if it uses the data directory to locate reports. Changes to this may mean your software can't find your reports.

1. Click Settings, then click Company Preferences.
2. Click Reporting.
3. Check if Use data path for reports is selected.

If you have a single user licence you can add Use data path for reports into the Sage.ini file.

1. Browse to the following directory: C:\ProgramData\Sage\Accounts.
2. To display all hidden files and extensions, click View then select File name extensions and Hidden items.
3. Open the Sage.ini file and after [SG50] add in the line UseDataPathForReports=1

4. Click File then Save.
5. Click File then Exit.