Invoice Not Accepting Part Values in Qty

[Chewie]

The invoice is not generating the correct 'Total' amount if the qty is a non-whole number (ie 2.5) it seems to drop the partial number from the equation (ie the .5).

[Esmond]

Ah, that's because quantity has to be a whole number. If you need to change that, changes to the database will be required from INT to DECIMAL.

[nicknick]

I would like to have this feature. Maybe you could elaborate on which tables would need to be changed. I have changed 'invoice_item' to decimal value however the system stripes any number right of the decimal and does not calculate a new total.

[Esmond]

On top of changing the database, you will need to look into admin/model/billing/invoice.php and change (int) to (float). That should get things going for you.

[nicknick]

Thanks for instructions. I have applied this suggestion however my results aren't really working the way they should. Attached are the results I am getting. It seems to have calculated somewhat however it isn't working throughout the system. Any additional help would be greate! Sorry not well versed in php

[Esmond]

in admin/controller/billing/invoice.php look for the following

Code: Select all

(int)$item['quantity']

and change to

Code: Select all

(float)$item['quantity']