Skip to content
logo Knowledgebase

How to enable, setup, and use the Auto-Complete feature for Customer number, Vendor number, and Item Number fields

Created on  | Last modified on 


How to enable, setup, and use the Auto Complete feature implemented in Sage 100 ERP versions 2014 and higher Auto-Complete was designed to search in the Customer No , Vendor No , and/or Item No field when the user only has the Item Description, Customer Name, or Vendor Name. This is a new feature in version 2014 and higher.


The Auto-Complete features looks for:

  • Vendor Names (AP)
  • Customer Names (AR)
  • Item Descriptions (IM)

See Help Menu for designed purpose of this feature.

Select this check box to enable the Auto-Complete feature. If this check box is selected, when you start typing a customer name, vendor name, or item description in a customer number, vendor number, or item code field, a list of records matching your entry appears, and you can select a record from the list. The list is filtered as you continue typing. You will still be able to select a record by entering the customer number, vendor number, or item code.

Selecting this check box enables this feature for all users. You can then disable this feature on a field-by-field basis for individual users in User Maintenance. Clear this check box to disable the feature for all users.

To use Enhanced Auto Complete Feature available in current versions, go to Library Master, Utilities and run the Rebuild Search Index utility.



CAUTION: Sage Customer Support does not assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please get in touch with your Sage business partner, network administrator, or accountant for assistance. Please refer to our Scope of Support document for details.

Enable (or Disable) Auto-Complete in System Configuration:

    1. Open Library Master, Setup menu, System Configuration
    2. On the Preferences tab, select the Enable Auto-Complete check box (or deselect to disable, if not desired)
      • Note: Enabling the option allows access to the Auto-Complete tab and its settings in Library Master, Main menu, User Maintenance, Preferences tab. Disabling the option makes the Auto-Complete tab inaccessible.
    3. Click Accept

Verify the User Logon has Auto-Complete enabled (or disabled) in User Maintenance:

  1. Open Library Master, Main, User Maintenance
  2. Select the applicable User Logon from look up
  3. Click on the Auto-Complete tab
  4. Select applicable Record Types (Customer, Item, Vendor) to enable Auto Complete
  5. Click Accept

If Auto-Complete still is not available after enabling it for users, please try the following:

Note: All users in the affected companies must be out of the system

  1. Open Custom Office, Utilities menu, Update Custom Panels to Current Level
  2. Select the Module, Task, Company, and User you want to update
  3. Click OK
  4. Print/Preview the Custom Office Customizer Detail Report
  5. Open Custom Office, Utilities menu, Rebuild Customizer Log
  6. Click OK

Note: Use the respective lookup to search for Customer No, Vendor No, and/or Item No.

Auto-Complete suggestions do not display when typing in Customer No, Vendor No or Item No information into those fields.

DocLink: Auto-Complete does not display newly added customers, employees, items, or vendors