Feature: Auto Calculate Price when Invoicing Ticket

Bigbug

Hi @johnny can you please explain in more detail what this update is all about?

johnny

what update are you referring to?

johnny

I'm guessing your referring to this commit:

itflow-org/itflow61c9c0c

Basically when your in a ticket and you choose to invoice the Ticket using the invoice ticket button.

It now calculates the price for you based off total time you worked in a ticket rounded up to the nearest 15 minute mark in decimal format and then multiplies it by the client rate, also adds an item line called Service [Hourly]

so for example lets say you have the client rate set to 200.00 an hour, if you worked a ticket total time 5 minutes, it will round it up to 15 minutes convert it to decimal and multiply by the client rate.

As a result: Quantity would be 0.25 and price will be 50.00

These field values can be modified if you choose to do so.

It just makes invoicing a ticket a little more automatic when you go to bill your client.

Also to note if your client rate is 0 then the price will be 0 but can be modified

Bigbug

johnny that's exactly what I meant!

but the problem is that, for example:
hourly rate for x customer is 200 X 0.25 = 50 but then when creating the invoice it multiplies it again into 0.25 which results in a incorrect total.

🙏

johnny

it will because it rounds up to the next 15 min decimal number

for example a ticket you work exactly 00:15:00 which is 15 mins and 00 seconds will be 0.25

but if the ticket timer were to even calculate one more second such as 00:15:01 then it will round up to 30mins which is 0.50

Bigbug

Please give a look at this invoice in demo, tell me if everything makes sense with the auto-calc feature.

https://demo.itflow.org/invoice.php?invoice_id=219

Guest URL:
https://demo.itflow.org/guest_view_invoice.php?invoice_id=219&url_key=JU9iptc00OrtGJs9mCUtWds9DagGwEuSW9iksp1qiEcBbOgXFWKX010Egw2jG3kn1O3KhedJ9sIYJLvxghwK9zYV1RX9ev02acfcxZnytq3b0qDVJXOfxE5rbJUt0VkrclTUxrBz2FbPrDhY4GRY0sBU0de2

johnny

Yes it is out of wack! the price should be the client hourly rate / 4 to accommodate for the 15 min increments

so when invoicing a ticket and a client has a rate of 200.00 and you worked 15 mins the QTY field should show 0.25 and the price field should show 50.

This is now fixed, please test to see if this works better or if there is a better way of doing this we are open to ideas

also we fixed the roundupto15 to just round to 15 so it will round down or up but always be minimal of 15 mins

johnny

see commit here

itflow-org/itflow31c9a6a

and here

itflow-org/itflow8ebe7ed