Issue description
When searching for a journal entry in Enterprise Search using the amount field, if searching for a number with decimals such as 7,99 then the search shows no results. However, if the decimal separator is set to a dot and searching again by 7.99 then the search shows results.
Reproducing the issue
Prerequisites
Change the Decimal Separator to a comma (,) and the Thousands Sep. to a dot (.) in SAP Business One in Administration → System Initialization → General Settings → Display tab.
Scenario
1. Open Financials → Journal Entry.
2. Create a journal entry with the amount containing decimals - Eg: 7,85.
3. Open Enterprise Search → click on the icon "Recently modified objects".
4. Search for the amount from "7,80" to "7,90".
5. Click on the "Search" button.
Actual results
Searching for amounts with decimals and having a comma as a decimal separator does not display any results.
Expected results
Results appear regardless of the decimal separator used.
Cause
3rd party issue.
Solution
The issue is depending on the region settings (format) of Windows and other format components of SAP Business One.
As a workaround, use default decimal and thousands separators or search for amounts in the range without decimal separators.
Reference
Comments
0 comments
Article is closed for comments.