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
| Warning |
|---|
| title | 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.
| View file |
|---|
| name | usp_Jiwa_Debtors_SalesHistorys_7.2.3.sql |
|---|
| height | 250 |
|---|
|
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | J7UG |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("sales_tab","debtors_maintenance","debtors","sales") and type = "page" and space = "J7UG" |
|---|
| labels | debtors debtors_maintenance sales sales_tab |
|---|
|
...