Problem with tax rate precision

mikestp27
mikestp27
Offline
0
Hi,
We purchased the invoices manager a month ago and we like it a lot.
We're in Canada and we just got a first customer in Quebec province where the tax rate is 9.975% which gets rounded to 9.98...
It's small but it's going to make a big difference on large amounts.
Is there a way to increase the precision of the tax rate?
Thank you.
Responses (4)
  • Accepted Answer

    Tuesday, March 17 2015, 11:28 AM - #Permalink
    0
    Hello,

    unfortunately, the current version of IM only support 2 decimal digits on taxes and other. we will increase this up to 4 digits in the next version, but I'm afraid that the only thing you can do meanwhile is to actually modify the Database table to allow for more decimal space.

    are you ok with making a small MySQL modification?
    The reply is currently minimized Show
  • Accepted Answer

    mikestp27
    mikestp27
    Offline
    Tuesday, March 17 2015, 07:35 PM - #Permalink
    0
    Hello, thank you for adding this in the next version. Do you have an idea when that might be ready? We had to install phpmyadmin to be able to backup our joomla database for safety (we didn't like any of the joomla backup solutions). We might be able to do the mysql change if it's not too complicated. So there's no need to change the php or javascript code? Well done (I suppose), great!
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, March 18 2015, 11:05 AM - #Permalink
    0
    Hello,

    I can't give you an exact timeframe.. but in any case, we hope to have it ready within a month or so.
    as for the MySQL change: it should be quite easy. you just need to go into the table called #__invoices_taxes, and you will find a column in it, named "value", which type is "DECIMAL(10,2)".

    the "2" stands for the number of decimals allowed. you would just need to change it to DECIMAL(10,3) or DECIMAL(10,4) or whatever you may need.

    I think that should be enough to allow what you need! :)

    let me know if that helps.
    The reply is currently minimized Show
  • Accepted Answer

    mikestp27
    mikestp27
    Offline
    Wednesday, March 18 2015, 09:05 PM - #Permalink
    0
    It works !!!!
    Thank you.
    The reply is currently minimized Show
Your Reply