Total Tax Per Tax Group on Quotes and Invoices

andrej · March 27, 2015, 7:37pm

Hi

In Croatia we need to show total VAT per VAT group on Invoice/qoute… Invoice is not valid unless tax is shown in that way … it mandatory by law

Is it posibble (i did not go customizing to check for strings yet) to have it show in total VAT per VAT Group

so lets say you have one item with 5% tax, one with 13% tax and one with 25% tax…

Sorry about my writing wrote with mouse

This is correct, example from Tax Agency site…

Before 1 is total amout without taxes

Is total of line items that are taxable with 10% tax
Is total of line items that are taxable with 25% tax
Total tax in 10% group
Total tax in 25% group
Total TAX
After this is total amount with taxes…

This is all minimum information that must be on invoice (discount does not, but this is correct way of displaying it)

I know more and more are geting fiscalisation so i think you need prepare for this especialy in v2…

v1 needs just update if its possible in qoute/invoice template i guess… cose there is information for items in wich tax group they belong… so it should be posible to get it this way…

Kovah · March 27, 2015, 7:55pm

Yes tax rates should be displayed per item… I’ll take a look at this and it will be included in one of the following versions.

andrej · April 14, 2015, 3:48pm

did you take a look

in 1.3 its not also like this…

if you saw… under total tax it should have total tax per tac group… like i wrote and gave example…

i see all data is there in db… maybe i can get it just out on invoice, but how can i get sum tax for items in tax group with 5% , sum of tax for items in tax group with 10% tax and etc … and display it on invoice…?

Also i did not get payment method on invoice, i get only ID of payment method…

Kovah · April 14, 2015, 5:31pm

Yes but I can’t work on all feature requests at the same time. Maybe the next release.

andrej · April 14, 2015, 5:45pm

heh language barrier ;/

i meant can i access thru invoice template that data to implement my self? or its needed to make chamges in system… i see all the data in db, just need a pointers how to access it …

Kovah · April 14, 2015, 5:52pm

Oh sorry, too much to read at the moment… ^^

Place this at the bottom of the template and you’ll get all data you can access:

<pre><?php print_r($invoice); ?></pre>

andrej · April 14, 2015, 6:28pm

is there a list of all things i can access this way?

i see i can access also

<?php print_r($item); ?>

Anything else?

Maybe it would be good (well i know you are overworked as it is) to have somwhere list of thing we can access… on wiki somewhere it would be easier to customize templates that way

i see i can make now some kind of loop

create (hard coded for now) string in php for each tax group and use if the to sum each tax group and print it on invoice

heh… well hope i’ll learn enough to help, not just ask and give you some work

Kovah · April 14, 2015, 6:34pm

At least all different variables that are used in the templates

andrej · April 14, 2015, 6:47pm

yes … that would help a lot

i know when i finish customizing i’ll donate this to this project if you want to inclued it in some future version

Kovah · April 19, 2015, 7:35am

[size=10]Last Update 19.04.2015[/size]

Fatih · April 30, 2015, 10:12pm

@Kovah @andrej

I have a quick fix for this. Its not the best way but it works.

Code:

<?php
$tax_percentages = array();
foreach($items as $item):
	$tax_percentages[$item->item_tax_rate_percent] += $item->item_tax_total;
endforeach;
?>

And show the lines with this:

<?php if ($invoice->invoice_item_tax_total > 0) { ?>
                            <tr>
                                <td class="text-right color-n">
									<?php foreach($tax_percentages as $percentage => $amount) { ?>
										<?php echo lang('item_tax_rate_percent') . " " . $percentage . "%<br>\n"; ?>
									<?php } ?>
                                </td>
                                <td class="text-right color-n">
									<?php foreach($tax_percentages as $percentage => $amount) { ?>
										<?php echo format_currency($amount) . "<br>\n"; ?>
									<?php } ?>										
                                </td>
                            </tr>
                        <?php } ?>

It works for me, i hope this will help with further developing.

regards…

daansk44 · June 14, 2015, 9:59pm

*Where can I find this file / page

'and can I get a complete version of the edited file ? ’

gsolina · June 15, 2015, 8:12am

Hello
Try this Invoice template for (not only) Italian Financial Rules (several tax rates)
I did it according to latest Italian Financial Rules
BR
gsolina

daansk44 · June 15, 2015, 6:09pm

But where can I find the template of the Invoice? (so I can edit it)

gsolina · June 15, 2015, 6:27pm

hello
at the bottom of my mentioned post there is the link for downloading my template.
then you can store it into the folder views/invoices/pdf

daansk44 · June 15, 2015, 8:14pm

I have this now and I have it almost, but I am stuck

I have the productname Description, Price, Total
But lets see

The product hosting Large

Amount is one, price is €3,72 then you see the tax, but that is the total price and afther that you see the 21% tax and the last one is the total product amount but that is twice €42,78?

Hire I have the script

I want to make it like this
'Product, Description, Amount, Price, Tax (like 21%), total exc tax …, total inc tax
Would be awsome
rsl.php (13.2 KB)

Fabio_Sasso · January 17, 2016, 7:11pm

It’s an old post but it seems that the problem still exist.
I fixed it by adding the selection of the item tax rate name in the file mdl_items.php at row 28.

Before was:

$this->db->select('ip_invoice_item_amounts.*, ip_invoice_items.*, item_tax_rates.tax_rate_percent AS item_tax_rate_percent);

Now is:

$this->db->select('ip_invoice_item_amounts.*, ip_invoice_items.*, item_tax_rates.tax_rate_percent AS item_tax_rate_percent, item_tax_rates.tax_rate_name AS item_tax_rate_name');

and then add this code to the invoice template (I’m using the InvoicePlane template), after the “Subtotal” row:

<?php if ($invoice->invoice_item_tax_total > 0) { ?> 
    <?php $taxes = array();  ?>
    <?php foreach ($items as $item) : ?>
        <?php $taxes[$item->item_tax_rate_name] = $taxes[$item->item_tax_rate_name]+$item->item_tax_total ?>
    <?php endforeach ?>
    
    <?php foreach ($taxes as $tax_name => $tax_amount) : ?>
        <tr>
             <td colspan="5" class="text-right">
                 <?php echo $tax_name; ?>
             </td>
             <td class="text-right">
                 <?php echo format_currency($tax_amount, 3); ?>
             </td>
        </tr>
    <?php endforeach ?>
<?php } ?>

Sorry if it’s not the cleanest way but it works. I’m not good with MVC patterns and I don’t have the time now to elaborate a cleaner code.

Hope it helps.

norfolkandway · August 4, 2016, 10:38pm

HI
Was this ever implemented (Tax per item column)
I have added tax rate per item column but client is wanting to display tax amount per item
If not imlemented can anyon eplease rived constant for disply
ie - to display tax rate I have added

<?php echo format_amount($item->item_tax_rate_percent); ?>

What would be the string for tax amount?
Thanks
Iain

norfolkandway · August 4, 2016, 10:45pm

Found it

<?php echo format_currency($item->item_tax_total); ?>

Thank you and hoe this may help others