Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Build Search Index Utility

  • 1.  Build Search Index Utility

    Posted 07-01-2020 15:22
    Is there a way to roll back once the Build Search Index Utility has been run? A customer prefers the old way of lookups, when it only evaluated the first few characters of records in a field. Unfortunately, I ran this utility for them.

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------


  • 2.  RE: Build Search Index Utility

    Posted 07-01-2020 15:25
    In MAS_System, rename the Index_AC and it goes back to the 'starts with' method.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: Build Search Index Utility

    Posted 07-01-2020 15:30
    Worked like a charm! Thank you, @Nancy Hanson!​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Original Message


  • 4.  RE: Build Search Index Utility

    Posted 07-01-2020 15:32
    @Karen O'Lane - beware - every time you build the search index, that will get created again​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: Build Search Index Utility

    Posted 07-01-2020 15:36
    @Beth Bowers - Yes, and luckily, I hadn't set that up in task scheduler for them.  :-O​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Original Message


  • 6.  RE: Build Search Index Utility

    Posted 07-01-2020 15:36

    Right.

     

    Auto-Complete no longer searches the beginning of text for Sage 100 (enhanced versus basic Auto-Complete)

     

    Products

     

    Sage 100

     

    Country

     

    North America

     

    Description

    Auto-Complete no longer searches beginning of Text after running Build Search Index utility

    Build Search Index activates enhanced Auto-Complete feature

    How to revert to the older, basic Auto-Complete



    Cause
    • Running the Build Search Index utility on the Library Master Utilities menu activates the Enhanced auto-complete feature.
    • When using the Enhanced auto-complete feature, your search criteria is compared with all words within the searched fields. For example, if you have a customer named Allen's Appliance Repair and a customer named Appliance Services, typing Appl in the Customer No. field results in a list that includes both customers.
    • In addition, the number of fields included in the search has been expanded. For example, to search for a vendor by phone number, start typing the phone number, digits only, in the Vendor No. field.
    • The older, basic version of auto-complete search worked by comparing your entry to the beginning of the customer, vendor, or item name.



    Resolution

    Sage 100 2019

    1. Browse to the ..\MAS90\MAS_SYSTEM directory on the server
    2. Rename or Delete the Index_AC and Index_ACencrypt directories that were created
    3. The basic Auto-Complete will now be used

    Sage 100 2018

    If the older, basic version of auto-complete is desired, perform the following steps:

    1. Browse to the ..\MAS90\MAS_SYSTEM directory on the server
    2. Rename or Delete the Index_AC directory that was created
    3. The basic Auto-Complete will now be used

    For more information, in Sage 100 Help, search "Auto-Complete Search"



    Need help?

    Chat with support

     

    Related resources

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

    Category

     

    Configuration

     

    Product update




    ID:84634    Last Modified Date:5-13-2020  

     

     

     

    Thanks,

     

    César Varela | Sage 100 ERP Consultant

    O: 949.583.9500 x1194 | C: 949.338.3611

    cvarela@blytheco.com | www.blytheco.com
    Blytheco | Transforming Companies

     




    Original Message


  • 7.  RE: Build Search Index Utility

    Posted 07-01-2020 15:39
    @Cesar Varela, apparently, you are better at Searching for KBAs than I am! Thanks. ​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Original Message


  • 8.  RE: Build Search Index Utility

    Posted 07-01-2020 16:26
    Just not a fan of this feature. Mainly because if you use it, it only returns the first ten hits.  Doing the same search in the customer master at one client returned 40+ hits.  Plus you have to manually refresh it.  Back when I tried it in v2017, the task scheduler would not release a user and the owner said to turn it off.  Another great v1.0 (or is it beta) idea that has never been improved.  And don't get me started on the HRMS => Sage 100 PR interface!!!!!!!!

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 9.  RE: Build Search Index Utility

    Posted 07-01-2020 16:43
    @Jeff Schwenk, I've NEVER liked this feature. I still do the F2/F4 method and I try to reinforce that with my customers, because getting a short list of 10 records doesn't hold much value, IMO. ​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Original Message


  • 10.  RE: Build Search Index Utility

    Posted 07-01-2020 18:00
    If this issue is resolved @Karen O'Lane I'll move it from Sage Urgent to Sage 100.
    ​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 11.  RE: Build Search Index Utility

    Posted 07-08-2020 20:38
    @Karen O'Lane​, I didn't hear back from you and moved this thread to Sage 100 - if it is still an urgent issue let me know and I'll move it back.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


Related Content