Invoice total does not match the sum of time entries

James Jensen's Avatar

James Jensen

09 Jun, 2013 01:26 AM

So each time entry in the invoice is rounded to the nearest hundredth. The problem is that the invoice total is not a summation of these rounded entries. Instead, the invoice total is rounding AFTER summing all time entries.
So half the time the invoice total matches and half the time it does not. It just depends how many time entries were rounded up and how many were rounded down.

To fix this invoices will need to either:
1. Have the invoice total be a total of the rounded entries. (probably preferred but more complicated to program)
2. Round all entries up or down and not the nearest hundredth place.

Just a note that this same issue naturally causes problems when matching exported time entries to the invoice total. So any spreadsheet calculations will not match the invoice total.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Capture.PNG 44 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac