Cita.M
November 15, 2016, 11:08am
1
Installed new version on 1.4.10. VAT is calculated on the price before the discount. In many countries, VAT is only due on the discounted product price. Is there a setting that I overlooked to achieve this ?
Kovah
November 15, 2016, 1:32pm
2
Hello,
this problem was discussed multiple times in the forum. Please use the search first before posting a new support thread.
Quick summary: there is no option for it and it’s not possible within InvoicePlane by default. You have to enter discounts as separate items.
After skipping several updates(i altered the code to much) i installed the last version(1.4.9)
I noticed that the item totals are wrong calculated when adding discount.
The tax amount is not correct.
Discussed it already a long time ago in this post: bug
see attached screenshot.
it must be:
item= 10
discount= 2-
subtotal = 8
tax 21% = 1,68+
Total = 9,68
[image]
I think you mean the discount for each item in invoice/quote. For invoices you must change following lines in application/modules/invoices/models/mdl_item_amounts.php :
$item_subtotal = $item->item_quantity * $item->item_price;
//$item_tax_total = $item_subtotal * ($item->item_tax_rate_percent / 100);
$item_discount_total = $item->item_discount_amount * $item->item_quantity;
$item_tax_total = ($item_subtotal - $item_discount_total) * ($item->item_tax_rate_percent / 100);
$item_total = $item_sub…
Suppose we add 10 items for 10 euro each, total 100 euros (no item tax in this example). Then we need to make a discount of 10 euros (per invoice not per item), so the total goes to 90. And then we need to add the invoice tax, for example 23%.
In such a case the formula would be: 10 x 10 = 100 - 10 (inv. discount) = 90 + 23% = 110,7
As it is now, IP calculates the invoice discount like this:
10 x 10 = 100 + 23% = 123 - 10 (inv. discount) = 113
Is there an option to calculate the discount bef…