Troubleshoot speed issues with layouts
Description

When you run a layout to preview, there can be a delay to generate or the following error message appears:

'The report could not be generated. No data was returned for this Report.'

Cause
Resolution

Before you start

Ensure the software isn't running in compatibility mode:
  1. Right-click the software icon on your desktop and select Properties.
  2. Select the Compatibility tab and deselect the Run this program in compatibility mode for: checkbox if selected.
Run this program in compatibility mode highlighted in the Properties tab.

If the issue persists

▼ Restore the layouts only backup

If you experience issues with standard layouts, you can restore the reports and layouts only backups.


▼ Download the fixed layouts for Statements or Invoices
  1. Click the relevant layout you want to download below.
  2. If prompted to save the file, browse to where you want to save the file, then click Save.

    Depending on your web browser, the file can automatically save to your Downloads folder. To view your Downloads folder, press Ctrl + J on your keyboard.
  3. Browse to and right-click the downloaded file, then click Copy.
  4. On the menu bar click Help, then click About.
  5. Under Program Details, select the Data Directory path.
  6. Open the Layouts folder and right-click and paste in the downloaded layout file.
  7. Run the new layout from your software. These will display 'Copy of ...' 

 NOTE: If the following layouts don't hang, this is because no delivery address variable attached. Don't use delivery addresses for the affected layout - follow the Edit your layout to remove the delivery and letter variables section. 

Statements

 Statement, Grouped & OS Items - Using Customer Registered Address

 Statement, Grouped & All Items - Using Customer Registered Address

Invoices

 Inv\Crd With Discount - Using Invoice Delivery Address

 Inv\Crd Without Discount - Using Invoice Delivery Address

Sales Orders

 Sales Order - Using Sales Order Delivery Address

 Despatch Note - Using Sales Order Delivery Address

Purchase Orders

Purchase Order - Using Purchase Order Delivery Address


▼ Set the default delivery address to the registered address

 NOTE: The address and contacts option isn't available in Sage 50 Accounts Essentials. 

  1. Open the customer record and select the Details tab.
  2. Select the Addresses & Contacts button then Preferences.
  3. In the Deliveries section, select Registered address in the Default delivery drop-down.
  4. Click OK.
  5. Click Close then Save.
  6. Run the layout again for that record. If the layout runs correctly, repeat step 1 for all affected records.

▼ Reindex and compress delivery addresses
  1. Back up your data.
  2. Click File then Maintenance.
  3. Select ReIndex Customer Delivery Addresses and ReIndex Supplier Delivery Addresses.
  4. Click OK then click Yes to the Confirm window.
  5. Click Compress Now on the Information window.
  6. Deselect the Compress All Data Files checkbox then select Sales Ledger and Purchase Ledger.
  7. Click Compress, then click OK on the Information window.
  8. Click Close then click Close again.
  9. Try running your layout again.

▼ Edit your layout to remove the delivery and letter variables
  1. Select the document you want to amend, then select Edit.
  2. On the menu bar go to Report, then select Report Properties.
  3. Enter a new report name and description, then click OK.
  4. Go to Report then click Criteria.
  5. Select LETTER_TYPE.LETTER_TYPE, then click Remove.
  6. Click OK.
  7. Go to Report then select Filters.
  8. Remove the part of the filter that refers to the COMMUNICATION_ADDRESS table.
  9. Within the layout, delete any delivery address variables. For example, SALES_DEL_ADDR or PURCHASE_DEL_ADDR.
  10. Go to Report then select Joins.
  11. Select the SALES_DEL_ADDR and press Delete.
  12. Repeat the previous step for the LETTER_TYPE and COMMUNICATION_ADDRESS tables.
  13. Re-add the name and address variables from the relevant SALES_LEDGER and PURCHASE_LEDGER tables.
  14. Click OK.
  15. Go to Report then select Email Settings.
  16. Click To:, then select the existing expression.
  17. Click Edit, then click Clear.
  18. Enter SALES_LEDGER.E_MAIL, click OK, then OK again.
  19. On the menu bar, go to File then select Save As.
  20. Enter a new file name then click Save.
  21. On the menu bar, go to File then select Exit.

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions