Hours column being rounded up

[cybersalt]

When I add a billable item that is hours worked, the amount of hours is being rounded up in the hours column.

 

For instance, if I enter ".25" in the hours/quantity field, once saving the entry the "hours" column shows ".3", while the amount column still shows the right calculation for ".25" times whatever the hourly rate I have entered for the "quantity".

 

I cannot find where to change the setting that is rounding up that column.

 

Thanks.

 

Tim

[brian!]

Hi Tim,

 

I cannot find where to change the setting that is rounding up that column.

I suspect the only place you can fix this is by directly editing the 'tblbillableitems' database table - the 'hours' field is set to 1 decimal place and that's why you're seeing 0.25 being stored in the database as 0.3; as you suggest, the total amount calculation must be based on the number entered, not the one stored in the table.

 

 

if you were to edit the table (e.g using phpmyadmin) and set the value to 2 decimal places; then edit the billable item in the admin area and change 0.3 to 0.25, it would then be stored in the table as 0.25

 

as with all database changes like this, backup the database first before making any changes.

Edited September 17, 2016 by brian!
fixing quote