Jump to content

Remove "Tax Excl." & "Tax Incl." from Invoice


Recommended Posts

I'm not registered for VAT so I don't want these appearing on my Invoice. I've successfully removed them from my shopping cart by editing shopping-cart.tpl, but I can't see how to do it for the invoice.

V 1.5.4.1 with slightly modified default theme.

Any help much appreciated.

Thanks

John

Link to comment
Share on other sites

you don't have to edit .tpl file as you did (shopping-cart.tpl)

go to localizations > countries

click on edit button near the active countries

and change option:

i5cQfNO.png

 

moreover, you can disable taxes under the localization > taxes tab in your back office - this is the proper way

  • Like 3
Link to comment
Share on other sites

Ok, I've now set localization/taxes and localization/countries both to no tax and I've just done a test purchase and the "Tax Incl" and "Tax Excl" bits are still showing on the invoice. See attachment. I think Willouu maybe right and I have to edit the invoice.tpl file which is where he said it was. I'm not experienced enough to work out what changes to make so can someone advise please?

 

I just want the invoice to show the "Unit Price" and "Total" without the tax incl and tax excl. text

 

Thanks

John

 

post-62308-0-23860800-1375037376_thumb.jpg

Edited by Nodge (see edit history)
Link to comment
Share on other sites

I managed to do it by editing the invoice.tpl file. I didn't really know what I was doing so it was very much trial and error but got there in the end. Basically I substituted spaces for the unwanted text and figured out which bit of code to delete to remove the extra unit price.

  • Like 1
Link to comment
Share on other sites

Yes, both places as you said - see settings attached ..post-62308-0-15098000-1375039672_thumb.jpg

 

That is strange. I'm happy that you solved this issue using the .tpl file. However, when I turned off the tax fields as you showed, it did not show up in my invoice. Only the Unit Price (tax excl) showed up not the Unit Price (tax excl)

 

What I did do is toggle on and off the Tax in the Localization>Countries>edit ... That may have done the trick.

Link to comment
Share on other sites

Ok, that's weird. But if the invoice still showed Unit Price (Tax Excl.) as you say, then that would still be wrong as far as I'm concerned. There is no tax applicable in my case so the price is neither Incl or Excl of tax. See attached for what I have now ..

post-62308-0-81434800-1375136254_thumb.jpg

Edited by Nodge (see edit history)
Link to comment
Share on other sites

I'm sorry, Benjamin and vekia, but turning off the tax display just affects the front office display, it doesn't seem to have have any impact on the invoice template.

 

To avoid the tax display here it is necessary to deactivate the concerning parts directly in the invoice.tpl and modify the table width, which means in detail:

 

line 147 -172

   	 <table style="width: 100%" cellspacing="2">
			<tr style="line-height:4px;">
		   		 <td style="text-align: left; width: 10%; font-weight: bold">Nummer</td>
				<td style="text-align: left; width: 57%; font-weight: bold">{l s='Product / Reference' pdf='true'}</td>
				<!-- unit price tax excluded is mandatory -->
				{if !$tax_excluded_display}
					<td style="text-align: right; width: 12%; font-weight: bold">{l s='Unit Price' pdf='true'} </td>
				{/if}
				<!--<td style="text-align: right; width: 12%; font-weight: bold">
					{l s='Unit Price' pdf='true'}
					<!--{if $tax_excluded_display}
						 {l s='(Tax Excl.)' pdf='true'}
					{else}
						 {l s='(Tax Incl.)' pdf='true'}
					{/if}-->
				</td>
				<td style="text-align: right;width: 6%; font-weight: bold">{l s='Qty' pdf='true'}</td>
				<td style="text-align: right;width: 15%; font-weight: bold">
					{l s='Total' pdf='true'}
					<!--{if $tax_excluded_display}
						{l s='(Tax Excl.)' pdf='true'}
					{else}
						{l s='(Tax Incl.)' pdf='true'}
					{/if}-->
				</td>
			</tr>

 

and lines 178 - 191

 <td style="text-align: left; width: 57%">{$order_detail.product_name}</td>
 <!-- unit price tax excluded is mandatory -->
 {if !$tax_excluded_display}
  <td style="text-align: right; width: 12%">
  {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_excl}
  </td>
 {/if}
 <!--<td style="text-align: right; width: 12%">
 {if $tax_excluded_display}
  {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_excl}
 {else}
  {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_incl}
 {/if}
 </td>-->

 

