kyrotomia Posted January 3, 2013 Share Posted January 3, 2013 Hi, This is only a quick feedback as I was able to make the changes myself to the software. At least here in Quebec (Canada), we have taxes that have 3 decimals (actual rate is 9.975%) and I noticed WHMCS would round it up to 2 decimals(9.98%). I found out the mysql schema is set to use a DECIMAL(10,2), and I simply changed it for a DECIMAL (10,3). I thought it was worth noting, considering this is such a quick fix and may be useful for others. 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted January 3, 2013 Share Posted January 3, 2013 Excellent im glad you shared that because i plan to do some business with some CA companies and this is good to know. It will still do the 10,2 as well right? Its just the max is 10,3 correct as i need to be able to do both. Also please share this over here as well maybe we can get that corrrected http://requests.whmcs.com/ 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted January 4, 2013 Share Posted January 4, 2013 (edited) Actually this was good to bring up because i didnt realize they they changed my local tax rate and so now i have to account for 4 dec places so i had to change mine to 10,4 . What happens is that if you lets say leave it at 10,2 and you put in 6.0001 it will give you Invalid Token and refresh the screen and your entry is gone. So i changed mine to 10,4 and it accepted it just fine after that. Just fyi this is in the table called tbltax Also on a dif note but same topic i found this link below to be a good read as well regarding taxes, i just wish they would clarify "physical presense" alittle better. Does this mean that since my host server is in NY that i have to pay NY sales tax as well, or does physical presense mean where i physically live. http://www.cardfellow.com/blog/online-sales-tax-rules-laws/ Edited January 4, 2013 by durangod 0 Quote Link to comment Share on other sites More sharing options...
WHMCS JamesX Posted January 4, 2013 Share Posted January 4, 2013 Gotta love Revenu Québec. I'm just happy that they gave me an official ruling some time ago stating that I don't have to deal with the QST BS, for the most part; GST/HST is enough. 0 Quote Link to comment Share on other sites More sharing options...
Frankk Posted January 4, 2013 Share Posted January 4, 2013 Reading this thread I noted that this quick-fix won't fix everything as it is explained. 2 tables need to be modified to make it work, tbltax, field: taxrate and tblinvoices fields: taxrate and taxrate2. That way invoices will work as well. 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted January 4, 2013 Share Posted January 4, 2013 Reading this thread I noted that this quick-fix won't fix everything as it is explained. 2 tables need to be modified to make it work, tbltax, field: taxrate and tblinvoices fields: taxrate and taxrate2. That way invoices will work as well. Thank you so much for sharing that, nice find there.. really appreciate that 0 Quote Link to comment Share on other sites More sharing options...
webadpro Posted January 5, 2013 Share Posted January 5, 2013 This is a must in order to use WHMCS. 0 Quote Link to comment Share on other sites More sharing options...
Bubka3 Posted January 5, 2013 Share Posted January 5, 2013 This should be a bug fix. NYC tax rate is 8.875 0 Quote Link to comment Share on other sites More sharing options...
webadpro Posted January 7, 2013 Share Posted January 7, 2013 This fix doesn't fix it for quotes though. 0 Quote Link to comment Share on other sites More sharing options...
webadpro Posted January 7, 2013 Share Posted January 7, 2013 My Bad, I had an issue. It does work with quotes. 0 Quote Link to comment Share on other sites More sharing options...
bluebirdnet Posted January 18, 2013 Share Posted January 18, 2013 For QC tax i have modified all of these to 10,3 for DECIMAL. Now it shows up as 9.975 in tax rules etc. tblinvoices tax tax2 taxrate taxrate2 tabletax taxrate tablequotes tax1 tax2 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted January 19, 2013 Share Posted January 19, 2013 For QC tax i have modified all of these to 10,3 for DECIMAL. Now it shows up as 9.975 in tax rules etc. tblinvoices tax tax2 taxrate taxrate2 tabletax taxrate tablequotes tax1 tax2 Actually i dont think that is correct here, unless you want your total tax amounts to be 3 decimal as well and i dont think you want that. here i will break this down for you here. You just want to extend the tax rate not the tax amount fields. So... tblinvoices tax - this is the amount of tax charged (result) to the customer you want this at 10 2 tax2 - this is the amount of tax charged (result) to the customer you want this at 10 2 taxrate - this is your tax rate which yes needs to go from 10,2 to (i set mine at 10,4) taxrate2 - this is your tax rate which yes needs to go from 10,2 to (i set mine at 10,4) tabletax taxrate - this is your tax rate which yes needs to go from 10,2 to (i set mine at 10,4) tablequotes tax1 - this is the amount of tax charged (result) to the customer you want this at 10 2 tax2 - this is the amount of tax charged (result) to the customer you want this at 10 2 The thing is you want to change the tax rate (x.xxxx) to appropriate for your area 10,4 should handle most. But you want the result of that calculation to be rounded off to 2 decimal places. Otherwize your going to charge your customers $x.xxxx in taxes and thats prob not correct for you. You only want $x.xx in the charged tax area. Hope that helps. 0 Quote Link to comment Share on other sites More sharing options...
uname-r Posted June 3, 2013 Share Posted June 3, 2013 Bonjour kyrotomia I am also from Québec Don't worry about the 3 decimals. It's ok to round up : our money no longer include penny anyway. Everything is rounded up I would like to point you to this : http://cccd-rcc.org/fr/revendication/notice20120705.asp It say : "Après plusieurs échanges avec des représentants du ministère des Finances, ce dernier a confirmé au CCCD qu'il sera toujours possible pour un détaillant, comme par le passé, d'utiliser des facteurs mathématiques arrondis à deux points décimaux lorsque le système de caisse enregistreuse utilisé ne permet pas de déterminer la TVQ au taux réel de trois décimales (art. 69.3.1L.R.Q., chapitre T-0.1, Loi sur la taxe de vente du Québec). Des modifications seront apportées à l'article 69.3.1 à l'automne afin de clarifier la procédure." so nothing to worry about this. ...peoples are used now to get everything rounded up, and i don't think they will bother about this. Hope that help 0 Quote Link to comment Share on other sites More sharing options...
Frankk Posted June 4, 2013 Share Posted June 4, 2013 uname-r, The requested change to WHMCS is not only to benefit Quebec (which I am from) but other users might and do need it to operate their businesses. I still think that this is good for the software to allow for at least 3 decimal places in taxes. as pointed in a previous post I made, it's easy to fix the software as I've done it myself and it's been working great for me eversince. 0 Quote Link to comment Share on other sites More sharing options...
webadpro Posted September 17, 2013 Share Posted September 17, 2013 This should actually get fixed. Even though Quebec's Gov allow the exception, not every country/state do. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.