Sales tab on debtor maintenance may take a long time to load
- Beth Blok (Unlicensed)
- Julie Hanlon
Owned by Beth Blok (Unlicensed)
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.
The following stored procedure may be applied to 7.02.00 and 7.02.1 databases.