I guess this is like the solution Nodge has found.

Edited by eleazar (see edit history)
Link to comment
Share on other sites

I'm sorry, Benjamin and vekia, but turning off the tax display just affects the front office display, it doesn't seem to have have any impact on the invoice template.

 

Hi Rainer, it does effect the invoice. However, the Unit Price still shows (tax excl) even though there is no tax. That is something we will fix. In the mean time, thank you very much for your code.

 

Nodge, could you try this code out and let us know how it works for you. If so, we could solve this thread and use eleazar's code as a solution.

 

attached is the invoice with the problem, note the (tax excl) but it doesn't show the unit price with the (tax inc) because we turned it off.

post-360108-0-24303100-1375204348_thumb.jpg

Link to comment
Share on other sites

  • 2 weeks later...

Having the same issue. Turning off tax in these spots on the backend does nothing to my invoice. Can someone please tell me the exact spots of code within the Invoice.tpl that I need to comment out/change? The code above that eleazar posted did not work for me. It removed my products completely and I have also done some minor modifications to my PDF over the last few months. My line #'s didn't match any where near his.

 

Thanks!

Link to comment
Share on other sites

Hello Nodge & Benjamin,

 

I also do have the same situation in here, just like Nodge. My Invoice still showing the tax label and also the tax table on the bottom of total price.

Then i switch off the tax option just like Benjamin told in here :

- Localization>Countries>Edit

- Localization>Taxes

 

What i want tho show is, the invoice before the tax option disabled is stil showing the tax label & tax table.

It works on the new order after the tax option disabled. I've try making some new order, and then checking out the invoice of the new order and.. Tada.. the tax label & table is gone! :D

 

And i think it would be good if prestashop is adding the ability to regenerate Invoice for the customer order, or it is already there? I still don't figure it yet ;)

Link to comment
Share on other sites

Hi juraganpsd,

 

I don't think this is a bug in PrestaShop. And it's not a problem of the invoice either. The invoice will be regenerated every time you press the invoice button. PDF invoices aren't saved in PrestaShop. You won't find any directory with archived pdfs. ;)

This is about saved data in ps_orders table of the database. The order once saved should stay untouched and free from subsequent modifications.

 

So I think it's up to you to make sure before the first order is placed if you want the tax option switched off or not!

  • Like 1
Link to comment
Share on other sites

  • 3 months later...

Hi,

 

I have the same problem with the pdf-invoice.

For me its more complex:

Our shop is located within the EuropeanUnion, we deliver to countrys within EU (incl.Taxes) and to countrys outside EU (excl.taxes).

 

So I cant switch off  localization > taxes globaly.

I assigned tax rates and rules to the countrys within EU (as its standard with the installation)

and switched OFF taxes at Localization>Countries>edit for countrys outside EU

 

However this has no effect on the PDF-Invoice, it allways shows: "total price incl. VAT" - this is terrible wrong for countrys outside EU and we will face problems with this.

 

So, there is a param driving the behaviour of the PDF-invoice concerning the taxes:

"$tax_excluded_display"

 

From which setting in the back-office is this parameter driven (imo globaly localization > taxes ??).

What parameter I do have to use if I want to check if "Localization>Countries>edit>show taxlabel" is set for the country I have to deliver or not?

 

Edit: The prices itself are correct for all Countrys (EU/nonEU) so the within EU the priced include VAT, outside excl VAT, its only to display labels correct.

 

Thanks in advance

Edited by cong2013 (see edit history)
Link to comment
Share on other sites

I guess this isn't a Prestashop problem. I cannot verify this behaviour. When I switch off taxes for e.g. USA the tax_excluded_display works perfectly with the invoice for foreign customers.

 

Maybe it's better you check if there are some modifications in your shop that are not genuine Prestashop core - like for instance this 'total price incl. VAT'. Maybe it depends on your theme, I don't know, but as far as I know in Prestashop default it's called 'total price (tax incl.)'

Link to comment
Share on other sites

 

Maybe it's better you check if there are some modifications in your shop that are not genuine Prestashop core - like for instance this 'total price incl. VAT'. Maybe it depends on your theme, I don't know, but as far as I know in Prestashop default it's called 'total price (tax incl.)'

Hi,

 

The different naming of the label is cause of translation of the pdf where I changed some english strings (in the BO not in the php/tpl)

I took a look at the ps##_country where I found the field "display_tax_label" - is this the one triggered in the invoice.tpl as $tax_excluded_display ?

 

As for the Theme: Its the "warehouse"-theme and I havent found any override for the default invoice.tpl or related controllers.

Link to comment
Share on other sites

I took a look at the ps##_country where I found the field "display_tax_label" - is this the one triggered in the invoice.tpl as $tax_excluded_display ?

 

 

Exactly. Disabling tax display in BO country leads to hiding the tax label and taxes. Normally.

Works fine with default shop system.

Link to comment
Share on other sites

Exactly. Disabling tax display in BO country leads to hiding the tax label and taxes. Normally.

Works fine with default shop system.

 

Hmmm..

I dont want to be a pain, however the way changing the TAX-settings for the countrys dosnt work for me, so I tried to investigate where the 'tax_excluded_display' is derived from

 

I found in HTMLTemplateInvoice.php the following code:

'tax_excluded_display' => Group::getPriceDisplayMethod($customer->id_default_group),

 

So for me it looks like that 'tax_excluded_display' is driven by the settings that are defined in the customer groups settings.

And - changing of the tax settings in the default customer group to "netto" changed the label in the pdf-invoices to non VAT.

However, thats no solution.

 

Does anyone know how to get the ps_country>display_tax_label for the delivery address of the current order (code for HTMLTemplateInvoice.php).

 

Thanks in advance

Edited by cong2013 (see edit history)
Link to comment
Share on other sites

Following from http://www.prestashop.com/forums/topic/294541-pdf-rechnung-immer-in-deutsch/?do=findComment&comment=1487256:

 

We are discussing invoices with/without tax displayed, like these ones:

http://www.presta-addons.com/pdf/Invoice%20-%20with%20single%20integrated%20label.pdf

http://www.presta-addons.com/pdf/Invoice%20-%20outside%20the%20EU.pdf

 

Templates in the M4 PDF Extensions module can use more approaches to display taxes. Actually all invoice templates use this approach which works nice for invoices inside/outside of the EU as well as for EU companies registered for VAT (invoice without VAT):

 

There is a condition evaluated for PS_TAX configuration value (means taxes are used in the shop) and the same amounts of totalProductsWithTax and totalProductsWithoutTax (means the total price with tax is the same as one without tax).

Link to comment
Share on other sites

  • 2 weeks later...

Hi vekia, as you mentioned above teh right way to disable all teh taxes is in LOCALIZATION>COUNTRY.

 

I have done just that for my country, but whenever a user bills and ships to that same country the label (tax exclu) still appear.

 

i have removed all tax options in the BO, cant find what else i am suppose to do.
 

post-458754-0-26228000-1387363732_thumb.jpg

Link to comment
Share on other sites

Benjamin :

 

 

 However, the Unit Price still shows (tax excl) even though there is no tax. That is something we will fix. In the mean time, thank you very much for your code.

Has the issue been resolved in 1.561? i still see that the label still shows (tax excl) For me it shows in the shipping and in the pdf invoice

Edited by ricky11 (see edit history)
Link to comment
Share on other sites

  • 1 month later...

Hi,

 

looks like its hard coded. I was able to remove by modifying invoce.tpl in pdf folder

 

1) remove  <br />{l s='(Tax Excl.)' pdf='true'}

2) search for Tax Excl string and delete it

3) save the invoice.tpl

 

now regenerate invoice in BO :)

Link to comment
Share on other sites

Did this ever get sorted out? I tried the edits mentioned earlier, but it moves all the columns aout and nothing matches up.

Has anyone got an edited invoice.tpl file, where the edits have been corrected? For version 1.5.6.2

Thankyo

 

 

delete the following from invoice.tpl

 

1) <br />{l s='(Tax Excl.)' pdf='true'}

2) {if $tax_excluded_display}

                                                         {l s='(Tax Excl.)' pdf='true'}

                                                {else}

                                                         {l s='(Tax Incl.)' pdf='true'}

 

 

 

3) {if $tax_excluded_display}

                                                        {l s='(Tax Excl.)' pdf='true'}

                                                {else}

                                                        {l s='(Tax Incl.)' pdf='true'}

                                                {/if}

 

 

 

4) (Tax Excl.)

