Issue

 

It takes approximately 10 to 60 seconds copying a sales order using Microsoft SQL.

Build Information

Reported in Sage Pro 7.4 with Service Pack 3 (SP3)
Did not test on VFP.

Steps to Recreate

The following was reproduced using client data and SQL Server 2005.

60 seconds to copy a sales order in Sage Pro 7.4
10 seconds to copy a sales order in Sage Pro 7.5

Records found in the following tables using customer data:
SOMAST: 12492 records
SOYMST: 78540 records

Solution or Workaround

This issue has been reported in PTR 89362 and has been submitted to Sage Pro Development to be evaluated for future build. To check the status of this PTR, please contact Sage Customer Support.

© Copyright Sage Software