Unable to use decimal comma in LBL_Amount (Opportunities)

Hello Suite Community,

We have a major problem when entering our opportunities. It is not possible to use a comma as a decimal separator in the LBL_Amount field (opportunity amount). When entering the decimal comma, the programme changes it to a full stop and the error message "Invalid currency format. Expectet: ‘1.000,5’ is displayed.

If the amount is entered without decimals and a decimal point, SuiteCRM automatically completes the entry correctly with a decimal point. 8700 then becomes 8,700.00. If you then change any field in the opportunity, the LBL_Amount field is automatically changed and the decimal point is deleted. For example, the amount changes from 8,700.00 to 870,000.

In the system settings, we have defined the comma as the separator for decimals and the dot as the separator for 1000. The error occurs with both the German and English language packs.

Admin → Locale

https://docs.suitecrm.com/admin/administration-panel/system/#_locale


Also, you can check under PROFILE-> Advanced

Thanks for your hint. But, as i said, all parameters (locale and Profile Advanced) are set to . for thousands and , for decimal.
As soon as you enter the amount the content will be changed, and you’re not able to use a , .
Seems like a bug in handling this field. We’ve never seen a behaviour like this in older Versions. IMHO this occurs first time when we moved from 7 to 8 a few months ago. Actually we’re using 8.6.2 as prod an 8.7.1 as test. On both systems the error occurs.

Maybe it is bug , you can report it on the GitHub if you don’t find similar issue.