/
Sales tab on debtor maintenance may take a long time to load
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.
Related articles
, multiple selections available,
Related content
Loading Debtors Transactions in Debtors Maintenance is very slow
Loading Debtors Transactions in Debtors Maintenance is very slow
More like this
Debtor Sales tab errors where the General Ledger periods are non standard 'Object reference not set ...' 7.00.175
Debtor Sales tab errors where the General Ledger periods are non standard 'Object reference not set ...' 7.00.175
More like this
DBMGT060 - Debtors Balance As At has been made faster
DBMGT060 - Debtors Balance As At has been made faster
More like this
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
More like this
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
More like this
DBINF025 - Debtor Contact Details Report
DBINF025 - Debtor Contact Details Report
More like this