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.
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.
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.
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.
Filter. Hyphen. -. Search. , KBA , SRD-FIN-MOP , Payment Management , How To