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:         .. | @ % & * = ?