Problem
When there is a significant sales history for a debtor, loading debtor maintenance and clicking on the Sales tab will take several minutes.
Solution
SQL skills are required
A working knowledge of SQL Management Studio is required to complete this task
The stored procedure has been optimised and now returns data quickly e.g. data took 2 mins, 10 seconds before optimisations and after optimising 18 seconds. This fix applies to 7.02.00 databases only. Download and apply this script to your database
The following stored procedure may be applied to 7.02.00 and 7.02.1 databases.
Related articles