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.
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
0Hello,
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? -
Accepted Answer
0Hello, 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! -
Accepted Answer
0Hello,
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. -
Accepted Answer
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »