Calculating with small amounts (0.xxxx)

Mario
Mario
Offline
0
Hi,

One of the costs we have is transport.
We have an official price (government) that can be used to charge per kilometer. This is updated on a yearly basis.

0,3456€

When I use this in IM, it automatically changes the format to 0,35.
It also calculates, using 0,35 and not 0,3456.

How can this be corrected ?
I have the rate for transport in my product list and am selecting it from there to add to invoices...

Thanks,
Mario

Accepted Answer

Thursday, December 04 2014, 11:10 AM - #Permalink
0
in table __invoices_items, change the value field to DECIMAL(12,4)
in table __invoices_templateitems, change the value field to DECIMAL(12,4)
The reply is currently minimized Show
Responses (3)
  • Accepted Answer

    Tuesday, December 02 2014, 05:20 PM - #Permalink
    0
    sorry, in current version of IM, all values are with 2 decimals. that's a thing we are changing in the next version where more decimals will be allowed.

    the only way to "fix" this for you right now is to simply make more decimal space in the Database. if you're ok (familiar) with changing a value in the MySQL database (through phpMyAdmin for example), let me know and I'll indicate what you need to do.
    The reply is currently minimized Show
  • Accepted Answer

    Mario
    Mario
    Offline
    Wednesday, December 03 2014, 11:25 PM - #Permalink
    0
    Hi Germinal,

    Yes, I'm familiar with browsing the tables in phpMyAdmin.
    Let me know which value needs changing so that I can have figures with 4 decimals.

    Thanks !
    The reply is currently minimized Show
  • Accepted Answer

    Mario
    Mario
    Offline
    Thursday, December 04 2014, 12:18 PM - #Permalink
    0
    That seems to have done the trick,

    Happy to see that the actual PDF invoice and the online version is not displaying the 4 digits behind the comma, while the calculation of the total is based on the right amount.

    Great - resolved !
    The reply is currently minimized Show
Your Reply