A key feature of Business Central is the ability to use filtering for viewing information via pages, tables and reports. When a record is created using a special character that is used for filtering it can be an issue with the expected results.
For filter criterial see: https://learn.microsoft.com/en-ca/dynamics365/business-central/ui-enter-criteria-filters
Therefore, it is recommended to avoid using the following special characters as part of a customer No. or name for example:
Special Characters we recommend to avoid in your data: .. | @ % & * = ?