Sage 100

 View Only
Expand all | Collapse all

Auto-Complete

  • 1.  Auto-Complete

    Posted 01-09-2025 20:48

    Customer reports the auto-complete does not work the same as it use to in the old version of Sage 100.  They are currently using version 2022 Standard  - we upgraded 2 years ago and they are just now mentioning this as an issue.  The Index_AC and Index_ACencrypt folders do not exist in their MAS_System folder.  I don't recall, however, maybe they wanted the "other" old version back at one time and I deleted these folders.  Seems odd though because I would typically rename and not delete.  Does anyone know what these two folders do?  Can I copy them from my 2022 system in my office to the customer system and not have any issues?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Auto-Complete

    Posted 01-10-2025 08:47

    Have you seen this kb?  https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=225924350084634&page=1&position=0&q=Index_ACencrypt

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

    Created on  | Last modified on  Highlight Matches

    Summary

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

    Description

    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"

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

    Need more help?

    Chat now

    Steps to duplicate

    1. Install Sage 100 2017 2. Go into Customer Maintenance enter an A and only customers with an A will show 3. Install PU1 4. Go to Library Master, Utilities 5. Run Build Search Index 6. Click ok to message 7. Go into Customer Maintenance enter an A and any customer with an A in the Customer No, Customer Name, Customer Address will now come up in the Autofill results



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: Auto-Complete

    Posted 01-10-2025 11:56

    Yes.  I saw that kb.  That's why I am confused.  The two folders don't exist in mas_system.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Auto-Complete

    Posted 01-13-2025 07:13

    Something I just discovered is that if you rebuild the search indexes the 2 folders in mas_system get re-created.  I believe I solved the issue.  I now just need to clarify what search method the customer prefers.. the old method or the new method.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: Auto-Complete

    Posted 01-15-2025 01:41

    Don't forget to set up the scheduled task to re-run the rebuild search index.  I do not believe that is automatic.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: Auto-Complete

    Posted 01-15-2025 07:18

    There is a setting in System Configuration - Enable Update Search Index:

    If you're using the advanced version of the auto-complete search feature, select this check box to automatically update the search index (in the ../MAS90/MAS_System folder) when changes are made to customer, employee, vendor, general ledger account, or item records.

    When this check box is selected, as customer, employee, vendor, general ledger account, or item records are updated, they appear in the auto-complete search results without running the Build Search Index utility.

    Clear this check box to disable the automatic update of the search index.

    For more information about the basic and advanced versions of the auto-complete search feature, see Auto-Complete Search. 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 7.  RE: Auto-Complete

    Posted 01-15-2025 07:49

    Note that the above was new with 2024



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 8.  RE: Auto-Complete

    Posted 02-03-2025 16:42

    So did anyone actually get the basic search to come back?  We have a client that wants it to be the begins with on itemcode's, renaming or deleting the two folders mentioned above doesn't seem to have an effect on Sage 100 2023.  When I type in itemcode field in sales order entry it only searches by the description....I feel like I'm missing something obvious here but David Overholt and myself are seeing the same thing, we can't seem to get back to basic search type ahead....



    ------------------------------
    Chris Mengerink
    Partner
    DWD Technology Group
    ------------------------------



  • 9.  RE: Auto-Complete

    Posted 02-03-2025 17:04

    I believe it's worked this way since 2014... and I'm not sure there is a way to have auto-complete be ItemCode only.  (There is always F2... to open the ALE).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 10.  RE: Auto-Complete

    Posted 02-03-2025 17:30

    Thanks Kevin, here is the KB article I was working off of:

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

    • 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.

    That was what I was hoping to accomplish.  It says to simply:

    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

    But it also seems maybe that doesn't work anymore?



    ------------------------------
    Chris Mengerink
    Partner
    DWD Technology Group
    ------------------------------



  • 11.  RE: Auto-Complete

    Posted 02-03-2025 17:58

    The enhanced AC includes more fields... but the basic AC search still includes the name (i.e. not ItemCode).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 12.  RE: Auto-Complete

    Posted 02-03-2025 18:02

    You know how I said I'm missing something..............some days I shouldn't be near a computer......thanks Kevin for pointing out my stupidity...off to find a solution for this.



    ------------------------------
    Chris Mengerink
    Partner
    DWD Technology Group
    ------------------------------



  • 13.  RE: Auto-Complete

    Posted 02-03-2025 18:05

    No harm done... it is often hard to see the forest for the trees.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 14.  RE: Auto-Complete

    Posted 02-13-2025 19:28

    I have a client that I just upgraded from 2020 to 2024.1.  They reported the same thing as Doug.  In Item Inquiry in 2020, they begin typing the item CODE and autocomplete would bring up a list of item codes beginning with the text string.  They had the two AC_xxx folders in the old version, but not in the new.  I renamed the folders in 2020, logged in and cannot replicate the behavior they describe.  I even had one of the users log in as themself, and had the same experience.  Weird.  Basic autocomplete only is enabled in 2024.  Reading through this thread, and my own experience tells me what they claim was their experience shouldn't be true, but more than one user has reported it, so I'm not not understanding how it could be so.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------



  • 15.  RE: Auto-Complete

    Posted 02-13-2025 22:20

    SO Entry in my local v2018:

    Sounds like the problem is BKAC.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 16.  RE: Auto-Complete

    Posted 02-14-2025 11:20

    @Kevin Moyes What does BKAC stand for?  Color me acronym/abbreviation deficient.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------



  • 17.  RE: Auto-Complete

    Posted 02-14-2025 11:23

    Between Keyboard And Chair.

    😉



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 18.  RE: Auto-Complete

    Posted 02-14-2025 11:26

    :-)



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------



  • 19.  RE: Auto-Complete

    Posted 02-14-2025 11:52

    Okay, it wasn't just me, lolol.  I had to google it and 'Between keyboard and chair' did come up but it didn't click to me; b4 my coffee. 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 20.  RE: Auto-Complete

    Posted 02-14-2025 11:58

    I googled it too and didn't get a hit! So I'm lame at searches, too.  ROTFL



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------



  • 21.  RE: Auto-Complete

    Posted 02-14-2025 18:51

    aka PICNIC



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------



  • 22.  RE: Auto-Complete

    Posted 02-14-2025 18:56

    Nice!  I hadn't heard that one before.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 23.  RE: Auto-Complete

    Posted 02-14-2025 19:02

    Too funny!



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------