Why is there Slow Performance when Using the Master Entry Pick List In Recurring Billing?

Questions and Answers

Q: It has been found that using the master entry pick list in recurring billing is very slow. This KB will provide a possible workaround in Sage Pro 7.3.

A: This issue has been documented under PTR 80037 and has been resolved in Sage Pro ERP 7.4.

Solution

Creating a new index may eliminate this problem. To create a new index, please refer to the steps below.

Important
Ensure that there is a full and verified backup of the Sage Pro installation before proceeding with the following steps.

  1. Open System Manager.
  2. Under the Maintain menu, point to Dictionary and click Tables.
  3. Type “ARRECR” into the Table ID field.
  4. Select “Index” from the listbox.
  5. Click Select and type “CUSTNO” into the Index ID field.
  6. Click Enter.
  7. Click Add and configure index.
  8. Under the Transaction Menu, point to System Recovery and click Update from Data Dictionary.
  9. Select the Accounts Receivable module for the specified company.
  10. Click Yes to rebuild all indexes.
  11. Click Update to update files for the selected applications from data dictionary.

The performance should now improve as a result of this newly created index.

Leave A Comment?