Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Currency rate incorrect value - Affecting Items

Thomas   ( User )

Commented 4 years ago

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!

Denis Dulici   ( Admin )

Commented 4 years ago

Hello Thomas,

What is your PHP and MySQL version?

Regards

Thomas   ( User )

Commented 4 years ago

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

Joris Tip   ( User )

Commented 4 years ago

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!

Valentina   ( User )

Commented 3 years ago

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.

Please login or register to leave a response.

Showing 1 to 5 of 5 discussions