Check the My reports folder 

Customised or downloaded reports from the reports library will appear in the My reports folder of the specific module.

1. Click Reports in the module the report is missing from.
2. Click My reports folder, for example My customer reports.

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. Ensure 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 backup 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.

6. Once you find a backup with the missing customised report or layout, take a reports and layout backup and label it accordingly so you know you've one for future reference.

Copy the files into your data directory

If you can locate the customised files, for example on another computer 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've 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've a single user licence, you can add Use data path for reports into the Sage.ini file.

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

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

Restore your layouts 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 layouts.

1. On the menu bar, click File then click Restoree.
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 layout.

 NOTE: Once you have the correct backup, if this includes data files restore your up to date files only backup. This will show your latest data without affecting the restored layouts.

6.  Once you find a backup with the missing customised layout, take a reports and layout backup and label it accordingly so you know you have one for future reference.

Check the layouts folder

Layouts including Invoices, Credit notes, Sales and Purchase Orders and Statements are all stored in the Layouts folder in your data directory.

To access the layouts folder from within your software:

1. Click Invoices and Credits, then single click any record.
2. Click Print, then click Layouts.
3. Right-click any layout in the list, then select Show in Explorer.

The layouts folder will then open. 

• Check this folder for the layout you're expecting to see.  If it isn't in here, you must locate it and add it to this folder
• If you can see the layout in one company and not another, you should copy the file from the first company's layout folder, then paste into the folder of the second company

 TIP: The Letters folder holds the letters layouts. To access this, repeat the steps above in Customers, then selecting Letters.  

Bespoke layout request

If you're unable to locate the layout in your data or by restoring, you can request it to be created again with our Customer Services Reporting team.