Our Item Masters contain 130k plus items.

Typically I tell our sales people to enter a "z" in the item code field, then press F2. This quickly brings up the

items in the item master which start with "z".

Otherwise Sage attempts to bring in the entire item master, which kills performance.

Then I tell the sales people to search by vendor, then select the item from that vendor.

Most of the sales people however...just don't know any better and do a "contains" search in the item code.

This forces the search into a cursor looping through the entire table for and description which matches the contains

search string. A Sage performance killer!

When searching for items under a Sales Order, does Sage have the ability to search on more than one field?

For example:  ..in sql psuedo   select * where primary_vendor = "ACME" and item_description like %CARRERA%

Cheers