Symptom
You want to search for a specific payment in Payment Monitor view, but when you enter the Bank Account ID in the search field, the system does not make any filter, and keeps showing random results.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Payment Management work center.
- Go to Payment Monitor view.
- In the Bank Account column, you click the row name, and when filter options shows up, you enter the ID ABC-XY (where ABC-XY represents the Bank Account ID).
- The system does not make any filtering, just shows random results.
Cause
This is expected behavior as the system interprets the hyphen as a range of values and hence the selection gets created as Between and not Equal.
Resolution
To custom filter in a column using a value which contains a hyphen (-) in it, the string needs to be enclosed in double-quotes i.e. "ABC-XY". This may serve to all filters used in the system when searching for an ID, value, etc.
Keywords
Filter. Hyphen. -. Search. , KBA , SRD-FIN-MOP , Payment Management , How To