Sage 100

OMG - the new ""enhanced auto completion"" is merde. First, you have to setup a task or manually keep reindexing the files to make it work, and then check out the last sample in the 2017 class on it - you are looking up ""APP"" and 01-ABF American Business Futures shows up as a hit. Because the stupid lookup is also looking at address, comment, sort, etc fields - but still only code and name show up in the auto complete screen. How stupid is that? You have NO IDEA why 01-ABF shows up as a hit for APP.

Congratulations! You are the first (and only) person to test it! :-)

I heard them describing in the 2017 overview and it seems useless and confusing. Thanks for confirming. #halfbakedidea

In premium , we have had to turn off the autocomplete because it destroys the CPU in sql It is using up all the CPU. (Long query)

Comment text containing ""approval"" might explain the search hit.

I'm sure it does - but since you can't see it on the auto complete drop down - who really knows?

I believe that @TimEfinger requested from Sage a list of the fields that are ""searched"" for this Auto Complete feature. Not sure if we received any feedback yet.

The list is in the coursework they are requiring for 2017, @MadelineStefanou.

It is in the in product help. Search for autocomplete. The following is a list of fields that are searched for each record type. Open Customer records Division number Customer number Name Address (Lines 1, 2, and 3) City State ZIP Code Country Telephone Comment Sort Open Vendor Records Division number Vendor number Name Address (Lines 1, 2, and 3) City State ZIP code Telephone Reference Comment Sort Open Item records Item Type Item code Description Extended description Product line Unit of measure (standard, purchases, and sales) Primary vendor Primary AP division number