Link to comment
Share on other sites

  • 2 weeks later...

Yes that is what i have done, basically we put a  space in the English translation where all tax is concerned.

 

I hope PS 1.6 or a future update of 1.5 has a SWITCH that will switch of all tax everywhere on the site and BO.

 

 

Note that hosted solutions like bigcommerce and shopify have caught up with the flexibility of prestashop, they now allow you to edit templates, most css and a lot of the html, certain script limitations still apply, but they are getting increasingly flexible, they also include free CDN and blazing fast hosting and no or close to nil transaction fees. There are only a handfull of PS 1.5 sites that load up within 5 seconds, world-wide, i can tell you more than 70% of bigcommerce and shopify stores load up in 2-4 seconds.  I am not touting them, I use to be a Bigcommerce user and moved to prestashop and i would say i am quite experienced in both,  but i am considering moving back with all their advances.  

 

On a side note: the problem that PS has are the poor modules by third party and often broken and poor support. Modules generally suck sorry to say, if you get them working after hours of tweaking then thats great, but otherwise if it's not in the box it's going to be a pain to set up.  

 

It really is silly annoyances like "why can't i remove tax from my checkout" that will continue to plague prestashop until the community developers decide to make a fix for it, god knows we have all petitioned on github for a long long time.

 

I still can't believe PS1.5 doesn't have a working 1 page checkout that actually works. 

 

All said, i still love PS, simply hoping for better days.

 

RICKY
 

Edited by ricky11 (see edit history)
Link to comment
Share on other sites

Did this ever get sorted out? I tried the edits mentioned earlier, but it moves all the columns aout and nothing matches up.

Has anyone got an edited invoice.tpl file, where the edits have been corrected? For version 1.5.6.2

Thankyou

Hi,

 

This workaround works for me (1.5.6.1)

<!-- Kernbeis fix excl incl taxes set at line 71 at pdf/invoice.tpl right bevor "Products tab" -->
{assign var="export" value="1"}

{if (($order_invoice->total_paid_tax_incl - $order_invoice->total_paid_tax_excl) > 0)}
	{assign var="export" value="0"}
{/if}

<!-- replace all following $tax_excluded_display in the PRODUCTS TAB with $export -->
<!-- Kernbeis fix taxes -->


<!-- PRODUCTS TAB -->
Edited by cong2013 (see edit history)
Link to comment
Share on other sites

  • 7 months later...

Remove these two blocks of code from /pdf/invoice.tpl template.

<!-- unit price tax excluded is mandatory -->
{if !$tax_excluded_display}
    <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 20%">{l s='Unit Price' pdf='true'} <br />{l s='(Tax Excl.)' pdf='true'}</td>
{/if}

....

<!-- unit price tax excluded is mandatory -->
{if !$tax_excluded_display}
    <td style="text-align: right; width: 20%">
    {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_excl}
    </td>
{/if}
Link to comment
Share on other sites

  • 11 months later...

Hello,

 

I want to show the discount in invoice.product-tab to be inclusive of GST.

 

The discount inclusiv of GST is supposed to be RM5.00 but is is shown as RM 4.72 (excl. GST)

 

Reference       Product                                                         GST Rate             Base price (Tax incl.)                     Unit Price (Tax incl.)          Qty                Total (Tax incl.)
                          IRISTAL PLUS - Select Size : 120 capsules          6 %                                  --                                                  RM88.20                    1                      RM88.20

                                                                                                                 

                                                                                                                             Discounts
                                                                                                             Alterni Online Rewards Voucher                                                                                                - RM4.72

 

I believe below is the code that we need to change. I changed cart_rule.value_tax_excl to cart_rule.value_tax_incl but there were no figures shown at all.

------------------------------------------------------------------------------------------------------------

 

{l s='Discounts' pdf='true'}
            </th>
        </tr>
        {/if}
        <tr class="discount">
            <td class="white right" colspan="{$layout._colCount - 1}">
                {$cart_rule.name}
            </td>
            <td class="right white">
                - {displayPrice currency=$order->id_currency price=$cart_rule.value_tax_excl}
            </td>
        </tr>
    {/foreach}

    </tbody>

</table>

------------------------------------------------------------------------------------------------------------

 

I appreciate if someone can help me on this matter.

 

Thanks
 

Link to comment
Share on other sites

×
×
  • Create New...