Skip to Content
This question has been flagged
codeinvoicetax
1 Respondre
12458 Vistes
Avatar
Stephane Cyr

By default the PDF invoices generated show the 'Tax Code' - 'Tax Name' in the tax detail area (in the Tax, Base, Amount table. 

Tax                                  Base         Amount
---------------------------------------------------------
VAT-OUT-21-S - VAT 21% - Services    75.00 €      15.75 €

What modification is required to only show the 'Tax Name' field in under the Tax column of the tax detail table.

For example, for Belgium chart of account, the tax name shown is: VAT-OUT-21-S - VAT 21% - Services where 'VAT-OUT-21-S' is the tax code and 'VAT 21% - Services' is the tax name.

How can I get rid of 'VAT-OUT-21-S - ' to only show 'VAT 21% - Services' ?

Avatar
Descartar
Prakash

In Menu Customer Invoice --> Print --> Invoices Default Invoices Report its shows Tax Name only. In the "account_print_invoice.rml" code using [[ repeatIn(o.tax_line,'t') ]] [[ t.name ]] to display name in report. In your case where do you print the reports?

Stephane Cyr
Autor

Which version are your running? I'm running Version 7.0-20140129-002604 which was installed without any modification. I tired with different charts of account and always have the same issue whether I create a customer invoice from Accounting -> Customer Invoice -> Create button or from Sales -> Sales Orders -> select a SO# with Status Sale to Invoice -> Create Invoice. Yes I see [[ repeatIn(o.tax_line,'t') ]] [[ t.name ]] in "account_print_invoice.rml" but the tax code is printed on the customer invoice despite the [[ t.name ]] is written on the rml file.

Avatar
Prakash
Best Answer

Invoice Reports Tax detail 'Tax code - Tax Name' it is default functionality in Openerp 7.

In reports output shows from the account_invoice_tax table column name value default save with 'Tax code - Tax Name'

Default Code account/report/ account_print_invoice.rml

[[ repeatIn(o.tax_line,'t') ]]
[[ t.name ]]

Based on the requirement the rml file below changes working:

[[ repeatIn(o.tax_line,'t') ]]
[[ ', '.join([ lt.name or '' for lt in l.invoice_line_tax_id ]) ]]   # the same  code used  in invoice line tax name
Avatar
Descartar
Stephane Cyr
Autor

Thanks for this answer but It's not the proper way to print the tax name only on Customer Invoices. In some countries there are more than one applicable tax. For example, in Canada the federal tax (GST) is calculated first and then the provincial tax is added (PST for some provinces or QST for Quebec). With the proposed modification, the description of each tax is lost and instead it shows the Taxes information on each line (ie 'GST + QST for sales' is printed twice instead of having 'GST - GST for sales - 5% (QC)' on the 1st line and 'QST - QST for sales - 9.975%' on the second line.

Related Posts Respostes Vistes Activitat
Trying to resize signature on invoice
code invoice
Avatar
Avatar
1
de juny 24
2956
Create new invoice by code Solved
code invoice
Avatar
Avatar
1
de nov. 22
19439
How to automatically add a fixed amount to the invoice?
invoice tax
Avatar
Avatar
Avatar
Avatar
4
de març 15
12133
How can I edit Sales Tax so that it doesn't show the rate, just the word "Tax"? Solved
invoice tax quotation
Avatar
Avatar
1
d’oct. 25
3757
add Price with tax and odoo calculate the exact amount Solved
invoice tax qoutation
Avatar
Avatar
2
de jul. 24
3184