Currency rate incorrect value - Affecting Items

Hello

Using self hosted, version 2.0.3

As currency, I use Euro and as tarrif I enter the value '1'. However, after saving, it saves this value as '1.00000000' for no apparent reason.
The side effect is that when I create an item that is worth 25 euro, Akounting automatically makes this an item worth '€250.000,00'.
Of course, this also affects my invoicing.

What did I try to do myself:
- change '1' to '1,00' and '1.00'
- create new invoice
- create new item
- create new currency

but the problem persists.

Is this a parameter somwhere that need to be adapted?

Thanks a lot for your help!

Hello Thomas,

What is your PHP and MySQL version?

Regards

Hi Denis

PHP 7.3

db:

innodb_version
5.7.27
protocol_version
10
slave_type_conversions
version
10.2.27-MariaDB-cll-lve
version_comment
MariaDB Server
version_compile_machine
x86_64
version_compile_os
Linux
version_malloc_library
system
version_ssl_library
OpenSSL 1.0.1e-fips 11 Feb 2013
wsrep_patch_version
wsrep_25.24

You may need to set your "locale" settings in the database to the right language ("dutch" in my case).
Go to your index.php file and add the following line just underneath the define for "minimum supported PHP version":

/* Set locale to Dutch */
setlocale (LC_TIME, "Dutch");

Problem solved!

Ok,
I'm having the same problem.
Can't find the locale settings on my index.php file :/

The issue would be sorted if we could change the . on the currency exchange for a ,
this way the system would not take it as a thousand but this is not possible, I tried also on the database, nothing.