P01015 Search using Hyphenated Word Not Working ?

jimjung27

Active Member
Has anyone noticed that the Name Search doesn't work on P01015 when you are using a hyphenated word in the Name Search field in the Header?

It works when you use the QBE Line.

For example, you enter Smith-Jones in the Name Search field. It looks like it removes the hyphen or doesn't recognize it and would find entries with "SmithJones" but not "Smith-Jones".

Any ideas on how to fix or get this to work?
 
I found this...maybe it will help you out.

Question1: Searching for Address Book records using the Alpha Name field at the top of the Address Book Master form (P01012) provides different results than using the application’s QBE (Query By Example) line.
• For example: Enter Denver C* in the Alpha Name field, no results are displayed. Enter the same search criteria in the Alpha Name field in the QBE line, the system retrieves: Denver County, Denver Club, Denver Complex, etc.
Answer 1: The alpha name in the header and QBE line performs slightly different searches:

The setup in User Defined Code (UDC) table H95/SC will determine how the Compressed field (ABDC) is populated in the Address Book Master table (F0101). UDC table H95/SC contains a list of special characters. For the purpose of this UDC, blank is considered a special character.

If blank is a valid value in UDC H95/SC, then the Address Book records are compressed in the Compressed field (ABDC) in the Address Book Master table (F0101). For example Denver County, will be written as DenverCounty.

If blank is not a valid value in UDC H95/SC, then the Address Book records are not compressed in the Compressed field (ABDC) in the Address Book Master table (F0101). For example Denver County will be written as Denver County.
Note -The description 01 field in UDC H95/SC is 30 characters long. If there are less than 30 characters, space (blank) will be included.
When the Alpha Name field in the header of the form (P01012) is used to search for a record, Business Function (BSFN) Create Compressed Description (B0100009) will validate the compressed field and UDC H95/SC.
If you have both compressed and non-compressed records, the system will only show part of the record (depending on how UDC H95/SC is set up).

If you want to be able to search on special characters, add the special character to UDC H95/SC. If you have existing Address Book records containing this special character, go back into the Address Book Master record (P01012) and press OK without making any changes. This will write a new compressed description (ABDC) to the Address Book Master table (F0101), and you will now be able to search on this special character. Keep in mind you have to re-save every record you have with this special characters in order to search on it.
 
Back
Top