Troubleshoot missing reports

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.

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, 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 reports.

6. Once you find a backup with the missing customised report, take a report only backup to keep for future reference.

Copy the report files into your data directory

After you locate the customised reports, from another computer or in a different report location, you can restore them.

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 either run your reports from your local directory, or from the data directory. 

1. Click Settings, then click Company Preferences.
2. Click Reporting.
3. Check the Use data path for the reports checkbox.

If you have 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.