Symptom
No results are returned when searching for %40716% in the Chart of Accounts-Account Number field when an exact match exists in the data. In a SQL trace there is a difference in the select statement when searching for %40.
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('%8%%') ORDER BY UPPER(chart_acct)
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('@716%%') ORDER BY UPPER(chart_code)
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('%8%%') ORDER BY UPPER(chart_acct)
SELECT * FROM chart_of_accounts WHERE UPPER(chart_acct) like UPPER('@716%%') ORDER BY UPPER(chart_code)
Resolution
Fixed in version 2017.1.2
Workaround: Search in the account name or code field or search for %716% instead of %40716%
Article Type
Product Defect
Product Line
Millennium
Product Module/Feature
Tools-Lookups
Ranking