Performance Issues When Generating The Picking List Report With Large Number Of Line Items On Order


There may be performance issues when generating the Pickling List Report and an order contains a large
number of line items. The issue only occurs with the Microsoft SQL Server (SQL) version of Sage Pro ERP 7.3B, not Microsoft Visual FoxPro.

Solution or Workaround

This Hot Fix addresses PTR 80791.

Hot Fix files included (in the SO program folder):


Important Notes:

  1. PTR 80791 has been fixed as of Sage Pro 7.4 Build 3400.
  2. This Hot Fix applies to Sage Pro 7.3B Build 3301.
  3. Back up affected program files and data before applying Hot Fix.
  4. Apply Hot Fix in a test environment to ensure proper results before implementing in a live installation.
  5. Verify that Hot Fix files will not overwrite any modifications. If there are modified files, a qualified Sage Certified Consultant familiar with the modifications should be used to integrate the changes.


This Hot Fix addresses the above behaviour. Please follow the instructions included in the attached readme to implement this Hot Fix.


© Copyright Sage Software

Leave A Comment?