Summary
Description
When running reports, the following message appears when there's no information to report on for the criteria given:

Resolution
Table of Contents
The information doesn't exist
If you run a report to show information that doesn't exist on your system, this message appears.For example:
- You're running an invoice report but there are no invoices in the data
- You run an Aged Debtors report for a customer with no outstanding transactions
- You run a Sales Credit Day Book report for a customer without any SC transactions on their account
- You run a product activity report for a product with no transactions
- You run a Customer Statement report with an outstanding items layout, but the customer account has no outstanding transactions.
- The customer account on the invoice no longer exists in the software
Incorrect records selected
Only items you've highlighted within the module will appear on the report.
For example, if you highlight one or more invoices and run a report, the results will show that selection only.
If the highlighted records don’t meet the report criteria, the message appears.
To resolve this, check you've highlighted the correct items, or select the Clear button to deselect any highlighted records.
You've applied a search
When you apply a filter or search to the module, the report runs for the data displayed in the filter or search. Find out more in our How do I filter my lists? guide.
For example, if you apply a filter to remove customers with an outstanding balance, running the Aged Debtors report will show the error.
To resolve this, remove the search, or change it to show the information you want to report on.
Check your regional settings
This can occur if the date is in an American format, for example, 11/01/2022 instead of 01/11/2022.
Check your computer date format is English (United Kingdom).
Check your report settings
If you have a multi-user licence, check where the software is looking to pick up your reports.
- Select Settings, then press Company preferences.
- Select Reporting.
- If you hold your reports in your data directory, check the Use data path for reports checkbox
- If your reports use the default location, clear the Use data path for reports checkbox.
- Press OK.
Speed issues
When you run a report or layout to preview, a delay in generation time may cause an error message to appear.
Use our troubleshoot speed issues with reports and layouts article to check and resolve this.
Check your customers default delivery address
- Open the customer's record, then select Addresses & Contacts.
- Press Preferences.
- If the 'Deliveries' dropdown list shows none, change this to Registered address.
- Check there's an address in the 'Send to' field for the document type you're viewing.
- Select OK, then Close, then Save.
Repeat this process for all required customers.
Check your suppliers default delivery address
- Open the supplier's record, then select Addresses & Contacts.
- Press Preferences.
- If the 'Deliveries' dropdown list shows none, change this to Registered address.
- Check there's an address in the 'Send to' field for the document type you're viewing.
- Select OK, then Close, then Save.
Repeat this process for all required suppliers.
Download the fixed reports
- Select the relevant layout you want to download below.
- If prompted to save the file, browse to where you want to save the file, then press Save.
- Browse to and right-click the downloaded file, then press Copy.
- On the menu bar, select Help, then press About.
- Under Program Details, press the Data Directory path.
- Open the Layouts folder and right-click and paste in the downloaded layout file.
- Run the new layout from your software.
Statements
Invoice
A blank Chart of Accounts
Management reports need a Chart of Accounts with information. If the chart of accounts is blank, this message appears.
To resolve this, identify and correct errors in your chart of accounts.
Check your report filter
If you use a customised report, there could be a filter on it that prevents the report from running.
Try removing your filter, then re-create it. You can use our Create or edit a filter on a document article to do this.
Contact us
If you've completed the steps in this guide, contact Sage Technical Support for further help.
Upgrade your licence
Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.
