Record limits

The value in the Record Limit field on the Advanced Search window indicates the maximum number of search results that can be returned. This default value, which is typically 500, is based on a business rule that is managed by your system administrator. You can change the limit, but note that a value that is greater than the default value can adversely affect system performance. In most functions, you can clear the field or specify 0 to return an unlimited number of results.

In functions with a great number of records , such as Sales Order Inquiry, unlimited results are prohibited. When you clear the field or specify 0, the default record limit is enforced and this message is displayed:

Clearing the Record Limit is not allowed. It was reset to the Default Record Limit.

You must click Reset to restore the default record limit in the Record Limit field. Otherwise, the field remains blank or retains the zero value.

Advanced searches conducted using keywords are limited by the Maximum Record Count for Keyword Lookups setting in SA Administrator Options-System-General. The default setting is 5000, but can be changed to 0 to remove any limits on record count.

Note: The Advanced Search feature in Product Warehouse Product Setup is an exception when keywords are used in searching. When you conduct an advanced search using keywords only, the results that are returned are limited by the value specified in the Record Limit field in the Advanced Search section.

When you conduct an advanced search using keywords and other criteria, an initial subset of records is selected that is limited by the Maximum Record Count for Keyword Lookups value. Then, a second search is conducted against that subset that is limited by the value in the Record Limit field.