Using SQL % Wildcard in List Field Does Not Show Lists (e.g. Customers in Sales Order, Vendors in Purchase Order/Bill)

Account Settings:
Make sure the number in the Home > Set Preferences > Maximum Number in Dropdown fields is higher than the list you would like to search (e.g. Maximum Number in Dropdown fields = 400 but the number of vendors you have in your account is only 100).

Steps to reproduce the problem:

1. Navigate to Transactions > Purchases/Vendors > Enter Purchase Orders
2. In the vendor fields > Type "%"

Actual Result:
The list of vendors will not be displayed.

Expected Result:
The vendors to be displayed as a list you can select from.

Solution:
For the SQL % Wildcard to display list, make sure the number in the Home > Set Preferences > Maximum Number in Dropdown field is less than the list you would like to search (e.g. Maximum Number in Dropdown fields = 100 but the number of vendors you have in your account is 400).