x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 3 replies
  • Subscribers 106 subscribers
  • Views 3532 views
  • Users 0 members are here
Browse Forums
Announcements
289
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
43
topics
90
replies
Payroll, Time Tracking, and Job Cost
774
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
dlevasseur

Typing in ItemCode field slow when AutoComplete enabled

Posted By

This past weekend I performed the upgrade from Standard 2016 to Premium 2016.  After the upgrade typing out item codes in any ItemCode field (IM/SO/PO/ETC) is extremely slow while it builds the autocomplete drop down.  Roughly 1-3 seconds between each character.  With Autocomplete disabled typing returns to normal.

Is there a way to rebuild the autocomplete data or any known fix for this?

Note that Autocomplete for Customer Name works fine.

  • 0
    Look on the Auto-Complete tab of user maintenance. You can turn it off for Items, leaving it on for Customers / Vendors. I'd guess the performance hit is because your item table is much larger than your customer table.
  • 0 in reply to Kevin M
    My reseller also thought this, however it was fine in 2016 Standard. Also it was fine during our initial change to premium. We first migrated once to premium so I could fix all of my custom code and external apps, auto complete worked fine in that environment. Then when it was time to go live, I did the migration again, this time only migrating data. Not a big deal in Item Maintenance for us.

    Since I disabled Auto-Complete at the system level it will not let me even select the tab in user maintenance, so I'll have to test and verify this at a later time.

    Thank you.
  • 0 in reply to dlevasseur
    Each keystroke is a new query, and if there is any latency between your workstations / Sage service / the SQL database it would be quite noticeable with this feature.

*Community Hub is the new name for Sage City