Invoice Not Accepting Part Values in Qty
Invoice Not Accepting Part Values in Qty
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).
Re: Invoice Not Accepting Part Values in Qty
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.
Re: Invoice Not Accepting Part Values in Qty
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.
Re: Invoice Not Accepting Part Values in Qty
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.
Re: Invoice Not Accepting Part Values in Qty
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
- Attachments
-
- Untitled-2.jpg (34.58 KiB) Viewed 1834 times
-
- Untitled-1.jpg (42.44 KiB) Viewed 1834 times
Re: Invoice Not Accepting Part Values in Qty
in admin/controller/billing/invoice.php look for the following
and change to
Code: Select all
(int)$item['quantity']
Code: Select all
(float)$item['quantity']
Re: Invoice Not Accepting Part Values in Qty
Esmond - Thanks works great!