Sales tab on debtor maintenance may take a long time to load

Owned by Beth Blok (Unlicensed)
Last updated: Mar 03, 2021 by Julie Hanlon
1 min read

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.