dynamichosting Posted February 25, 2011 Share Posted February 25, 2011 Billable hours are rounded up to the nearest tenth of an hour in the reporting screen. This doesn't affect invoicing, but is confusing. Ex. Logging .25 hours rounds bills out at .25 x rate but shows as .3 hours. This should be an option somewhere in the Setup section as different companies bill to different increments. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted March 5, 2011 WHMCS CEO Share Posted March 5, 2011 To enable the billable items hour/quantity field to support more than 1 decimal place would just require editing the format of the database field in the tblbillableitems table of the database. Matt 0 Quote Link to comment Share on other sites More sharing options...
CavalloComm Posted January 9, 2012 Share Posted January 9, 2012 Sorry to open this thread up, but I have this same issue. Can you tell me which field to change and what to change it to? 0 Quote Link to comment Share on other sites More sharing options...
CavalloComm Posted January 12, 2012 Share Posted January 12, 2012 I figured it out. 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted January 12, 2012 Share Posted January 12, 2012 For those of you looking to do this, the following SQL query will update the field to support 3 decimal places (X.XXX): ALTER TABLE `tblbillableitems` CHANGE `hours` `hours` DECIMAL( 5, 3 ) NOT NULL 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.