Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tax Authorities Rates
06-08-2015, 10:27 AM,
#1
Tax Authorities Rates
Hi All
I am new to weberp I am having issues with the Tax Authorities rates are rounding off I have some Tax Authorities that need to have a rate of 3.788 when I do it rounds to 3.79 is there a way I can change this.
Thanks
Reply
06-08-2015, 04:32 PM,
#2
RE: Tax Authorities Rates
You would need to go into mysql using phpMyAdmin and modify the rates accordingly. There is only option to enter percentages with 2 decimal places - it will display 2 decimal places but store more if you edit in mysql directly.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
06-08-2015, 06:48 PM, (This post was last modified: 06-08-2015, 06:48 PM by TimSchofield.)
#3
RE: Tax Authorities Rates
(06-08-2015, 10:27 AM)daveparrish Wrote: Hi All
I am new to weberp I am having issues with the Tax Authorities rates are rounding off I have some Tax Authorities that need to have a rate of 3.788 when I do it rounds to 3.79 is there a way I can change this.
Thanks

Hi Dave, that rate is stored in however many decimal places you enter it in, so it will be stored in the db as 0.03788 and the calculations will use that. To show more decimal places amend line 105 of TaxAuthorityRates.php from

locale_number_format($myrow['taxrate']*100,2));

to
locale_number_format($myrow['taxrate']*100,3));

or change the 3 to however many decimal places you need to show. You might want to expand the size of the input box in line 97 as well.

Thanks
Tim
Reply
06-09-2015, 10:31 AM,
#4
RE: Tax Authorities Rates
(06-08-2015, 06:48 PM)falkoner Wrote:
(06-08-2015, 10:27 AM)daveparrish Wrote: Hi All
I am new to weberp I am having issues with the Tax Authorities rates are rounding off I have some Tax Authorities that need to have a rate of 3.788 when I do it rounds to 3.79 is there a way I can change this.
Thanks

Hi Dave, that rate is stored in however many decimal places you enter it in, so it will be stored in the db as 0.03788 and the calculations will use that. To show more decimal places amend line 105 of TaxAuthorityRates.php from

locale_number_format($myrow['taxrate']*100,2));

to
locale_number_format($myrow['taxrate']*100,3));

or change the 3 to however many decimal places you need to show. You might want to expand the size of the input box in line 97 as well.

Thanks
Tim

Thank You Tim worked great.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)