Sage 200 UKI Ideas Portal
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
When running various reports in Sage such as the 'Receipts and Despatches' report, criteria selections can be very slow to load, for example if you select criteria 'Order/Return Number:' Is and click the drop down, it takes 7 seconds on a small dataset to load the list of POs. If you run the same query it is using in SQL server it takes a fraction of a second. This issue becomes much worse with larger company data, taking sometimes minutes, and affects all criteria selections on all reports. It has been an issue for at least several years
| Product Variant | Sage 200 Professional |
I agree that the drop downs for orders / invoices are intolerably slow on large datasets
One practical workaround is to amend the query to restrict orders / invoices to e.g. documents less that 90 days old
Note this only restricts what is shown in the drop down list - the end user can still type in a specific (older) document number if required
SELECT DISTINCT ~~~~
AND ((Now()-SOPInvoiceCredits.DocumentDate)<90)
ORDER BY SOPInvoiceCredits.DocumentNo DESC
A possible workaround is to add "TOP 500" or similar to the criteria query. But I agree - it can be slow.