Feature Requests
Share ideas, discuss and vote on requests from other users in community
 

Rounded off hours on invoice

Arthur Jansen shared this idea 1 year ago
Under Consideration

I just wanted to create a new invoice for some hours we worked for a cliënt and I noticed that the hours are rounded off to one decimal, while the amount is still calculated in 2 decimals.

Example:

I want to invoice 0.25 hours (which isn't strange right? A lot of companies round off their worked hours to 15 minutes) of €67.00 which is €16.75. I can fill this out in 2 decimals when I go to "Add Time Billing Entries", but when I then look at the billable item, it says 0.3 hours is €16.75 (while 0.3 needs to be €20.10 and 0.25 is €16,75).

So it rounds of the hours (which is weird), and then it also shows the wrong amount, because it shows the amount for 0.25.

With kind regards,

Arthur

Comments (6)

photo
1

This is a huge annoyance to me as well. We also bill in 15 min increments and have been having this issue for years.

I sent in a ticket to WHMCS asking them about this issue on Feb 5th 2014 (ref: ESQ-399861) but to no avail.

Years on, no improvement. Surely this would only take a few minutes to resolve?

photo
1

Hi there,

Thanks for your suggestion.

The rounding to which you referred is due to a database field condition. This could be customised on your installation by changing the field type of the tblbillableitems.hours field from DECIMAL(5,1) to DECIMAL(5,2).

I wouldn't foresee this changing causing problem in future.

photo
1

Hi John, this is an issue I have also been encountering for years (I first lodged a ticket 4 years ago with WHMCS about it). Is the something we can just change in phpmyadmin or is there more too it than that? Also, is a permanent change (i.e. this set by default) to WHMCS likely to come any time soon?

photo
1

Hi there,

Yes a simple database structure change in this case is all that's required. That is something you could do via phpmyadmin.

photo
1

Thanks John! I got the specifics of what query I needed to run via a support ticket and the problem has been solved! After 4 years... it's finally solved!!! :-D

photo
1

Great, but would this be something WHMCS could roll out in the next update as well?

photo