| | 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.' |
| Resolution | Before you start Ensure the software isn't running in compatibility mode: - Right-click the software icon on your desktop and select Properties.
- Select the Compatibility tab and deselect the Run this program in compatibility mode for: checkbox if selected.
 If the issue persists ▼ Download the fixed layouts for Statements or Invoices - Click the relevant layout you want to download below.
- 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.
- Browse to and right-click the downloaded file, then click Copy.
- On the menu bar click Help, then click About.
- Under Program Details, select 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. 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. - Open the customer record and select the Details tab.
- Select the Addresses & Contacts button then Preferences.
- In the Deliveries section, select Registered address in the Default delivery drop-down.
- Click OK.
- Click Close then Save.
- Run the layout again for that record. If the layout runs correctly, repeat step 1 for all affected records.
▼ Reindex and compress delivery addresses - Back up your data.
- Click File then Maintenance.
- Select ReIndex Customer Delivery Addresses and ReIndex Supplier Delivery Addresses.
- Click OK then click Yes to the Confirm window.
- Click Compress Now on the Information window.
- Deselect the Compress All Data Files checkbox then select Sales Ledger and Purchase Ledger.
- Click Compress, then click OK on the Information window.
- Click Close then click Close again.
- Try running your layout again.
▼ Edit your layout to remove the delivery and letter variables - Select the document you want to amend, then select Edit.
- On the menu bar go to Report, then select Report Properties.
- Enter a new report name and description, then click OK.
- Go to Report then click Criteria.
- Select LETTER_TYPE.LETTER_TYPE, then click Remove.
- Click OK.
- Go to Report then select Filters.
- Remove the part of the filter that refers to the COMMUNICATION_ADDRESS table.
- Remove the part of the filter that refers to the LETTER_TYPE table.
- Within the layout, delete any delivery address variables. For example, SALES_DEL_ADDR or PURCHASE_DEL_ADDR.
- Go to Report then select Joins.
- Select the SALES_DEL_ADDR and press Delete.
- Repeat the previous step for the LETTER_TYPE and COMMUNICATION_ADDRESS tables.
- Re-add the name and address variables from the relevant SALES_LEDGER and PURCHASE_LEDGER tables.
- Click OK.
- Go to Report then select Email Settings.
- Click To:, then select the existing expression.
- Click Edit, then click Clear.
- Enter SALES_LEDGER.E_MAIL, click OK, then OK again.
- On the menu bar, go to File then select Save As.
- Enter a new file name then click Save.
- On the menu bar, go to File then select Exit.
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.
|
|