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
Related articles