number of possible decimals in the tax rate from 2 to 3
-
Martin Blanchette shared this idea 11 years ago
- Payments/Billing
- 28 Comments
60
Votes
Number of decimals in the tax rate from 2 to 3
Government can change tax rate anytime! We currently have this problem...
We can run the following command using the SQL tab:
ALTER TABLE
NULL;
This will modify the number of possible decimals in the tax rate from 2
to 3 and should allow you to enter the new tax rate as needed. Ex: 5.553%
instead of 5.55%
PROBLEM:
new Quote works! (with 3 decimals)
new invoice don't! (only use 2 decimals)
Please, we need this modification. Thank you very much!
Government can change tax rate anytime! We currently have this problem...
We can run the following command using the SQL tab:
ALTER TABLE
tbltax CHANGE taxrate taxrate DECIMAL( 10, 3 ) NOT NULL;
This will modify the number of possible decimals in the tax rate from 2
to 3 and should allow you to enter the new tax rate as needed. Ex: 5.553%
instead of 5.55%
PROBLEM:
new Quote works! (with 3 decimals)
new invoice don't! (only use 2 decimals)
Please, we need this modification. Thank you very much!
Featured Comment
I'm pleased to announce that the 8.0 public beta is now live, featuring 3 decimal places in tax rates and numeric values up to 99 trillion across the product! Please test it out, and let us know your feedback during the pre-release period.
Beta information: https://beta.whmcs.com
Discussion: https://whmcs.community/topic/301698-improved-currency-support-taxes/