Skip to end of metadata
Go to start of metadata

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.

usp_Jiwa_Debtors_SalesHistorys_7.2.3.sql