Vendor Searching omits certain vendors
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
When we are searching for a vendor to assign to an order in the Acquisitions module and we use the Vendor Filter to search under the letter 'B', the first vendor that comes up is Biblio.com.
Why don't the vendors Backhuys and Bagchee appear at the top of the list for this search?
Resolution:
These SQLs show that the z70_name_key (used for building this display) is sometimes uppercase and sometimes lower:
SQL-xxx50> select Z70_NAME_KEY from z70 where Z70_NAME_KEY like 'B%';
Z70_NAME_KEY
----------------------------------------
BIBLIO COM
BIBLIOMANIA = SLC UTAH BRECK BARTHOLOMEW
BILL ESCHMEYER
<etc.>
SQL-xxx50> select Z70_NAME_KEY from z70 where Z70_NAME_KEY like 'b%';
Z70_NAME_KEY
----------------------------------------
backhuys publishers
bagchee
balaban publishers
<etc.>
To correct this, you need to run p_manage_64 to rebuild the z70_name_key field (p_manage_64 is included in the Acquisitions client's services).
(keywords: p-manage-64 manage_64 vendor filter order)
- Article last edited: 10/8/2013