Merge lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes into lp:openobject-addons

Proposed by Lorenzo Battistini
Status: Merged
Merged at revision: 5779
Proposed branch: lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes
Merge into: lp:openobject-addons
Diff against target: 2541 lines (+365/-1973)
19 files modified
l10n_it/__init__.py (+5/-6)
l10n_it/__openerp__.py (+4/-5)
l10n_it/data/account.account.template.csv (+234/-233)
l10n_it/data/account.account.type.csv (+5/-5)
l10n_it/data/account.tax.code.template.csv (+14/-0)
l10n_it/data/account.tax.template.csv (+64/-40)
l10n_it/i18n/it.po (+28/-159)
l10n_it/i18n/l10n_it.pot (+11/-126)
l10n_it/libroIVA.py (+0/-54)
l10n_it/libroIVA_menu.xml (+0/-16)
l10n_it/libroIVA_view.xml (+0/-47)
l10n_it/report.xml (+0/-24)
l10n_it/report/__init__.py (+0/-2)
l10n_it/report/libroIVA_credito.py (+0/-79)
l10n_it/report/libroIVA_credito.rml (+0/-203)
l10n_it/report/libroIVA_debito.py (+0/-80)
l10n_it/report/libroIVA_debito.rml (+0/-195)
l10n_it/report/normalized_oo2rml.xsl (+0/-696)
l10n_it/security/ir.model.access.csv (+0/-3)
To merge this branch: bzr merge lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes
Reviewer Review Type Date Requested Status
Olivier Dony (Odoo) Needs Fixing
Lorenzo Battistini (community) Needs Resubmitting
OpenERP Core Team Pending
Review via email: mp+73349@code.launchpad.net

Description of the change

These changes fix several important problems related to Italian partially deductible VAT.

Main issues are described here http://wiki.openerp-italia.org/doku.php/moduli/l10n_it_iva_indetraibile

We removed the 'libro IVA' report because we implemented it in the 'l10n_it_vat_registries' module http://apps.openerp.com/addon/6074 and it depends on 'l10n_it_corrispettivi' http://apps.openerp.com/addon/6055

To post a comment you must log in.
Revision history for this message
Lorenzo Battistini (elbati) wrote :

Verify if it's possible to avoid 'Decimal'
Verify 'tax_amount' and 'base_amount' (for tax.code)

review: Needs Fixing
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

On 11/05/2011 02:38 PM, Lorenzo Battistini - Agile BG - Domsense wrote:
> Review: Needs Fixing
>
> Verify if it's possible to avoid 'Decimal'

I was about to write the same comment, well done! :-)
Normally my recent bug comments about Decimal vs Float should give you
some pointers, but do not hesitate to ask if you need more info.

Revision history for this message
Lorenzo Battistini (elbati) :
review: Needs Resubmitting
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Hi Lorenzo,

Thanks for updating the merge proposal!

Now all it does is remove the IVA reports and update the chart of accounts, which I can hardly review functionally ;-)
I will merge it after a final installation test.

Please note that you could later suggest the inclusion of your l10n_it_* modules into the official addons, if they are considered required in Italia. You can check our "Merge Proposal Acceptance Policy" [1] for our guidelines in this matter.
As was discussed recently for the Brazilian localization, you would just need to make sure the modules can pass the technical review, i.e. they need to be clean enough in terms of Python overrides (no impact on other l10n modules) and external dependencies. It seems relatively doable from what I can see, even if you have to start with a few merge proposals to make the OpenERP core extensible enough to fit your needs...

Thanks!

[1] http://bit.ly/openerp-contrib-mp

review: Approve
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Something still needs to be corrected, there's an inconsistency with the "2605 - erario c/IVA account", which is declared as "account_type_tax" and "payable", while account_type_tax has closing method "balance".
Any payable account should have closing method "unreconciled", so this is inconsistent.

Did you double check? Shouldn't 2605 have "other" as internal_type?

review: Needs Fixing
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

I've just merged it, and temporarily set the internal_type of "2605 - erario c/IVA account" to "other", to avoid breaking the trunk. I think that was the value in the previous version of l10n_it.

Let me know if this was not the correct fix, send me a patch or post a small merge prop to fix it, I will process it quickly.

Thanks!

Revision history for this message
Lorenzo Battistini (elbati) wrote :

Hello Olivier,
thanks for your review.

Actually we often need to associate the 2605 account to the tax authority partner. So, maybe better if we set it as 'account_type_payable' and 'payable'?

See new proposal: https://code.launchpad.net/~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes/+merge/83374 (sorry for quotes due to new version of libreoffice, I guess)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'l10n_it/__init__.py'
2--- l10n_it/__init__.py 2011-01-14 00:11:01 +0000
3+++ l10n_it/__init__.py 2011-11-23 14:06:29 +0000
4@@ -1,13 +1,15 @@
5-# -*- encoding: utf-8 -*-
6 ##############################################################################
7 #
8 # OpenERP, Open Source Management Solution
9 # Copyright (C) 2010
10-# Italian OpenERP Community (<http://www.openerp-italia.com>)
11+# OpenERP Italian Community (<http://www.openerp-italia.org>)
12 # Servabit srl
13 # Agile Business Group sagl
14 # Domsense srl
15-# Albatos srl
16+# Albatos srl
17+#
18+# Copyright (C) 2011
19+# Associazione OpenERP Italia (<http://www.openerp-italia.org>)
20 #
21 # This program is free software: you can redistribute it and/or modify
22 # it under the terms of the GNU Affero General Public License as
23@@ -23,6 +25,3 @@
24 # along with this program. If not, see <http://www.gnu.org/licenses/>.
25 #
26 ##############################################################################
27-
28-import libroIVA
29-import report
30
31=== modified file 'l10n_it/__openerp__.py'
32--- l10n_it/__openerp__.py 2011-10-11 20:05:49 +0000
33+++ l10n_it/__openerp__.py 2011-11-23 14:06:29 +0000
34@@ -3,12 +3,15 @@
35 #
36 # OpenERP, Open Source Management Solution
37 # Copyright (C) 2010
38-# Italian OpenERP Community (<http://www.openerp-italia.org>)
39+# OpenERP Italian Community (<http://www.openerp-italia.org>)
40 # Servabit srl
41 # Agile Business Group sagl
42 # Domsense srl
43 # Albatos srl
44 #
45+# Copyright (C) 2011
46+# Associazione OpenERP Italia (<http://www.openerp-italia.org>)
47+#
48 # This program is free software: you can redistribute it and/or modify
49 # it under the terms of the GNU Affero General Public License as
50 # published by the Free Software Foundation, either version 3 of the
51@@ -39,9 +42,6 @@
52 "category" : "Localization/Account Charts",
53 'website': 'http://www.openerp-italia.org/',
54 'init_xml': [
55- 'report.xml',
56- 'libroIVA_view.xml',
57- 'libroIVA_menu.xml',
58 ],
59 'update_xml': [
60 'data/account.account.type.csv',
61@@ -51,7 +51,6 @@
62 'data/account.tax.template.csv',
63 'data/account.fiscal.position.template.csv',
64 'l10n_chart_it_generic.xml',
65- 'security/ir.model.access.csv',
66 ],
67 'demo_xml': [
68 ],
69
70=== modified file 'l10n_it/data/account.account.template.csv'
71--- l10n_it/data/account.account.template.csv 2011-10-16 01:28:00 +0000
72+++ l10n_it/data/account.account.template.csv 2011-11-23 14:06:29 +0000
73@@ -1,234 +1,235 @@
74 "id","code","name","parent_id:id","user_type:id","type","reconcile"
75-0,0,"Azienda",,"account_type_view","view",FALSE
76-1,1,"ATTIVO ",0,"account_type_view","view",TRUE
77-11,11,"IMMOBILIZZAZIONI IMMATERIALI ",1,"account_type_view","view",TRUE
78-1101,1101,"costi di impianto ",11,"account_type_view","other",TRUE
79-1106,1106,"software ",11,"account_type_view","other",TRUE
80-1108,1108,"avviamento ",11,"account_type_view","other",TRUE
81-1111,1111,"fondo ammortamento costi di impianto ",11,"account_type_view","other",TRUE
82-1116,1116,"fondo ammortamento software ",11,"account_type_view","other",TRUE
83-1118,1118,"fondo ammortamento avviamento ",11,"account_type_view","other",TRUE
84-12,12,"IMMOBILIZZAZIONI MATERIALI ",1,"account_type_view","view",TRUE
85-1201,1201,"fabbricati ",12,"account_type_view","other",TRUE
86-1202,1202,"impianti e macchinari ",12,"account_type_view","other",TRUE
87-1204,1204,"attrezzature commerciali ",12,"account_type_view","other",TRUE
88-1205,1205,"macchine d'ufficio ",12,"account_type_view","other",TRUE
89-1206,1206,"arredamento ",12,"account_type_view","other",TRUE
90-1207,1207,"automezzi ",12,"account_type_view","other",TRUE
91-1208,1208,"imballaggi durevoli ",12,"account_type_view","other",TRUE
92-1211,1211,"fondo ammortamento fabbricati ",12,"account_type_view","other",TRUE
93-1212,1212,"fondo ammortamento impianti e macchinari ",12,"account_type_view","other",TRUE
94-1214,1214,"fondo ammortamento attrezzature commerciali ",12,"account_type_view","other",TRUE
95-1215,1215,"fondo ammortamento macchine d'ufficio ",12,"account_type_view","other",TRUE
96-1216,1216,"fondo ammortamento arredamento ",12,"account_type_view","other",TRUE
97-1217,1217,"fondo ammortamento automezzi ",12,"account_type_view","other",TRUE
98-1218,1218,"fondo ammortamento imballaggi durevoli ",12,"account_type_view","other",TRUE
99-1220,1220,"fornitori immobilizzazioni c/acconti ",12,"account_type_view","other",TRUE
100-13,13,"IMMOBILIZZAZIONI FINANZIARIE ",1,"account_type_view","view",TRUE
101-1301,1301,"mutui attivi ",13,"account_type_view","other",TRUE
102-14,14,"RIMANENZE ",1,"account_type_view","view",TRUE
103-1401,1401,"materie di consumo ",14,"account_type_view","other",TRUE
104-1404,1404,"merci ",14,"account_type_view","other",TRUE
105-1410,1410,"fornitori c/acconti ",14,"account_type_view","other",TRUE
106-15,15,"CREDITI COMMERCIALI ",1,"account_type_view","view",TRUE
107-1501,1501,"crediti v/clienti ",15,"account_type_receivable","receivable",TRUE
108-1502,1502,"crediti commerciali diversi ",15,"account_type_receivable","other",TRUE
109-1503,1503,"clienti c/spese anticipate ",15,"account_type_receivable","receivable",TRUE
110-1505,1505,"cambiali attive ",15,"account_type_receivable","other",TRUE
111-1506,1506,"cambiali allo sconto ",15,"account_type_receivable","other",TRUE
112-1507,1507,"cambiali all'incasso ",15,"account_type_receivable","other",TRUE
113-1509,1509,"fatture da emettere ",15,"account_type_receivable","other",TRUE
114-1510,1510,"crediti insoluti ",15,"account_type_receivable","other",TRUE
115-1511,1511,"cambiali insolute ",15,"account_type_receivable","other",TRUE
116-1531,1531,"crediti da liquidare ",15,"account_type_receivable","other",TRUE
117-1540,1540,"fondo svalutazione crediti ",15,"account_type_receivable","other",TRUE
118-1541,1541,"fondo rischi su crediti ",15,"account_type_receivable","other",TRUE
119-16,16,"CREDITI DIVERSI ",1,"account_type_view","view",TRUE
120-1601,1601,"IVA n/credito ",16,"account_type_receivable","other",TRUE
121-1602,1602,"IVA c/acconto ",16,"account_type_receivable","other",TRUE
122-1605,1605,"crediti per IVA ",16,"account_type_receivable","other",TRUE
123-1607,1607,"imposte c/acconto ",16,"account_type_receivable","other",TRUE
124-1608,1608,"crediti per imposte ",16,"account_type_receivable","other",TRUE
125-1609,1609,"crediti per ritenute subite ",16,"account_type_receivable","other",TRUE
126-1610,1610,"crediti per cauzioni ",16,"account_type_receivable","other",TRUE
127-1620,1620,"personale c/acconti ",16,"account_type_receivable","other",TRUE
128-1630,1630,"crediti v/istituti previdenziali ",16,"account_type_receivable","other",TRUE
129-1640,1640,"debitori diversi ",16,"account_type_receivable","receivable",TRUE
130-18,18,"DISPONIBILITÀ LIQUIDE ",1,"account_type_view","view",TRUE
131-1801,1801,"banche c/c ",18,"account_type_bank","liquidity",TRUE
132-1810,1810,"c/c postali ",18,"account_type_cash","liquidity",TRUE
133-1820,1820,"denaro in cassa ",18,"account_type_cash","liquidity",TRUE
134-1821,1821,"assegni ",18,"account_type_cash","liquidity",TRUE
135-1822,1822,"valori bollati ",18,"account_type_cash","liquidity",TRUE
136-19,19,"RATEI E RISCONTI ATTIVI ",1,"account_type_view","view",TRUE
137-1901,1901,"ratei attivi ",19,"account_type_view","other",TRUE
138-1902,1902,"risconti attivi ",19,"account_type_view","other",TRUE
139-2,2,"PASSIVO ",0,"account_type_view","view",TRUE
140-20,20,"PATRIMONIO NETTO ",2,"account_type_view","view",TRUE
141-2101,2101,"patrimonio netto ",20,"account_type_view","other",TRUE
142-2102,2102,"utile d'esercizio ",20,"account_type_receivable","receivable",TRUE
143-2103,2103,"perdita d'esercizio ",20,"account_type_payable","payable",TRUE
144-2104,2104,"prelevamenti extra gestione ",20,"account_type_view","other",TRUE
145-2105,2105,"titolare c/ritenute subite ",20,"account_type_view","other",TRUE
146-22,22,"FONDI PER RISCHI E ONERI ",2,"account_type_view","view",TRUE
147-2201,2201,"fondo per imposte ",22,"account_type_view","other",TRUE
148-2204,2204,"fondo responsabilità civile ",22,"account_type_view","other",TRUE
149-2205,2205,"fondo spese future ",22,"account_type_view","other",TRUE
150-2211,2211,"fondo manutenzioni programmate ",22,"account_type_view","other",TRUE
151-23,23,"TRATTAMENTO FINE RAPPORTO DI LAVORO ",2,"account_type_view","view",TRUE
152-2301,2301,"debiti per TFRL ",23,"account_type_view","other",TRUE
153-24,24,"DEBITI FINANZIARI ",2,"account_type_view","view",TRUE
154-2410,2410,"mutui passivi ",24,"account_type_payable","other",TRUE
155-2411,2411,"banche c/sovvenzioni ",24,"account_type_payable","other",TRUE
156-2420,2420,"banche c/c passivi ",24,"account_type_payable","other",TRUE
157-2421,2421,"banche c/RIBA all'incasso ",24,"account_type_payable","other",TRUE
158-2422,2422,"banche c/cambiali all'incasso ",24,"account_type_payable","other",TRUE
159-2423,2423,"banche c/anticipi su fatture ",24,"account_type_payable","other",TRUE
160-2440,2440,"debiti v/altri finanziatori ",24,"account_type_payable","other",TRUE
161-25,25,"DEBITI COMMERCIALI ",2,"account_type_view","view",TRUE
162-2501,2501,"debiti v/fornitori ",25,"account_type_payable","payable",TRUE
163-2503,2503,"cambiali passive ",25,"account_type_payable","other",TRUE
164-2520,2520,"fatture da ricevere ",25,"account_type_payable","other",TRUE
165-2521,2521,"debiti da liquidare ",25,"account_type_payable","other",TRUE
166-2530,2530,"clienti c/acconti ",25,"account_type_payable","payable",TRUE
167-26,26,"DEBITI DIVERSI ",2,"account_type_view","view",TRUE
168-2601,2601,"IVA n/debito ",26,"account_type_payable","other",TRUE
169-2602,2602,"debiti per ritenute da versare ",26,"account_type_payable","other",TRUE
170-2605,2605,"erario c/IVA ",26,"account_type_payable","other",TRUE
171-2606,2606,"debiti per imposte ",26,"account_type_payable","other",TRUE
172-2619,2619,"debiti per cauzioni ",26,"account_type_payable","other",TRUE
173-2620,2620,"personale c/retribuzioni ",26,"account_type_payable","other",TRUE
174-2621,2621,"personale c/liquidazioni ",26,"account_type_payable","other",TRUE
175-2622,2622,"clienti c/cessione ",26,"account_type_payable","other",TRUE
176-2630,2630,"debiti v/istituti previdenziali ",26,"account_type_payable","other",TRUE
177-2640,2640,"creditori diversi ",26,"account_type_payable","payable",TRUE
178-27,27,"RATEI E RISCONTI PASSIVI ",2,"account_type_view","view",TRUE
179-2701,2701,"ratei passivi ",27,"account_type_view","other",TRUE
180-2702,2702,"risconti passivi ",27,"account_type_view","other",TRUE
181-28,28,"CONTI TRANSITORI E DIVERSI ",2,"account_type_view","view",TRUE
182-2801,2801,"bilancio di apertura ",28,"account_type_view","other",TRUE
183-2802,2802,"bilancio di chiusura ",28,"account_type_view","other",TRUE
184-2810,2810,"IVA c/liquidazioni ",28,"account_type_view","other",TRUE
185-2811,2811,"istituti previdenziali ",28,"account_type_view","other",TRUE
186-2820,2820,"banca ... c/c ",28,"account_type_view","other",TRUE
187-2821,2821,"banca ... c/c ",28,"account_type_view","other",TRUE
188-2822,2822,"banca ... c/c ",28,"account_type_view","other",TRUE
189-29,29,"CONTI DEI SISTEMI SUPPLEMENTARI ",2,"account_type_view","view",TRUE
190-2901,2901,"beni di terzi ",29,"account_type_view","other",TRUE
191-2902,2902,"depositanti beni ",29,"account_type_view","other",TRUE
192-2911,2911,"merci da ricevere ",29,"account_type_view","other",TRUE
193-2912,2912,"fornitori c/impegni ",29,"account_type_view","other",TRUE
194-2913,2913,"impegni per beni in leasing ",29,"account_type_view","other",TRUE
195-2914,2914,"creditori c/leasing ",29,"account_type_view","other",TRUE
196-2916,2916,"clienti c/impegni ",29,"account_type_view","other",TRUE
197-2917,2917,"merci da consegnare ",29,"account_type_view","other",TRUE
198-2921,2921,"rischi per effetti scontati ",29,"account_type_view","other",TRUE
199-2922,2922,"banche c/effetti scontati ",29,"account_type_view","other",TRUE
200-2926,2926,"rischi per fideiussioni ",29,"account_type_view","other",TRUE
201-2927,2927,"creditori per fideiussioni ",29,"account_type_view","other",TRUE
202-2931,2931,"rischi per avalli ",29,"account_type_view","other",TRUE
203-2932,2932,"creditori per avalli ",29,"account_type_view","other",TRUE
204-3,3,"VALORE DELLA PRODUZIONE ",0,"account_type_view","view",TRUE
205-31,31,"VENDITE E PRESTAZIONI ",3,"account_type_view","view",TRUE
206-3101,3101,"merci c/vendite ",31,"account_type_income","other",TRUE
207-3103,3103,"rimborsi spese di vendita ",31,"account_type_income","other",TRUE
208-3110,3110,"resi su vendite ",31,"account_type_income","other",TRUE
209-3111,3111,"ribassi e abbuoni passivi ",31,"account_type_income","other",TRUE
210-3112,3112,"premi su vendite ",31,"account_type_income","other",TRUE
211-32,32,"RICAVI E PROVENTI DIVERSI ",3,"account_type_view","view",TRUE
212-3201,3201,"fitti attivi ",32,"account_type_income","other",TRUE
213-3202,3202,"proventi vari ",32,"account_type_income","other",TRUE
214-3210,3210,"arrotondamenti attivi ",32,"account_type_income","other",TRUE
215-3220,3220,"plusvalenze ordinarie diverse ",32,"account_type_income","other",TRUE
216-3230,3230,"sopravvenienze attive ordinarie diverse ",32,"account_type_income","other",TRUE
217-3240,3240,"insussistenze attive ordinarie diverse ",32,"account_type_income","other",TRUE
218-4,4,"COSTI DELLA PRODUZIONE ",0,"account_type_view","view",TRUE
219-41,41,"COSTO DEL VENDUTO ",4,"account_type_view","view",TRUE
220-4101,4101,"merci c/acquisti ",41,"account_type_expense","other",TRUE
221-4102,4102,"materie di consumo c/acquisti ",41,"account_type_expense","other",TRUE
222-4105,4105,"merci c/apporti ",41,"account_type_expense","other",TRUE
223-4110,4110,"resi su acquisti ",41,"account_type_expense","other",TRUE
224-4111,4111,"ribassi e abbuoni attivi ",41,"account_type_expense","other",TRUE
225-4112,4112,"premi su acquisti ",41,"account_type_expense","other",TRUE
226-4121,4121,"merci c/esistenze iniziali ",41,"account_type_expense","other",TRUE
227-4122,4122,"materie di consumo c/esistenze iniziali ",41,"account_type_expense","other",TRUE
228-4131,4131,"merci c/rimanenze finali ",41,"account_type_expense","other",TRUE
229-4132,4132,"materie di consumo c/rimanenze finali ",41,"account_type_expense","other",TRUE
230-42,42,"COSTI PER SERVIZI ",4,"account_type_view","view",TRUE
231-4201,4201,"costi di trasporto ",42,"account_type_expense","other",TRUE
232-4202,4202,"costi per energia ",42,"account_type_expense","other",TRUE
233-4203,4203,"costi di pubblicità ",42,"account_type_expense","other",TRUE
234-4204,4204,"costi di consulenze ",42,"account_type_expense","other",TRUE
235-4205,4205,"costi postali ",42,"account_type_expense","other",TRUE
236-4206,4206,"costi telefonici ",42,"account_type_expense","other",TRUE
237-4207,4207,"costi di assicurazione ",42,"account_type_expense","other",TRUE
238-4208,4208,"costi di vigilanza ",42,"account_type_expense","other",TRUE
239-4209,4209,"costi per i locali ",42,"account_type_expense","other",TRUE
240-4210,4210,"costi di esercizio automezzi ",42,"account_type_expense","other",TRUE
241-4211,4211,"costi di manutenzione e riparazione ",42,"account_type_expense","other",TRUE
242-4212,4212,"provvigioni passive ",42,"account_type_expense","other",TRUE
243-4213,4213,"spese di incasso ",42,"account_type_expense","other",TRUE
244-43,43,"COSTI PER GODIMENTO BENI DI TERZI ",4,"account_type_view","view",TRUE
245-4301,4301,"fitti passivi ",43,"account_type_expense","other",TRUE
246-4302,4302,"canoni di leasing ",43,"account_type_expense","other",TRUE
247-44,44,"COSTI PER IL PERSONALE ",4,"account_type_view","view",TRUE
248-4401,4401,"salari e stipendi ",44,"account_type_expense","other",TRUE
249-4402,4402,"oneri sociali ",44,"account_type_expense","other",TRUE
250-4403,4403,"TFRL ",44,"account_type_expense","other",TRUE
251-4404,4404,"altri costi per il personale ",44,"account_type_expense","other",TRUE
252-45,45,"AMMORTAMENTI IMMOBILIZZAZIONI IMMATERIALI ",4,"account_type_view","view",TRUE
253-4501,4501,"ammortamento costi di impianto ",45,"account_type_view","other",TRUE
254-4506,4506,"ammortamento software ",45,"account_type_view","other",TRUE
255-4508,4508,"ammortamento avviamento ",45,"account_type_view","other",TRUE
256-46,46,"AMMORTAMENTI IMMOBILIZZAZIONI MATERIALI ",4,"account_type_view","view",TRUE
257-4601,4601,"ammortamento fabbricati ",46,"account_type_view","other",TRUE
258-4602,4602,"ammortamento impianti e macchinari ",46,"account_type_view","other",TRUE
259-4604,4604,"ammortamento attrezzature commerciali ",46,"account_type_view","other",TRUE
260-4605,4605,"ammortamento macchine d'ufficio ",46,"account_type_view","other",TRUE
261-4606,4606,"ammortamento arredamento ",46,"account_type_view","other",TRUE
262-4607,4607,"ammortamento automezzi ",46,"account_type_view","other",TRUE
263-4608,4608,"ammortamento imballaggi durevoli ",46,"account_type_view","other",TRUE
264-47,47,"SVALUTAZIONI ",4,"account_type_view","view",TRUE
265-4701,4701,"svalutazioni immobilizzazioni immateriali ",47,"account_type_view","other",TRUE
266-4702,4702,"svalutazioni immobilizzazioni materiali ",47,"account_type_view","other",TRUE
267-4706,4706,"svalutazione crediti ",47,"account_type_view","other",TRUE
268-48,48,"ACCANTONAMENTI ",4,"account_type_view","view",TRUE
269-481,481,"ACCANTONAMENTI PER RISCHI ",48,"account_type_view","view",TRUE
270-4814,4814,"accantonamento per responsabilità civile ",481,"account_type_view","other",TRUE
271-482,482,"ALTRI ACCANTONAMENTI ",48,"account_type_view","view",TRUE
272-4821,4821,"accantonamento per spese future ",482,"account_type_view","other",TRUE
273-4823,4823,"accantonamento per manutenzioni programmate ",482,"account_type_view","other",TRUE
274-49,49,"ONERI DIVERSI ",4,"account_type_view","view",TRUE
275-4901,4901,"oneri fiscali diversi ",49,"account_type_view","other",TRUE
276-4903,4903,"oneri vari ",49,"account_type_view","other",TRUE
277-4905,4905,"perdite su crediti ",49,"account_type_view","other",TRUE
278-4910,4910,"arrotondamenti passivi ",49,"account_type_view","other",TRUE
279-4920,4920,"minusvalenze ordinarie diverse ",49,"account_type_view","other",TRUE
280-4930,4930,"sopravvenienze passive ordinarie diverse ",49,"account_type_view","other",TRUE
281-4940,4940,"insussistenze passive ordinarie diverse ",49,"account_type_view","other",TRUE
282-5,5,"PROVENTI E ONERI FINANZIARI ",0,"account_type_view","view",TRUE
283-51,51,"PROVENTI FINANZIARI ",5,"account_type_view","view",TRUE
284-5110,5110,"interessi attivi v/clienti ",51,"account_type_view","other",TRUE
285-5115,5115,"interessi attivi bancari ",51,"account_type_view","other",TRUE
286-5116,5116,"interessi attivi postali ",51,"account_type_view","other",TRUE
287-5140,5140,"proventi finanziari diversi ",51,"account_type_view","other",TRUE
288-52,52,"ONERI FINANZIARI ",5,"account_type_view","view",TRUE
289-5201,5201,"interessi passivi v/fornitori ",52,"account_type_view","other",TRUE
290-5202,5202,"interessi passivi bancari ",52,"account_type_view","other",TRUE
291-5203,5203,"sconti passivi bancari ",52,"account_type_view","other",TRUE
292-5210,5210,"interessi passivi su mutui ",52,"account_type_view","other",TRUE
293-5240,5240,"oneri finanziari diversi ",52,"account_type_view","other",TRUE
294-7,7,"PROVENTI E ONERI STRAORDINARI ",0,"account_type_view","view",TRUE
295-71,71,"PROVENTI STRAORDINARI ",7,"account_type_view","view",TRUE
296-7101,7101,"plusvalenze straordinarie ",71,"account_type_view","other",TRUE
297-7102,7102,"sopravvenienze attive straordinarie ",71,"account_type_view","other",TRUE
298-7103,7103,"insussistenze attive straordinarie ",71,"account_type_view","other",TRUE
299-72,72,"ONERI STRAORDINARI ",7,"account_type_view","view",TRUE
300-7201,7201,"minusvalenze straordinarie ",72,"account_type_view","other",TRUE
301-7202,7202,"sopravvenienze passive straordinarie ",72,"account_type_view","other",TRUE
302-7203,7203,"insussistenze passive straordinarie ",72,"account_type_view","other",TRUE
303-7204,7204,"imposte esercizi precedenti ",72,"account_type_view","other",TRUE
304-81,81,"IMPOSTE DELL'ESERCIZIO ",7,"account_type_view","view",TRUE
305-8101,8101,"imposte dell'esercizio ",81,"account_type_view","other",TRUE
306-91,91,"CONTI DI RISULTATO ",7,"account_type_view","view",TRUE
307-9101,9101,"conto di risultato economico ",91,"account_type_view","other",TRUE
308+"0","0","Azienda",,"account_type_view","view","FALSE"
309+"1","1","ATTIVO ","0","account_type_view","view","TRUE"
310+"11","11","IMMOBILIZZAZIONI IMMATERIALI ","1","account_type_view","view","TRUE"
311+"1101","1101","costi di impianto ","11","account_type_asset","other","TRUE"
312+"1106","1106","software ","11","account_type_asset","other","TRUE"
313+"1108","1108","avviamento ","11","account_type_asset","other","TRUE"
314+"1111","1111","fondo ammortamento costi di impianto ","11","account_type_asset","other","TRUE"
315+"1116","1116","fondo ammortamento software ","11","account_type_asset","other","TRUE"
316+"1118","1118","fondo ammortamento avviamento ","11","account_type_asset","other","TRUE"
317+"12","12","IMMOBILIZZAZIONI MATERIALI ","1","account_type_view","view","TRUE"
318+"1201","1201","fabbricati ","12","account_type_asset","other","TRUE"
319+"1202","1202","impianti e macchinari ","12","account_type_asset","other","TRUE"
320+"1204","1204","attrezzature commerciali ","12","account_type_asset","other","TRUE"
321+"1205","1205","macchine d'ufficio ","12","account_type_asset","other","TRUE"
322+"1206","1206","arredamento ","12","account_type_asset","other","TRUE"
323+"1207","1207","automezzi ","12","account_type_asset","other","TRUE"
324+"1208","1208","imballaggi durevoli ","12","account_type_asset","other","TRUE"
325+"1211","1211","fondo ammortamento fabbricati ","12","account_type_asset","other","TRUE"
326+"1212","1212","fondo ammortamento impianti e macchinari ","12","account_type_asset","other","TRUE"
327+"1214","1214","fondo ammortamento attrezzature commerciali ","12","account_type_asset","other","TRUE"
328+"1215","1215","fondo ammortamento macchine d'ufficio ","12","account_type_asset","other","TRUE"
329+"1216","1216","fondo ammortamento arredamento ","12","account_type_asset","other","TRUE"
330+"1217","1217","fondo ammortamento automezzi ","12","account_type_asset","other","TRUE"
331+"1218","1218","fondo ammortamento imballaggi durevoli ","12","account_type_asset","other","TRUE"
332+"1220","1220","fornitori immobilizzazioni c/acconti ","12","account_type_asset","other","TRUE"
333+"13","13","IMMOBILIZZAZIONI FINANZIARIE ","1","account_type_view","view","TRUE"
334+"1301","1301","mutui attivi ","13","account_type_asset","other","TRUE"
335+"14","14","RIMANENZE ","1","account_type_view","view","TRUE"
336+"1401","1401","materie di consumo ","14","account_type_asset","other","TRUE"
337+"1404","1404","merci ","14","account_type_asset","other","TRUE"
338+"1410","1410","fornitori c/acconti ","14","account_type_asset","other","TRUE"
339+"15","15","CREDITI COMMERCIALI ","1","account_type_view","view","TRUE"
340+"1501","1501","crediti v/clienti ","15","account_type_receivable","receivable","TRUE"
341+"1502","1502","crediti commerciali diversi ","15","account_type_receivable","other","TRUE"
342+"1503","1503","clienti c/spese anticipate ","15","account_type_receivable","receivable","TRUE"
343+"1505","1505","cambiali attive ","15","account_type_receivable","other","TRUE"
344+"1506","1506","cambiali allo sconto ","15","account_type_receivable","other","TRUE"
345+"1507","1507","cambiali all'incasso ","15","account_type_receivable","other","TRUE"
346+"1509","1509","fatture da emettere ","15","account_type_receivable","other","TRUE"
347+"1510","1510","crediti insoluti ","15","account_type_receivable","other","TRUE"
348+"1511","1511","cambiali insolute ","15","account_type_receivable","other","TRUE"
349+"1531","1531","crediti da liquidare ","15","account_type_receivable","other","TRUE"
350+"1540","1540","fondo svalutazione crediti ","15","account_type_receivable","other","TRUE"
351+"1541","1541","fondo rischi su crediti ","15","account_type_receivable","other","TRUE"
352+"16","16","CREDITI DIVERSI ","1","account_type_view","view","TRUE"
353+"1601","1601","IVA n/credito ","16","account_type_tax","other","TRUE"
354+"1602","1602","IVA c/acconto ","16","account_type_tax","other","TRUE"
355+"1605","1605","crediti per IVA ","16","account_type_tax","other","TRUE"
356+"1607","1607","imposte c/acconto ","16","account_type_tax","other","TRUE"
357+"1608","1608","crediti per imposte ","16","account_type_tax","other","TRUE"
358+"1609","1609","crediti per ritenute subite ","16","account_type_asset","other","TRUE"
359+"1610","1610","crediti per cauzioni ","16","account_type_asset","other","TRUE"
360+"1620","1620","personale c/acconti ","16","account_type_asset","other","TRUE"
361+"1630","1630","crediti v/istituti previdenziali ","16","account_type_asset","other","TRUE"
362+"1640","1640","debitori diversi ","16","account_type_receivable","receivable","TRUE"
363+"18","18","DISPONIBILITÀ LIQUIDE ","1","account_type_view","view","TRUE"
364+"1801","1801","banche c/c ","18","account_type_bank","liquidity","TRUE"
365+"1810","1810","c/c postali ","18","account_type_cash","liquidity","TRUE"
366+"1820","1820","denaro in cassa ","18","account_type_cash","liquidity","TRUE"
367+"1821","1821","assegni ","18","account_type_cash","liquidity","TRUE"
368+"1822","1822","valori bollati ","18","account_type_cash","liquidity","TRUE"
369+"19","19","RATEI E RISCONTI ATTIVI ","1","account_type_view","view","TRUE"
370+"1901","1901","ratei attivi ","19","account_type_asset","other","TRUE"
371+"1902","1902","risconti attivi ","19","account_type_asset","other","TRUE"
372+"2","2","PASSIVO ","0","account_type_view","view","TRUE"
373+"20","20","PATRIMONIO NETTO ","2","account_type_view","view","TRUE"
374+"2101","2101","patrimonio netto ","20","account_type_asset","other","TRUE"
375+"2102","2102","utile d'esercizio ","20","account_type_asset","other","TRUE"
376+"2103","2103","perdita d'esercizio ","20","account_type_asset","other","TRUE"
377+"2104","2104","prelevamenti extra gestione ","20","account_type_asset","other","TRUE"
378+"2105","2105","titolare c/ritenute subite ","20","account_type_asset","other","TRUE"
379+"22","22","FONDI PER RISCHI E ONERI ","2","account_type_view","view","TRUE"
380+"2201","2201","fondo per imposte ","22","account_type_asset","other","TRUE"
381+"2204","2204","fondo responsabilità civile ","22","account_type_asset","other","TRUE"
382+"2205","2205","fondo spese future ","22","account_type_asset","other","TRUE"
383+"2211","2211","fondo manutenzioni programmate ","22","account_type_asset","other","TRUE"
384+"23","23","TRATTAMENTO FINE RAPPORTO DI LAVORO ","2","account_type_view","view","TRUE"
385+"2301","2301","debiti per TFRL ","23","account_type_asset","other","TRUE"
386+"24","24","DEBITI FINANZIARI ","2","account_type_view","view","TRUE"
387+"2410","2410","mutui passivi ","24","account_type_asset","other","TRUE"
388+"2411","2411","banche c/sovvenzioni ","24","account_type_asset","other","TRUE"
389+"2420","2420","banche c/c passivi ","24","account_type_asset","other","TRUE"
390+"2421","2421","banche c/RIBA all'incasso ","24","account_type_asset","other","TRUE"
391+"2422","2422","banche c/cambiali all'incasso ","24","account_type_asset","other","TRUE"
392+"2423","2423","banche c/anticipi su fatture ","24","account_type_asset","other","TRUE"
393+"2440","2440","debiti v/altri finanziatori ","24","account_type_asset","other","TRUE"
394+"25","25","DEBITI COMMERCIALI ","2","account_type_view","view","TRUE"
395+"2501","2501","debiti v/fornitori ","25","account_type_payable","payable","TRUE"
396+"2503","2503","cambiali passive ","25","account_type_asset","other","TRUE"
397+"2520","2520","fatture da ricevere ","25","account_type_asset","other","TRUE"
398+"2521","2521","debiti da liquidare ","25","account_type_asset","other","TRUE"
399+"2530","2530","clienti c/acconti ","25","account_type_payable","payable","TRUE"
400+"26","26","DEBITI DIVERSI ","2","account_type_view","view","TRUE"
401+"2601","2601","IVA n/debito ","26","account_type_tax","other","TRUE"
402+"2602","2602","debiti per ritenute da versare ","26","account_type_tax","other","TRUE"
403+"2605","2605","erario c/IVA ","26","account_type_tax","payable","TRUE"
404+"2606","2606","debiti per imposte ","26","account_type_tax","other","TRUE"
405+"2619","2619","debiti per cauzioni ","26","account_type_asset","other","TRUE"
406+"2620","2620","personale c/retribuzioni ","26","account_type_asset","other","TRUE"
407+"2621","2621","personale c/liquidazioni ","26","account_type_asset","other","TRUE"
408+"2622","2622","clienti c/cessione ","26","account_type_asset","other","TRUE"
409+"2630","2630","debiti v/istituti previdenziali ","26","account_type_asset","other","TRUE"
410+"2640","2640","creditori diversi ","26","account_type_payable","payable","TRUE"
411+"27","27","RATEI E RISCONTI PASSIVI ","2","account_type_view","view","TRUE"
412+"2701","2701","ratei passivi ","27","account_type_asset","other","TRUE"
413+"2702","2702","risconti passivi ","27","account_type_asset","other","TRUE"
414+"28","28","CONTI TRANSITORI E DIVERSI ","2","account_type_view","view","TRUE"
415+"2801","2801","bilancio di apertura ","28","account_type_asset","other","TRUE"
416+"2802","2802","bilancio di chiusura ","28","account_type_asset","other","TRUE"
417+"2810","2810","IVA c/liquidazioni ","28","account_type_asset","other","TRUE"
418+"2811","2811","istituti previdenziali ","28","account_type_asset","other","TRUE"
419+"2820","2820","banca ... c/c ","28","account_type_asset","other","TRUE"
420+"2821","2821","banca ... c/c ","28","account_type_asset","other","TRUE"
421+"2822","2822","banca ... c/c ","28","account_type_asset","other","TRUE"
422+"29","29","CONTI DEI SISTEMI SUPPLEMENTARI ","2","account_type_view","view","TRUE"
423+"2901","2901","beni di terzi ","29","account_type_asset","other","TRUE"
424+"2902","2902","depositanti beni ","29","account_type_asset","other","TRUE"
425+"2911","2911","merci da ricevere ","29","account_type_asset","other","TRUE"
426+"2912","2912","fornitori c/impegni ","29","account_type_asset","other","TRUE"
427+"2913","2913","impegni per beni in leasing ","29","account_type_asset","other","TRUE"
428+"2914","2914","creditori c/leasing ","29","account_type_asset","other","TRUE"
429+"2916","2916","clienti c/impegni ","29","account_type_asset","other","TRUE"
430+"2917","2917","merci da consegnare ","29","account_type_asset","other","TRUE"
431+"2921","2921","rischi per effetti scontati ","29","account_type_asset","other","TRUE"
432+"2922","2922","banche c/effetti scontati ","29","account_type_asset","other","TRUE"
433+"2926","2926","rischi per fideiussioni ","29","account_type_asset","other","TRUE"
434+"2927","2927","creditori per fideiussioni ","29","account_type_asset","other","TRUE"
435+"2931","2931","rischi per avalli ","29","account_type_asset","other","TRUE"
436+"2932","2932","creditori per avalli ","29","account_type_asset","other","TRUE"
437+"3","3","VALORE DELLA PRODUZIONE ","0","account_type_view","view","TRUE"
438+"31","31","VENDITE E PRESTAZIONI ","3","account_type_view","view","TRUE"
439+"3101","3101","merci c/vendite ","31","account_type_income","other","TRUE"
440+"3103","3103","rimborsi spese di vendita ","31","account_type_income","other","TRUE"
441+"3110","3110","resi su vendite ","31","account_type_income","other","TRUE"
442+"3111","3111","ribassi e abbuoni passivi ","31","account_type_income","other","TRUE"
443+"3112","3112","premi su vendite ","31","account_type_income","other","TRUE"
444+"32","32","RICAVI E PROVENTI DIVERSI ","3","account_type_view","view","TRUE"
445+"3201","3201","fitti attivi ","32","account_type_income","other","TRUE"
446+"3202","3202","proventi vari ","32","account_type_income","other","TRUE"
447+"3210","3210","arrotondamenti attivi ","32","account_type_income","other","TRUE"
448+"3220","3220","plusvalenze ordinarie diverse ","32","account_type_income","other","TRUE"
449+"3230","3230","sopravvenienze attive ordinarie diverse ","32","account_type_income","other","TRUE"
450+"3240","3240","insussistenze attive ordinarie diverse ","32","account_type_income","other","TRUE"
451+"4","4","COSTI DELLA PRODUZIONE ","0","account_type_view","view","TRUE"
452+"41","41","COSTO DEL VENDUTO ","4","account_type_view","view","TRUE"
453+"4101","4101","merci c/acquisti ","41","account_type_expense","other","TRUE"
454+"4102","4102","materie di consumo c/acquisti ","41","account_type_expense","other","TRUE"
455+"4105","4105","merci c/apporti ","41","account_type_expense","other","TRUE"
456+"4110","4110","resi su acquisti ","41","account_type_expense","other","TRUE"
457+"4111","4111","ribassi e abbuoni attivi ","41","account_type_expense","other","TRUE"
458+"4112","4112","premi su acquisti ","41","account_type_expense","other","TRUE"
459+"4121","4121","merci c/esistenze iniziali ","41","account_type_expense","other","TRUE"
460+"4122","4122","materie di consumo c/esistenze iniziali ","41","account_type_expense","other","TRUE"
461+"4131","4131","merci c/rimanenze finali ","41","account_type_expense","other","TRUE"
462+"4132","4132","materie di consumo c/rimanenze finali ","41","account_type_expense","other","TRUE"
463+"42","42","COSTI PER SERVIZI ","4","account_type_view","view","TRUE"
464+"4201","4201","costi di trasporto ","42","account_type_expense","other","TRUE"
465+"4202","4202","costi per energia ","42","account_type_expense","other","TRUE"
466+"4203","4203","costi di pubblicità ","42","account_type_expense","other","TRUE"
467+"4204","4204","costi di consulenze ","42","account_type_expense","other","TRUE"
468+"4205","4205","costi postali ","42","account_type_expense","other","TRUE"
469+"4206","4206","costi telefonici ","42","account_type_expense","other","TRUE"
470+"4207","4207","costi di assicurazione ","42","account_type_expense","other","TRUE"
471+"4208","4208","costi di vigilanza ","42","account_type_expense","other","TRUE"
472+"4209","4209","costi per i locali ","42","account_type_expense","other","TRUE"
473+"4210","4210","costi di esercizio automezzi ","42","account_type_expense","other","TRUE"
474+"4211","4211","costi di manutenzione e riparazione ","42","account_type_expense","other","TRUE"
475+"4212","4212","provvigioni passive ","42","account_type_expense","other","TRUE"
476+"4213","4213","spese di incasso ","42","account_type_expense","other","TRUE"
477+"43","43","COSTI PER GODIMENTO BENI DI TERZI ","4","account_type_view","view","TRUE"
478+"4301","4301","fitti passivi ","43","account_type_expense","other","TRUE"
479+"4302","4302","canoni di leasing ","43","account_type_expense","other","TRUE"
480+"44","44","COSTI PER IL PERSONALE ","4","account_type_view","view","TRUE"
481+"4401","4401","salari e stipendi ","44","account_type_expense","other","TRUE"
482+"4402","4402","oneri sociali ","44","account_type_expense","other","TRUE"
483+"4403","4403","TFRL ","44","account_type_expense","other","TRUE"
484+"4404","4404","altri costi per il personale ","44","account_type_expense","other","TRUE"
485+"45","45","AMMORTAMENTI IMMOBILIZZAZIONI IMMATERIALI ","4","account_type_view","view","TRUE"
486+"4501","4501","ammortamento costi di impianto ","45","account_type_p_l","other","TRUE"
487+"4506","4506","ammortamento software ","45","account_type_p_l","other","TRUE"
488+"4508","4508","ammortamento avviamento ","45","account_type_p_l","other","TRUE"
489+"46","46","AMMORTAMENTI IMMOBILIZZAZIONI MATERIALI ","4","account_type_view","view","TRUE"
490+"4601","4601","ammortamento fabbricati ","46","account_type_p_l","other","TRUE"
491+"4602","4602","ammortamento impianti e macchinari ","46","account_type_p_l","other","TRUE"
492+"4604","4604","ammortamento attrezzature commerciali ","46","account_type_p_l","other","TRUE"
493+"4605","4605","ammortamento macchine d'ufficio ","46","account_type_p_l","other","TRUE"
494+"4606","4606","ammortamento arredamento ","46","account_type_p_l","other","TRUE"
495+"4607","4607","ammortamento automezzi ","46","account_type_p_l","other","TRUE"
496+"4608","4608","ammortamento imballaggi durevoli ","46","account_type_p_l","other","TRUE"
497+"47","47","SVALUTAZIONI ","4","account_type_view","view","TRUE"
498+"4701","4701","svalutazioni immobilizzazioni immateriali ","47","account_type_p_l","other","TRUE"
499+"4702","4702","svalutazioni immobilizzazioni materiali ","47","account_type_p_l","other","TRUE"
500+"4706","4706","svalutazione crediti ","47","account_type_p_l","other","TRUE"
501+"48","48","ACCANTONAMENTI ","4","account_type_view","view","TRUE"
502+"481","481","ACCANTONAMENTI PER RISCHI ","48","account_type_view","view","TRUE"
503+"4814","4814","accantonamento per responsabilità civile ","481","account_type_p_l","other","TRUE"
504+"482","482","ALTRI ACCANTONAMENTI ","48","account_type_view","view","TRUE"
505+"4821","4821","accantonamento per spese future ","482","account_type_p_l","other","TRUE"
506+"4823","4823","accantonamento per manutenzioni programmate ","482","account_type_p_l","other","TRUE"
507+"49","49","ONERI DIVERSI ","4","account_type_view","view","TRUE"
508+"4901","4901","oneri fiscali diversi ","49","account_type_p_l","other","TRUE"
509+"4903","4903","oneri vari ","49","account_type_p_l","other","TRUE"
510+"4905","4905","perdite su crediti ","49","account_type_p_l","other","TRUE"
511+"4910","4910","arrotondamenti passivi ","49","account_type_p_l","other","TRUE"
512+"4920","4920","minusvalenze ordinarie diverse ","49","account_type_p_l","other","TRUE"
513+"4930","4930","sopravvenienze passive ordinarie diverse ","49","account_type_p_l","other","TRUE"
514+"4940","4940","insussistenze passive ordinarie diverse ","49","account_type_p_l","other","TRUE"
515+"5","5","PROVENTI E ONERI FINANZIARI ","0","account_type_view","view","TRUE"
516+"51","51","PROVENTI FINANZIARI ","5","account_type_view","view","TRUE"
517+"5110","5110","interessi attivi v/clienti ","51","account_type_p_l","other","TRUE"
518+"5115","5115","interessi attivi bancari ","51","account_type_p_l","other","TRUE"
519+"5116","5116","interessi attivi postali ","51","account_type_p_l","other","TRUE"
520+"5140","5140","proventi finanziari diversi ","51","account_type_p_l","other","TRUE"
521+"52","52","ONERI FINANZIARI ","5","account_type_view","view","TRUE"
522+"5201","5201","interessi passivi v/fornitori ","52","account_type_p_l","other","TRUE"
523+"5202","5202","interessi passivi bancari ","52","account_type_p_l","other","TRUE"
524+"5203","5203","sconti passivi bancari ","52","account_type_p_l","other","TRUE"
525+"5210","5210","interessi passivi su mutui ","52","account_type_p_l","other","TRUE"
526+"5240","5240","oneri finanziari diversi ","52","account_type_p_l","other","TRUE"
527+"7","7","PROVENTI E ONERI STRAORDINARI ","0","account_type_view","view","TRUE"
528+"71","71","PROVENTI STRAORDINARI ","7","account_type_view","view","TRUE"
529+"7101","7101","plusvalenze straordinarie ","71","account_type_p_l","other","TRUE"
530+"7102","7102","sopravvenienze attive straordinarie ","71","account_type_p_l","other","TRUE"
531+"7103","7103","insussistenze attive straordinarie ","71","account_type_p_l","other","TRUE"
532+"72","72","ONERI STRAORDINARI ","7","account_type_view","view","TRUE"
533+"7201","7201","minusvalenze straordinarie ","72","account_type_p_l","other","TRUE"
534+"7202","7202","sopravvenienze passive straordinarie ","72","account_type_p_l","other","TRUE"
535+"7203","7203","insussistenze passive straordinarie ","72","account_type_p_l","other","TRUE"
536+"7204","7204","imposte esercizi precedenti ","72","account_type_p_l","other","TRUE"
537+"8","8","IMPOSTE DELL'ESERCIZIO ","0","account_type_view","view","TRUE"
538+"8101","8101","imposte dell'esercizio ","8","account_type_p_l","other","TRUE"
539+"9","9","CONTI DI RISULTATO ","0","account_type_view","view","TRUE"
540+"9101","9101","conto di risultato economico ","9","account_type_p_l","other","TRUE"
541+"9102","9102","stato patrimoniale","9","account_type_p_l","other","TRUE"
542
543=== modified file 'l10n_it/data/account.account.type.csv'
544--- l10n_it/data/account.account.type.csv 2011-10-16 01:28:00 +0000
545+++ l10n_it/data/account.account.type.csv 2011-11-23 14:06:29 +0000
546@@ -1,11 +1,11 @@
547 "id","code","name","close_method","report_type"
548-"account_type_receivable","receivable","Debiti","unreconciled","liability"
549-"account_type_payable","payable","Crediti","unreconciled","asset"
550+"account_type_receivable","receivable","Crediti","unreconciled","asset"
551+"account_type_payable","payable","Debiti","unreconciled","liability"
552 "account_type_view","view","Gerarchia","none",
553 "account_type_income","income","Entrate","none","income"
554 "account_type_expense","expense","Uscite","none","expense"
555-"account_type_tax","tax","Tasse","none",
556+"account_type_tax","tax","Tasse","balance",
557 "account_type_cash","cash","Liquidità","balance","asset"
558-"account_type_asset","asset","Beni","none","asset"
559+"account_type_asset","asset","Beni","balance","asset"
560 "account_type_bank","bank","Banca","balance","asset"
561-"account_type_equity","equity","Capitale","none","asset"
562+"account_type_p_l","p_l","Conto Economico","none",
563
564=== modified file 'l10n_it/data/account.tax.code.template.csv'
565--- l10n_it/data/account.tax.code.template.csv 2011-01-14 00:11:01 +0000
566+++ l10n_it/data/account.tax.code.template.csv 2011-11-23 14:06:29 +0000
567@@ -26,6 +26,8 @@
568 "IVC4Idet50","template_impcode_pagata_4det50","IVA a credito 4% detraibile 50% (imponibile)","template_impcode_pagata"
569 "IVC20","template_ivacode_pagata_20","IVA a credito 20%","template_ivacode_pagata"
570 "IVC20I","template_impcode_pagata_20","IVA a credito 20% (imponibile)","template_impcode_pagata"
571+"IVC21","template_ivacode_pagata_21","IVA a credito 21%","template_ivacode_pagata"
572+"IVC21I","template_impcode_pagata_21","IVA a credito 21% (imponibile)","template_impcode_pagata"
573 "IVC4","template_ivacode_pagata_4","IVA a credito 4%","template_ivacode_pagata"
574 "IVC4I","template_impcode_pagata_4","IVA a credito 4% (imponibile)","template_impcode_pagata"
575 "IVC12","template_ivacode_pagata_12","IVA a credito 12%","template_ivacode_pagata"
576@@ -40,9 +42,21 @@
577 "IVD10I","template_impcode_riscossa_10","IVA a debito 10% (imponibile)","template_impcode_riscossa"
578 "IVD20","template_ivacode_riscossa_20","IVA a debito 20%","template_ivacode_riscossa"
579 "IVD20I","template_impcode_riscossa_20","IVA a debito 20% (imponibile)","template_impcode_riscossa"
580+"IVD21","template_ivacode_riscossa_21","IVA a debito 21%","template_ivacode_riscossa"
581+"IVD21I","template_impcode_riscossa_21","IVA a debito 21% (imponibile)","template_impcode_riscossa"
582 "IVD4","template_ivacode_riscossa_4","IVA a debito 4%","template_ivacode_riscossa"
583 "IVD4I","template_impcode_riscossa_4","IVA a debito 4% (imponibile)","template_impcode_riscossa"
584 "IVD12","template_ivacode_riscossa_12","IVA a debito 12%","template_ivacode_riscossa"
585 "IVD12I","template_impcode_riscossa_12","IVA a debito 12% (imponibile)","template_impcode_riscossa"
586 "IVD2","template_ivacode_riscossa_2","IVA a debito 2%","template_ivacode_riscossa"
587 "IVD2I","template_impcode_riscossa_2","IVA a debito 2% (imponibile)","template_impcode_riscossa"
588+"IVC21ind","template_ivacode_pagata_21ind","IVA a credito 21% indetraibile","template_ivacode_pagata"
589+"IVC21Iind","template_impcode_pagata_21ind","IVA a credito 21% indetraibile (imponibile)","template_impcode_pagata"
590+"IVC21det10","template_ivacode_pagata_21det10","IVA a credito 21% detraibile 10%","template_ivacode_pagata"
591+"IVC21Idet10","template_impcode_pagata_21det10","IVA a credito 21% detraibile 10% (imponibile)","template_impcode_pagata"
592+"IVC21det15","template_ivacode_pagata_21det15","IVA a credito 21% detraibile 15%","template_ivacode_pagata"
593+"IVC21Idet15","template_impcode_pagata_21det15","IVA a credito 21% detraibile 15% (imponibile)","template_impcode_pagata"
594+"IVC21det40","template_ivacode_pagata_21det40","IVA a credito 21% detraibile 40%","template_ivacode_pagata"
595+"IVC21Idet40","template_impcode_pagata_21det40","IVA a credito 21% detraibile 40% (imponibile)","template_impcode_pagata"
596+"IVC21det50","template_ivacode_pagata_21det50","IVA a credito 21% detraibile 50%","template_ivacode_pagata"
597+"IVC21Idet50","template_impcode_pagata_21det50","IVA a credito 21% detraibile 50% (imponibile)","template_impcode_pagata"
598
599=== modified file 'l10n_it/data/account.tax.template.csv'
600--- l10n_it/data/account.tax.template.csv 2011-01-14 00:11:01 +0000
601+++ l10n_it/data/account.tax.template.csv 2011-11-23 14:06:29 +0000
602@@ -1,40 +1,64 @@
603-"id","description","chart_template_id:id","name","amount","parent_id:id","child_depend","type","account_collected_id:id","account_paid_id:id","type_tax_use","base_code_id:id","tax_code_id:id","ref_base_code_id:id","ref_tax_code_id:id"
604-"20a","20a","l10n_it_chart_template_generic","Iva al 20% (debito)","0.2",,"False","percent","2601","2601","sale","template_impcode_riscossa_20","template_ivacode_riscossa_20","template_impcode_riscossa_20","template_ivacode_riscossa_20"
605-"20b","20b","l10n_it_chart_template_generic","Iva al 20% (credito)","0.2",,"False","percent","1601","1601","purchase","template_impcode_pagata_20","template_ivacode_pagata_20","template_impcode_pagata_20","template_ivacode_pagata_20"
606-"10a","10a","l10n_it_chart_template_generic","Iva al 10% (debito)","0.1",,"False","percent","2601","2601","sale","template_impcode_riscossa_10","template_ivacode_riscossa_10","template_impcode_riscossa_10","template_ivacode_riscossa_10"
607-"10b","10b","l10n_it_chart_template_generic","Iva al 10% (credito)","0.1",,"False","percent","1601","1601","purchase","template_impcode_pagata_10","template_ivacode_pagata_10","template_impcode_pagata_10","template_ivacode_pagata_10"
608-"10AO","10AO","l10n_it_chart_template_generic","Iva al 10% indetraibile","1",,"True","percent",,,"purchase",,,,
609-"10AOa","10AOa","l10n_it_chart_template_generic","Iva al 10% indetraibile (1)","0","10AO","False","percent","1601","1601","purchase","template_impcode_pagata_10ind","template_ivacode_pagata_10ind","template_impcode_pagata_10ind","template_ivacode_pagata_10ind"
610-"10AOb","10AOb","l10n_it_chart_template_generic","Iva al 10% indetraibile (2)","0.1","10AO","False","percent",,,"purchase",,,,
611-"12a","12a","l10n_it_chart_template_generic","Iva 12% (debito)","0.12",,"False","percent","2601","2601","sale","template_impcode_riscossa_12","template_ivacode_riscossa_12","template_impcode_riscossa_12","template_ivacode_riscossa_12"
612-"12b","12b","l10n_it_chart_template_generic","Iva 12% (credito)","0.12",,"False","percent","1601","1601","purchase","template_impcode_pagata_12","template_ivacode_pagata_12","template_impcode_pagata_12","template_ivacode_pagata_12"
613-"2010","2010","l10n_it_chart_template_generic","Iva al 20% detraibile 10%","1",,"True","percent",,,"purchase",,,,
614-"2010a","2010a","l10n_it_chart_template_generic","Iva al 20% detraibile 10% (1)","0.02","2010","False","percent","1601","1601","purchase","template_impcode_pagata_20det10","template_ivacode_pagata_20det10","template_impcode_pagata_20det10","template_ivacode_pagata_20det10"
615-"2010b","2010b","l10n_it_chart_template_generic","Iva al 20% detraibile 10% (2)","0.18","2010","False","percent",,,"purchase",,,,
616-"2015","2015","l10n_it_chart_template_generic","Iva al 20% detraibile 15%","1",,"True","percent",,,"purchase",,,,
617-"2015a","2015a","l10n_it_chart_template_generic","Iva al 20% detraibile 15% (1)","0.03","2015","False","percent","1601","1601","purchase","template_impcode_pagata_20det15","template_ivacode_pagata_20det15","template_impcode_pagata_20det15","template_ivacode_pagata_20det15"
618-"2015b","2015b","l10n_it_chart_template_generic","Iva al 20% detraibile 15% (2)","0.17","2015","False","percent",,,"purchase",,,,
619-"2040","2040","l10n_it_chart_template_generic","Iva al 20% detraibile 40%","1",,"True","percent",,,"purchase",,,,
620-"2040a","2040a","l10n_it_chart_template_generic","Iva al 20% detraibile 40% (1)","0.08","2040","False","percent","1601","1601","purchase","template_impcode_pagata_20det40","template_ivacode_pagata_20det40","template_impcode_pagata_20det40","template_ivacode_pagata_20det40"
621-"2040b","2040b","l10n_it_chart_template_generic","Iva al 20% detraibile 40% (2)","0.12","2040","False","percent",,,"purchase",,,,
622-"20AO","20AO","l10n_it_chart_template_generic","Iva al 20% indetraibile","1",,"True","percent",,,"purchase",,,,
623-"20AOa","20AOa","l10n_it_chart_template_generic","Iva al 20% indetraibile (1)","0","20AO","False","percent","1601","1601","purchase","template_impcode_pagata_20ind","template_ivacode_pagata_20ind","template_impcode_pagata_20ind","template_ivacode_pagata_20ind"
624-"20AOb","20AOb","l10n_it_chart_template_generic","Iva al 20% indetraibile (2)","0.2","20AO","False","percent",,,"purchase",,,,
625-"20I5","20I5","l10n_it_chart_template_generic","IVA al 20% detraibile al 50%","1",,"True","percent",,,"purchase",,,,
626-"20I5a","20I5a","l10n_it_chart_template_generic","IVA al 20% detraibile al 50% (1)","0.1","20I5","False","percent","1601","1601","purchase","template_impcode_pagata_20det50","template_ivacode_pagata_20det50","template_impcode_pagata_20det50","template_ivacode_pagata_20det50"
627-"20I5b","20I5b","l10n_it_chart_template_generic","IVA al 20% detraibile al 50% (2)","0.1","20I5","False","percent",,,"purchase",,,,
628-"22a","22a","l10n_it_chart_template_generic","Iva 2% (debito)","0.02",,"False","percent","2601","2601","sale","template_impcode_riscossa_2","template_ivacode_riscossa_2","template_impcode_riscossa_2","template_ivacode_riscossa_2"
629-"22b","22b","l10n_it_chart_template_generic","Iva 2% (credito)","0.02",,"False","percent","1601","1601","purchase","template_impcode_pagata_2","template_ivacode_pagata_2","template_impcode_pagata_2","template_ivacode_pagata_2"
630-"4a","4a","l10n_it_chart_template_generic","Iva 4% (debito)","0.04",,"False","percent","2601","2601","sale","template_impcode_riscossa_4","template_ivacode_riscossa_4","template_impcode_riscossa_4","template_ivacode_riscossa_4"
631-"4b","4b","l10n_it_chart_template_generic","Iva 4% (credito)","0.04",,"False","percent","1601","1601","purchase","template_impcode_pagata_4","template_ivacode_pagata_4","template_impcode_pagata_4","template_ivacode_pagata_4"
632-"4AO","4AO","l10n_it_chart_template_generic","Iva al 4% indetraibile","1",,"True","percent",,,"purchase",,,,
633-"4AOa","4AOa","l10n_it_chart_template_generic","Iva al 4% indetraibile (1)","0","4AO","False","percent","1601","1601","purchase","template_impcode_pagata_4ind","template_ivacode_pagata_4ind","template_impcode_pagata_4ind","template_ivacode_pagata_4ind"
634-"4AOb","4AOb","l10n_it_chart_template_generic","Iva al 4% indetraibile (2)","0.04","4AO","False","percent",,,"purchase",,,,
635-"10I5","10I5","l10n_it_chart_template_generic","IVA al 10% detraibile al 50%","1",,"True","percent",,,"purchase",,,,
636-"10I5a","10I5a","l10n_it_chart_template_generic","IVA al 10% detraibile al 50% (1)","0.05","10I5","False","percent","1601","1601","purchase","template_impcode_pagata_10det50","template_ivacode_pagata_10det50","template_impcode_pagata_10det50","template_ivacode_pagata_10det50"
637-"10I5b","10I5b","l10n_it_chart_template_generic","IVA al 10% detraibile al 50% (2)","0.05","10I5","False","percent",,,"purchase",,,,
638-"4I5","4I5","l10n_it_chart_template_generic","IVA al 4% detraibile al 50%","1",,"True","percent",,,"purchase",,,,
639-"4I5a","4I5a","l10n_it_chart_template_generic","IVA al 4% detraibile al 50% (1)","0.02","4I5","False","percent","1601","1601","purchase","template_impcode_pagata_4det50","template_ivacode_pagata_4det50","template_impcode_pagata_4det50","template_ivacode_pagata_4det50"
640-"4I5b","4I5b","l10n_it_chart_template_generic","IVA al 4% detraibile al 50% (2)","0.02","4I5","False","percent",,,"purchase",,,,
641-"00a","00a","l10n_it_chart_template_generic","Esente IVA (debito)","0",,"False","percent","2601","2601","sale","template_impcode_riscossa_0","template_ivacode_riscossa_0","template_impcode_riscossa_0","template_ivacode_riscossa_0"
642-"00b","00b","l10n_it_chart_template_generic","Esente IVA (credito)","0",,"False","percent","1601","1601","purchase","template_impcode_pagata_0","template_ivacode_pagata_0","template_impcode_pagata_0","template_ivacode_pagata_0"
643+id,description,chart_template_id:id,name,sequence,amount,parent_id:id,child_depend,type,account_collected_id:id,account_paid_id:id,type_tax_use,base_code_id:id,tax_code_id:id,ref_base_code_id:id,ref_tax_code_id:id,ref_base_sign,ref_tax_sign,price_include,base_sign,tax_sign
644+21a,21a,l10n_it_chart_template_generic,Iva al 21% (debito),,0.21,,False,percent,2601,2601,sale,template_impcode_riscossa_21,template_ivacode_riscossa_21,template_impcode_riscossa_21,template_ivacode_riscossa_21,-1,-1,False,,
645+21b,21b,l10n_it_chart_template_generic,Iva al 21% (credito),,0.21,,False,percent,1601,1601,purchase,template_impcode_pagata_21,template_ivacode_pagata_21,template_impcode_pagata_21,template_ivacode_pagata_21,,,False,-1,-1
646+20a,20a,l10n_it_chart_template_generic,Iva al 20% (debito),,0.2,,False,percent,2601,2601,sale,template_impcode_riscossa_20,template_ivacode_riscossa_20,template_impcode_riscossa_20,template_ivacode_riscossa_20,-1,-1,False,,
647+20b,20b,l10n_it_chart_template_generic,Iva al 20% (credito),,0.2,,False,percent,1601,1601,purchase,template_impcode_pagata_20,template_ivacode_pagata_20,template_impcode_pagata_20,template_ivacode_pagata_20,,,False,-1,-1
648+10a,10a,l10n_it_chart_template_generic,Iva al 10% (debito),,0.1,,False,percent,2601,2601,sale,template_impcode_riscossa_10,template_ivacode_riscossa_10,template_impcode_riscossa_10,template_ivacode_riscossa_10,-1,-1,False,,
649+10b,10b,l10n_it_chart_template_generic,Iva al 10% (credito),,0.1,,False,percent,1601,1601,purchase,template_impcode_pagata_10,template_ivacode_pagata_10,template_impcode_pagata_10,template_ivacode_pagata_10,,,False,-1,-1
650+10AO,10AO,l10n_it_chart_template_generic,Iva al 10% indetraibile,,0.1,,True,percent,,,purchase,template_impcode_pagata_10ind,,template_impcode_pagata_10ind,,,,False,-1,-1
651+10AOa,10AOa,l10n_it_chart_template_generic,Iva al 10% indetraibile (D),2,0,10AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_10ind,,template_ivacode_pagata_10ind,,,False,,
652+10AOb,10AOb,l10n_it_chart_template_generic,Iva al 10% indetraibile (I),1,1,10AO,False,percent,,,purchase,,,,,,,False,,
653+12a,12a,l10n_it_chart_template_generic,Iva 12% (debito),,0.12,,False,percent,2601,2601,sale,template_impcode_riscossa_12,template_ivacode_riscossa_12,template_impcode_riscossa_12,template_ivacode_riscossa_12,-1,-1,False,,
654+12b,12b,l10n_it_chart_template_generic,Iva 12% (credito),,0.12,,False,percent,1601,1601,purchase,template_impcode_pagata_12,template_ivacode_pagata_12,template_impcode_pagata_12,template_ivacode_pagata_12,,,False,-1,-1
655+2010,2010,l10n_it_chart_template_generic,Iva al 20% detraibile 10%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det10,,template_impcode_pagata_20det10,,,,False,-1,-1
656+2010a,2010a,l10n_it_chart_template_generic,Iva al 20% detraibile 10% (D),2,0,2010,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det10,,template_ivacode_pagata_20det10,,,False,,
657+2010b,2010b,l10n_it_chart_template_generic,Iva al 20% detraibile 10% (I),1,0.9,2010,False,percent,,,purchase,,,,,,,False,,
658+2015,2015,l10n_it_chart_template_generic,Iva al 20% detraibile 15%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det15,,template_impcode_pagata_20det15,,,,False,-1,-1
659+2015a,2015a,l10n_it_chart_template_generic,Iva al 20% detraibile 15% (D),2,0,2015,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det15,,template_ivacode_pagata_20det15,,,False,,
660+2015b,2015b,l10n_it_chart_template_generic,Iva al 20% detraibile 15% (I),1,0.85,2015,False,percent,,,purchase,,,,,,,False,,
661+2040,2040,l10n_it_chart_template_generic,Iva al 20% detraibile 40%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det40,,template_impcode_pagata_20det40,,,,False,-1,-1
662+2040a,2040a,l10n_it_chart_template_generic,Iva al 20% detraibile 40% (D),2,0,2040,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det40,,template_ivacode_pagata_20det40,,,False,,
663+2040b,2040b,l10n_it_chart_template_generic,Iva al 20% detraibile 40% (I),1,0.6,2040,False,percent,,,purchase,,,,,,,False,,
664+20AO,20AO,l10n_it_chart_template_generic,Iva al 20% indetraibile,,0.2,,True,percent,,,purchase,template_impcode_pagata_20ind,,template_impcode_pagata_20ind,,,,False,-1,-1
665+20AOa,20AOa,l10n_it_chart_template_generic,Iva al 20% indetraibile (D),2,0,20AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_20ind,,template_ivacode_pagata_20ind,,,False,,
666+20AOb,20AOb,l10n_it_chart_template_generic,Iva al 20% indetraibile (I),1,1,20AO,False,percent,,,purchase,,,,,,,False,,
667+20I5,20I5,l10n_it_chart_template_generic,IVA al 20% detraibile al 50%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det50,,template_impcode_pagata_20det50,,,,False,-1,-1
668+20I5b,20I5b,l10n_it_chart_template_generic,IVA al 20% detraibile al 50% (I),1,0.5,20I5,False,percent,,,purchase,,,,,,,False,,
669+20I5a,20I5a,l10n_it_chart_template_generic,IVA al 20% detraibile al 50% (D),2,0,20I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det50,,template_ivacode_pagata_20det50,,,False,,
670+22a,22a,l10n_it_chart_template_generic,Iva 2% (debito),,0.02,,False,percent,2601,2601,sale,template_impcode_riscossa_2,template_ivacode_riscossa_2,template_impcode_riscossa_2,template_ivacode_riscossa_2,-1,-1,False,,
671+22b,22b,l10n_it_chart_template_generic,Iva 2% (credito),,0.02,,False,percent,1601,1601,purchase,template_impcode_pagata_2,template_ivacode_pagata_2,template_impcode_pagata_2,template_ivacode_pagata_2,,,False,-1,-1
672+4a,4a,l10n_it_chart_template_generic,Iva 4% (debito),,0.04,,False,percent,2601,2601,sale,template_impcode_riscossa_4,template_ivacode_riscossa_4,template_impcode_riscossa_4,template_ivacode_riscossa_4,-1,-1,False,,
673+4b,4b,l10n_it_chart_template_generic,Iva 4% (credito),,0.04,,False,percent,1601,1601,purchase,template_impcode_pagata_4,template_ivacode_pagata_4,template_impcode_pagata_4,template_ivacode_pagata_4,,,False,-1,-1
674+4AO,4AO,l10n_it_chart_template_generic,Iva al 4% indetraibile,,0.04,,True,percent,,,purchase,template_impcode_pagata_4ind,,template_impcode_pagata_4ind,,,,False,-1,-1
675+4AOa,4AOa,l10n_it_chart_template_generic,Iva al 4% indetraibile (D),2,0,4AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_4ind,,template_ivacode_pagata_4ind,,,False,,
676+4AOb,4AOb,l10n_it_chart_template_generic,Iva al 4% indetraibile (I),1,1,4AO,False,percent,,,purchase,,,,,,,False,,
677+10I5,10I5,l10n_it_chart_template_generic,IVA al 10% detraibile al 50%,,0.1,,True,percent,,,purchase,template_impcode_pagata_10det50,,template_impcode_pagata_10det50,,,,False,-1,-1
678+10I5a,10I5a,l10n_it_chart_template_generic,IVA al 10% detraibile al 50% (D),2,0,10I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_10det50,,template_ivacode_pagata_10det50,,,False,,
679+10I5b,10I5b,l10n_it_chart_template_generic,IVA al 10% detraibile al 50% (I),1,0.5,10I5,False,percent,,,purchase,,,,,,,False,,
680+4I5,4I5,l10n_it_chart_template_generic,IVA al 4% detraibile al 50%,,0.04,,True,percent,,,purchase,template_impcode_pagata_4det50,,template_impcode_pagata_4det50,,,,False,-1,-1
681+4I5a,4I5a,l10n_it_chart_template_generic,IVA al 4% detraibile al 50% (D),2,0,4I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_4det50,,template_ivacode_pagata_4det50,,,False,,
682+4I5b,4I5b,l10n_it_chart_template_generic,IVA al 4% detraibile al 50% (I),1,0.5,4I5,False,percent,,,purchase,,,,,,,False,,
683+00a,00a,l10n_it_chart_template_generic,Esente IVA (debito),,0,,False,percent,2601,2601,sale,template_impcode_riscossa_0,template_ivacode_riscossa_0,template_impcode_riscossa_0,template_ivacode_riscossa_0,-1,-1,False,,
684+00b,00b,l10n_it_chart_template_generic,Esente IVA (credito),,0,,False,percent,1601,1601,purchase,template_impcode_pagata_0,template_ivacode_pagata_0,template_impcode_pagata_0,template_ivacode_pagata_0,,,False,-1,-1
685+21a INC,21a INC,l10n_it_chart_template_generic,Iva al 21% (debito) INC,,0.21,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_21,l10n_it.template_ivacode_riscossa_21,l10n_it.template_impcode_riscossa_21,l10n_it.template_ivacode_riscossa_21,-1,-1,True,,
686+20a INC,20a INC,l10n_it_chart_template_generic,Iva al 20% (debito) INC,,0.2,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_20,l10n_it.template_ivacode_riscossa_20,l10n_it.template_impcode_riscossa_20,l10n_it.template_ivacode_riscossa_20,-1,-1,True,,
687+10a INC,10a INC,l10n_it_chart_template_generic,Iva al 10% (debito) INC,,0.1,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_10,l10n_it.template_ivacode_riscossa_10,l10n_it.template_impcode_riscossa_10,l10n_it.template_ivacode_riscossa_10,-1,-1,True,,
688+12a INC,12a INC,l10n_it_chart_template_generic,Iva 12% (debito) INC,,0.12,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_12,l10n_it.template_ivacode_riscossa_12,l10n_it.template_impcode_riscossa_12,l10n_it.template_ivacode_riscossa_12,-1,-1,True,,
689+22a INC,22a INC,l10n_it_chart_template_generic,Iva 2% (debito) INC,,0.02,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_2,l10n_it.template_ivacode_riscossa_2,l10n_it.template_impcode_riscossa_2,l10n_it.template_ivacode_riscossa_2,-1,-1,True,,
690+4a INC,4a INC,l10n_it_chart_template_generic,Iva 4% (debito) INC,,0.04,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_4,l10n_it.template_ivacode_riscossa_4,l10n_it.template_impcode_riscossa_4,l10n_it.template_ivacode_riscossa_4,-1,-1,True,,
691+00a INC,00a INC,l10n_it_chart_template_generic,Esente IVA (debito) INC,,0,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_0,l10n_it.template_ivacode_riscossa_0,l10n_it.template_impcode_riscossa_0,l10n_it.template_ivacode_riscossa_0,-1,-1,True,,
692+2110,2110,l10n_it_chart_template_generic,Iva al 21% detraibile 10%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det10,,template_impcode_pagata_21det10,,,,False,-1,-1
693+2110a,2110a,l10n_it_chart_template_generic,Iva al 21% detraibile 10% (D),2,0,2110,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det10,,template_ivacode_pagata_21det10,,,False,,
694+2110b,2110b,l10n_it_chart_template_generic,Iva al 21% detraibile 10% (I),1,0.9,2110,False,percent,,,purchase,,,,,,,False,,
695+2115,2115,l10n_it_chart_template_generic,Iva al 21% detraibile 15%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det15,,template_impcode_pagata_21det15,,,,False,-1,-1
696+2115a,2115a,l10n_it_chart_template_generic,Iva al 21% detraibile 15% (D),2,0,2115,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det15,,template_ivacode_pagata_21det15,,,False,,
697+2115b,2115b,l10n_it_chart_template_generic,Iva al 21% detraibile 15% (I),1,0.85,2115,False,percent,,,purchase,,,,,,,False,,
698+2140,2140,l10n_it_chart_template_generic,Iva al 21% detraibile 40%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det40,,template_impcode_pagata_21det40,,,,False,-1,-1
699+2140a,2140a,l10n_it_chart_template_generic,Iva al 21% detraibile 40% (D),2,0,2140,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det40,,template_ivacode_pagata_21det40,,,False,,
700+2140b,2140b,l10n_it_chart_template_generic,Iva al 21% detraibile 40% (I),1,0.6,2140,False,percent,,,purchase,,,,,,,False,,
701+21AO,21AO,l10n_it_chart_template_generic,Iva al 21% indetraibile,,0.21,,True,percent,,,purchase,template_impcode_pagata_21ind,,template_impcode_pagata_21ind,,,,False,-1,-1
702+21AOa,21AOa,l10n_it_chart_template_generic,Iva al 21% indetraibile (D),2,0,21AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_21ind,,template_ivacode_pagata_21ind,,,False,,
703+21AOb,21AOb,l10n_it_chart_template_generic,Iva al 21% indetraibile (I),1,1,21AO,False,percent,,,purchase,,,,,,,False,,
704+21I5,21I5,l10n_it_chart_template_generic,IVA al 21% detraibile al 50%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det50,,template_impcode_pagata_21det50,,,,False,-1,-1
705+21I5b,21I5b,l10n_it_chart_template_generic,IVA al 21% detraibile al 50% (I),1,0.5,21I5,False,percent,,,purchase,,,,,,,False,,
706+21I5a,21I5a,l10n_it_chart_template_generic,IVA al 21% detraibile al 50% (D),2,0,21I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det50,,template_ivacode_pagata_21det50,,,False,,
707
708=== modified file 'l10n_it/i18n/it.po'
709--- l10n_it/i18n/it.po 2011-11-09 18:12:56 +0000
710+++ l10n_it/i18n/it.po 2011-11-23 14:06:29 +0000
711@@ -1,167 +1,28 @@
712-# Italian translation for openobject-addons
713-# Copyright (c) 2011 Rosetta Contributors and Canonical Ltd 2011
714-# This file is distributed under the same license as the openobject-addons package.
715-# FIRST AUTHOR <EMAIL@ADDRESS>, 2011.
716+# Translation of OpenERP Server.
717+# This file contains the translation of the following modules:
718+# * l10n_it
719 #
720 msgid ""
721 msgstr ""
722-"Project-Id-Version: openobject-addons\n"
723-"Report-Msgid-Bugs-To: FULL NAME <EMAIL@ADDRESS>\n"
724-"POT-Creation-Date: 2011-01-07 06:04+0000\n"
725-"PO-Revision-Date: 2011-02-15 15:37+0000\n"
726-"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
727-"Language-Team: Italian <it@li.org>\n"
728+"Project-Id-Version: OpenERP Server 6.0.2\n"
729+"Report-Msgid-Bugs-To: support@openerp.com\n"
730+"POT-Creation-Date: 2011-08-11 20:06+0000\n"
731+"PO-Revision-Date: 2011-08-11 20:06+0000\n"
732+"Last-Translator: <>\n"
733+"Language-Team: \n"
734 "MIME-Version: 1.0\n"
735 "Content-Type: text/plain; charset=UTF-8\n"
736-"Content-Transfer-Encoding: 8bit\n"
737-"X-Launchpad-Export-Date: 2011-11-05 05:57+0000\n"
738-"X-Generator: Launchpad (build 14231)\n"
739-
740-#. module: l10n_it
741-#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_debit
742-msgid "Registro acquisti"
743-msgstr "Registro acquisti"
744-
745-#. module: l10n_it
746-#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
747-msgid ""
748-"Generate Chart of Accounts from a Chart Template. You will be asked to pass "
749-"the name of the company, the chart template to follow, the no. of digits to "
750-"generate the code for your accounts and Bank account, currency to create "
751-"Journals. Thus,the pure copy of chart Template is generated.\n"
752-"\tThis is the same wizard that runs from Financial "
753-"Management/Configuration/Financial Accounting/Financial Accounts/Generate "
754-"Chart of Accounts from a Chart Template."
755-msgstr ""
756-"Genera il Piano dei Conti da un Modello. Vi verrà richiesto di passare il "
757-"nome dell'azienda, il modello da seguire, il numero di decimali per generare "
758-"il codice dei tuoi conti e, per il conto della Banca, la valuta per creare "
759-"il Libro Giornale. Così una copia vergine del Piano dei Conti, derivatante "
760-"dal modello, viene generata.\n"
761-"\tQuesto è la stessa procedura automatica che viene lanciata da: Gestione "
762-"Finanziaria / Configurazione / Contabilità / Conti finanziari / Genera il "
763-"Piano dei conti da un modello."
764-
765-#. module: l10n_it
766-#: view:account.report_libroiva:0
767-msgid "Anno Fiscale"
768-msgstr "Anno Fiscale"
769-
770-#. module: l10n_it
771-#: model:account.fiscal.position.template,name:l10n_it.it
772-msgid "Italia"
773-msgstr "Italia"
774-
775-#. module: l10n_it
776-#: report:l10n_it.report.libroIVA_credito:0
777-#: report:l10n_it.report.libroIVA_debito:0
778-msgid "REGISTRO IVA"
779-msgstr "REGISTRO IVA"
780-
781-#. module: l10n_it
782-#: report:l10n_it.report.libroIVA_credito:0
783-#: report:l10n_it.report.libroIVA_debito:0
784-msgid "Protocollo"
785-msgstr "Protocollo"
786-
787-#. module: l10n_it
788-#: model:account.fiscal.position.template,name:l10n_it.extra
789-msgid "Regime Extra comunitario"
790-msgstr "Regime Extra comunitario"
791-
792-#. module: l10n_it
793-#: report:l10n_it.report.libroIVA_credito:0
794-msgid "VENDITE"
795-msgstr "VENDITE"
796-
797-#. module: l10n_it
798-#: report:l10n_it.report.libroIVA_credito:0
799-#: report:l10n_it.report.libroIVA_debito:0
800-msgid "Aliquota"
801-msgstr "Aliquota"
802-
803-#. module: l10n_it
804-#: field:account.report_libroiva,company_id:0
805-msgid "Company"
806-msgstr "Azienda"
807-
808-#. module: l10n_it
809-#: field:account.report_libroiva,name:0
810-msgid "Fiscal year"
811-msgstr "Anno fiscale"
812-
813-#. module: l10n_it
814-#: report:l10n_it.report.libroIVA_credito:0
815-#: report:l10n_it.report.libroIVA_debito:0
816-msgid "Numero"
817-msgstr "Numero"
818-
819-#. module: l10n_it
820-#: report:l10n_it.report.libroIVA_debito:0
821-msgid "Fornitore"
822-msgstr "Fornitore"
823-
824-#. module: l10n_it
825-#: report:l10n_it.report.libroIVA_debito:0
826-msgid "ACQUISTI"
827-msgstr "ACQUISTI"
828+"Content-Transfer-Encoding: \n"
829+"Plural-Forms: \n"
830
831 #. module: l10n_it
832 #: model:ir.module.module,description:l10n_it.module_meta_information
833-msgid ""
834-"\n"
835-" Piano dei conti italiano di un'impresa generica\n"
836-" "
837-msgstr ""
838-"\n"
839-" Piano dei conti italiano di un'impresa generica\n"
840-" "
841-
842-#. module: l10n_it
843-#: report:l10n_it.report.libroIVA_credito:0
844-msgid "Cliente"
845-msgstr "Cliente"
846-
847-#. module: l10n_it
848-#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_credit
849-msgid "Registro vendite"
850-msgstr "Registro vendite"
851-
852-#. module: l10n_it
853-#: report:l10n_it.report.libroIVA_credito:0
854-#: report:l10n_it.report.libroIVA_debito:0
855-msgid "Periodo"
856-msgstr "Periodo"
857-
858-#. module: l10n_it
859-#: view:account.report_libroiva:0
860-#: model:ir.actions.act_window,name:l10n_it.l10n_chart_it_report_libroIVA_action
861-#: model:ir.ui.menu,name:l10n_it.menu_report_l10n_chart_it_libroIVA
862-msgid "Registri IVA"
863-msgstr "Registri IVA"
864-
865-#. module: l10n_it
866-#: report:l10n_it.report.libroIVA_credito:0
867-#: report:l10n_it.report.libroIVA_debito:0
868-msgid "Imposta"
869-msgstr "Imposta"
870-
871-#. module: l10n_it
872-#: model:account.fiscal.position.template,name:l10n_it.intra
873-msgid "Regime Intra comunitario"
874-msgstr "Regime Intra comunitario"
875-
876-#. module: l10n_it
877-#: report:l10n_it.report.libroIVA_credito:0
878-#: report:l10n_it.report.libroIVA_debito:0
879-msgid "Data fattura"
880-msgstr "Data fattura"
881-
882-#. module: l10n_it
883-#: report:l10n_it.report.libroIVA_credito:0
884-#: report:l10n_it.report.libroIVA_debito:0
885-msgid "Imponibile"
886-msgstr "Imponibile"
887+msgid "\n"
888+" Piano dei conti italiano di un'impresa generica\n"
889+" "
890+msgstr "\n"
891+" Piano dei conti italiano di un'impresa generica\n"
892+" "
893
894 #. module: l10n_it
895 #: model:ir.module.module,shortdesc:l10n_it.module_meta_information
896@@ -169,6 +30,14 @@
897 msgstr "Italia - Piano dei conti generico"
898
899 #. module: l10n_it
900-#: model:ir.model,name:l10n_it.model_account_report_libroiva
901-msgid "SQL view for libro IVA"
902-msgstr "Vista SQL per registro IVA"
903+#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
904+msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
905+" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
906+msgstr "Genera il piano dei conti da un template. Verrà chiesto di indicare il nome dell'azienda, il piano dei conti da seguire, il numero di cifre per generare il codice dei conti, la valuta per creare i sezionali. Quindi, una semplice copia del template verrà generata.\n"
907+" Questo è lo stesso wizard che viene eseguito da Contabilità/Configurazione/Contabilità Generale/Assetto finanziario della nuova azienda"
908+
909+#. module: l10n_it
910+#: model:ir.model,name:l10n_it.model_account_tax
911+msgid "account.tax"
912+msgstr "account.tax"
913+
914
915=== modified file 'l10n_it/i18n/l10n_it.pot'
916--- l10n_it/i18n/l10n_it.pot 2011-01-07 07:09:43 +0000
917+++ l10n_it/i18n/l10n_it.pot 2011-11-23 14:06:29 +0000
918@@ -4,10 +4,10 @@
919 #
920 msgid ""
921 msgstr ""
922-"Project-Id-Version: OpenERP Server 6.0.0-rc2\n"
923+"Project-Id-Version: OpenERP Server 6.0.2\n"
924 "Report-Msgid-Bugs-To: support@openerp.com\n"
925-"POT-Creation-Date: 2011-01-07 06:04:30+0000\n"
926-"PO-Revision-Date: 2011-01-07 06:04:30+0000\n"
927+"POT-Creation-Date: 2011-08-11 20:06+0000\n"
928+"PO-Revision-Date: 2011-08-11 20:06+0000\n"
929 "Last-Translator: <>\n"
930 "Language-Team: \n"
931 "MIME-Version: 1.0\n"
932@@ -16,81 +16,6 @@
933 "Plural-Forms: \n"
934
935 #. module: l10n_it
936-#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_debit
937-msgid "Registro acquisti"
938-msgstr ""
939-
940-#. module: l10n_it
941-#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
942-msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
943-" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
944-msgstr ""
945-
946-#. module: l10n_it
947-#: view:account.report_libroiva:0
948-msgid "Anno Fiscale"
949-msgstr ""
950-
951-#. module: l10n_it
952-#: model:account.fiscal.position.template,name:l10n_it.it
953-msgid "Italia"
954-msgstr ""
955-
956-#. module: l10n_it
957-#: report:l10n_it.report.libroIVA_credito:0
958-#: report:l10n_it.report.libroIVA_debito:0
959-msgid "REGISTRO IVA"
960-msgstr ""
961-
962-#. module: l10n_it
963-#: report:l10n_it.report.libroIVA_credito:0
964-#: report:l10n_it.report.libroIVA_debito:0
965-msgid "Protocollo"
966-msgstr ""
967-
968-#. module: l10n_it
969-#: model:account.fiscal.position.template,name:l10n_it.extra
970-msgid "Regime Extra comunitario"
971-msgstr ""
972-
973-#. module: l10n_it
974-#: report:l10n_it.report.libroIVA_credito:0
975-msgid "VENDITE"
976-msgstr ""
977-
978-#. module: l10n_it
979-#: report:l10n_it.report.libroIVA_credito:0
980-#: report:l10n_it.report.libroIVA_debito:0
981-msgid "Aliquota"
982-msgstr ""
983-
984-#. module: l10n_it
985-#: field:account.report_libroiva,company_id:0
986-msgid "Company"
987-msgstr ""
988-
989-#. module: l10n_it
990-#: field:account.report_libroiva,name:0
991-msgid "Fiscal year"
992-msgstr ""
993-
994-#. module: l10n_it
995-#: report:l10n_it.report.libroIVA_credito:0
996-#: report:l10n_it.report.libroIVA_debito:0
997-msgid "Numero"
998-msgstr ""
999-
1000-#. module: l10n_it
1001-#: report:l10n_it.report.libroIVA_debito:0
1002-msgid "Fornitore"
1003-msgstr ""
1004-
1005-#. module: l10n_it
1006-#: report:l10n_it.report.libroIVA_debito:0
1007-msgid "ACQUISTI"
1008-msgstr ""
1009-
1010-#. module: l10n_it
1011 #: model:ir.module.module,description:l10n_it.module_meta_information
1012 msgid "\n"
1013 " Piano dei conti italiano di un'impresa generica\n"
1014@@ -98,58 +23,18 @@
1015 msgstr ""
1016
1017 #. module: l10n_it
1018-#: report:l10n_it.report.libroIVA_credito:0
1019-msgid "Cliente"
1020-msgstr ""
1021-
1022-#. module: l10n_it
1023-#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_credit
1024-msgid "Registro vendite"
1025-msgstr ""
1026-
1027-#. module: l10n_it
1028-#: report:l10n_it.report.libroIVA_credito:0
1029-#: report:l10n_it.report.libroIVA_debito:0
1030-msgid "Periodo"
1031-msgstr ""
1032-
1033-#. module: l10n_it
1034-#: view:account.report_libroiva:0
1035-#: model:ir.actions.act_window,name:l10n_it.l10n_chart_it_report_libroIVA_action
1036-#: model:ir.ui.menu,name:l10n_it.menu_report_l10n_chart_it_libroIVA
1037-msgid "Registri IVA"
1038-msgstr ""
1039-
1040-#. module: l10n_it
1041-#: report:l10n_it.report.libroIVA_credito:0
1042-#: report:l10n_it.report.libroIVA_debito:0
1043-msgid "Imposta"
1044-msgstr ""
1045-
1046-#. module: l10n_it
1047-#: model:account.fiscal.position.template,name:l10n_it.intra
1048-msgid "Regime Intra comunitario"
1049-msgstr ""
1050-
1051-#. module: l10n_it
1052-#: report:l10n_it.report.libroIVA_credito:0
1053-#: report:l10n_it.report.libroIVA_debito:0
1054-msgid "Data fattura"
1055-msgstr ""
1056-
1057-#. module: l10n_it
1058-#: report:l10n_it.report.libroIVA_credito:0
1059-#: report:l10n_it.report.libroIVA_debito:0
1060-msgid "Imponibile"
1061-msgstr ""
1062-
1063-#. module: l10n_it
1064 #: model:ir.module.module,shortdesc:l10n_it.module_meta_information
1065 msgid "Italy - Generic Chart of Accounts"
1066 msgstr ""
1067
1068 #. module: l10n_it
1069-#: model:ir.model,name:l10n_it.model_account_report_libroiva
1070-msgid "SQL view for libro IVA"
1071+#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
1072+msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
1073+" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
1074+msgstr ""
1075+
1076+#. module: l10n_it
1077+#: model:ir.model,name:l10n_it.model_account_tax
1078+msgid "account.tax"
1079 msgstr ""
1080
1081
1082=== removed file 'l10n_it/libroIVA.py'
1083--- l10n_it/libroIVA.py 2011-01-14 00:11:01 +0000
1084+++ l10n_it/libroIVA.py 1970-01-01 00:00:00 +0000
1085@@ -1,54 +0,0 @@
1086-# -*- encoding: utf-8 -*-
1087-##############################################################################
1088-#
1089-# OpenERP, Open Source Management Solution
1090-# Copyright (C) 2010
1091-# Italian OpenERP Community (<http://www.openerp-italia.com>)
1092-# Servabit srl
1093-# Agile Business Group sagl
1094-# Domsense srl
1095-#
1096-# This program is free software: you can redistribute it and/or modify
1097-# it under the terms of the GNU Affero General Public License as
1098-# published by the Free Software Foundation, either version 3 of the
1099-# License, or (at your option) any later version.
1100-#
1101-# This program is distributed in the hope that it will be useful,
1102-# but WITHOUT ANY WARRANTY; without even the implied warranty of
1103-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
1104-# GNU Affero General Public License for more details.
1105-#
1106-# You should have received a copy of the GNU Affero General Public License
1107-# along with this program. If not, see <http://www.gnu.org/licenses/>.
1108-#
1109-##############################################################################
1110-
1111-
1112-# ##################################################################################
1113-# Questa vista SQL viene usata solo per far scegliere l'anno di pianificazione all'utente
1114-# Viene infatti costruita una vista XML di tipo tree che contiene solo i diversi anni per i quali stata fatta almeno una pianificazione
1115-# ##################################################################################
1116-
1117-from osv import fields, osv
1118-
1119-class l10n_chart_it_report_libroIVA (osv.osv):
1120- _name = "account.report_libroiva"
1121- _description = "SQL view for libro IVA"
1122- _auto = False
1123- _rec_name = "name"
1124- #_order = "fiscal_year";
1125-
1126- _columns = {
1127- 'name': fields.char('Fiscal year',size=64),
1128- 'company_id': fields.many2one('res.company', 'Company'),
1129- }
1130-
1131- def init (self, cr) :
1132- cr.execute("""DROP VIEW IF EXISTS account_report_libroiva""")
1133- cr.execute("""
1134- CREATE VIEW account_report_libroiva AS (
1135- SELECT id, name, company_id FROM account_fiscalyear
1136- )""")
1137-l10n_chart_it_report_libroIVA()
1138-
1139-
1140
1141=== removed file 'l10n_it/libroIVA_menu.xml'
1142--- l10n_it/libroIVA_menu.xml 2011-01-14 00:11:01 +0000
1143+++ l10n_it/libroIVA_menu.xml 1970-01-01 00:00:00 +0000
1144@@ -1,16 +0,0 @@
1145-<?xml version="1.0" encoding="utf-8"?>
1146-<!DOCTYPE terp SYSTEM "openerp-view.dtd">
1147-<openerp>
1148- <data>
1149-
1150- <!-- ****************************
1151- MENU REPORT LIBRI IVA
1152- **************************** -->
1153- <menuitem name="Registri IVA"
1154- id="menu_report_l10n_chart_it_libroIVA"
1155- sequence="20"
1156- parent="account.menu_finance_reporting"
1157- action="l10n_chart_it_report_libroIVA_action"
1158- />
1159- </data>
1160-</openerp>
1161
1162=== removed file 'l10n_it/libroIVA_view.xml'
1163--- l10n_it/libroIVA_view.xml 2011-01-14 00:11:01 +0000
1164+++ l10n_it/libroIVA_view.xml 1970-01-01 00:00:00 +0000
1165@@ -1,47 +0,0 @@
1166-<?xml version="1.0" encoding="utf-8"?>
1167-<openerp>
1168- <data>
1169-
1170- <!-- ****************************
1171- REGISTRI IVA TREE VIEW
1172- ****************************-->
1173- <record model="ir.ui.view" id="l10n_chart_it_report_libroIVA_tree">
1174- <field name="name">l10n_chart_it_report_libroIVA_tree</field>
1175- <field name="model">account.report_libroiva</field>
1176- <field name="type">tree</field>
1177- <field name="arch" type="xml">
1178- <tree string="Registri IVA" limit="80">
1179- <field name="name" string="Anno Fiscale" readonly="True" select="1" />
1180- </tree>
1181- </field>
1182- </record>
1183-
1184-
1185- <!-- ****************************
1186- REGISTRI IVA FORM VIEW
1187- ****************************-->
1188- <record model="ir.ui.view" id="l10n_chart_it_report_libroIVA_form">
1189- <field name="name">l10n_chart_it_report_libroIVA_form</field>
1190- <field name="model">account.report_libroiva</field>
1191- <field name="type">form</field>
1192- <field name="arch" type="xml">
1193- <form string="Registri IVA" >
1194- <field name="name" string="Anno Fiscale" readonly="True" />
1195- </form>
1196- </field>
1197- </record>
1198-
1199- <!-- ****************************
1200- REGISTRI IVA ACTION
1201- ****************************-->
1202- <record model="ir.actions.act_window" id="l10n_chart_it_report_libroIVA_action">
1203- <field name="name">Registri IVA</field>
1204- <field name="res_model">account.report_libroiva</field>
1205- <field name="view_id" ref="l10n_chart_it_report_libroIVA_tree"/>
1206- <field name="view_type">form</field>
1207- <field name="view_mode">tree,form</field>
1208- </record>
1209-
1210-
1211- </data>
1212-</openerp>
1213
1214=== removed directory 'l10n_it/report'
1215=== removed file 'l10n_it/report.xml'
1216--- l10n_it/report.xml 2011-01-14 00:11:01 +0000
1217+++ l10n_it/report.xml 1970-01-01 00:00:00 +0000
1218@@ -1,24 +0,0 @@
1219-<?xml version="1.0" encoding="utf-8"?>
1220-<openerp>
1221- <data>
1222-
1223- <report name="l10n_it.report.libroIVA_credito"
1224- id="account_ita_libroIVA_credit"
1225- string="Registro vendite"
1226- model="account.report_libroiva"
1227- rml="addons/l10n_it/report/libroIVA_credito.rml"
1228- auto="False"
1229- header="False"
1230- />
1231-
1232- <report name="l10n_it.report.libroIVA_debito"
1233- id="account_ita_libroIVA_debit"
1234- string="Registro acquisti"
1235- model="account.report_libroiva"
1236- rml="addons/l10n_it/report/libroIVA_debito.rml"
1237- auto="False"
1238- header="False"
1239- />
1240-
1241- </data>
1242-</openerp>
1243
1244=== removed file 'l10n_it/report/__init__.py'
1245--- l10n_it/report/__init__.py 2011-01-14 00:11:01 +0000
1246+++ l10n_it/report/__init__.py 1970-01-01 00:00:00 +0000
1247@@ -1,2 +0,0 @@
1248-import libroIVA_credito
1249-import libroIVA_debito
1250\ No newline at end of file
1251
1252=== removed file 'l10n_it/report/libroIVA_credito.py'
1253--- l10n_it/report/libroIVA_credito.py 2011-01-14 00:11:01 +0000
1254+++ l10n_it/report/libroIVA_credito.py 1970-01-01 00:00:00 +0000
1255@@ -1,79 +0,0 @@
1256-import datetime
1257-import time
1258-from report import report_sxw
1259-from osv import osv
1260-import pooler
1261-
1262-
1263-class l10n_chart_it_report_libroIVA_credito(report_sxw.rml_parse):
1264-
1265- def __init__(self, cr, uid, name, context):
1266- super(l10n_chart_it_report_libroIVA_credito,self).__init__(cr,uid,name,context)
1267- self.localcontext.update({
1268- 'time' : time,
1269- 'get_company' : self.get_company,
1270- 'get_periods' : self.get_periods,
1271- 'get_lines' : self.get_lines,
1272- })
1273-
1274-
1275- def get_company(self,fiscal_year):
1276- #print 'COMP = ',fiscal_year
1277- return ""
1278-
1279- def get_periods(self,fiscal_year):
1280- #print 'Fiscal year id:',fiscal_year.id
1281- obj=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
1282- fy=obj.browse(self.cr,self.uid,fiscal_year.id)
1283- #print 'Periods = ',fy.period_ids
1284- res=[rec for rec in fy.period_ids]
1285- #return fy.periods => non funziona?!? bool object !?!?
1286- return res
1287-
1288- def get_invoices(self,period):
1289- #print 'PERIOD = ',period.name
1290- obj=pooler.get_pool(self.cr.dbname).get('account.invoice')
1291- # Selezione tutte le fatture emesse nel periodo
1292- self.cr.execute( """
1293- SELECT id FROM account_invoice
1294- WHERE (state='open' OR state='paid') AND
1295- period_id="""+str(period.id)+"""
1296- AND (type='out_invoice' OR type='out_refund')
1297- """)
1298- ids=self.cr.fetchall()
1299- #print 'IDS = ',
1300- if ids:
1301- ids=[id[0] for id in ids ]
1302- invoices=obj.browse(self.cr,self.uid,ids)
1303- #print 'INVOICES = ',invoices
1304- return invoices
1305-
1306- def get_lines(self,fiscal_year):
1307- res=[]
1308- obj_fy=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
1309- fy=obj_fy.browse(self.cr,self.uid,fiscal_year.id)
1310- for period in fy.period_ids:
1311- invoices=self.get_invoices(period)
1312- for invoice in invoices:
1313- d={'periodo': period.name}
1314- d['protocollo']=invoice.number
1315- #print 'PARTNER ',invoice.partner_id.name
1316- causale=invoice.partner_id.name
1317- #print 'CAUSALE = ',causale
1318- d['causale']=causale
1319- d['numero']=invoice.reference
1320- d['data_doc']=invoice.date_invoice
1321- for tax in invoice.tax_line:
1322- #print '\tTAX: ',tax
1323- d['aliquota']=tax.tax_code_id.name
1324- d['imponibile']=tax.base
1325- d['imposta']=tax.amount
1326- res.append(d)
1327- d={'periodo':'', 'protocollo':'', 'causale':'', 'numero':'', 'data_doc':'', }
1328- return res
1329-
1330-
1331-
1332-report_sxw.report_sxw('report.l10n_it.report.libroIVA_credito','account.report_libroiva',
1333- 'l10n_it/report/libroIVA_credito.rml',
1334- parser=l10n_chart_it_report_libroIVA_credito,header=False)
1335
1336=== removed file 'l10n_it/report/libroIVA_credito.rml'
1337--- l10n_it/report/libroIVA_credito.rml 2011-01-14 00:11:01 +0000
1338+++ l10n_it/report/libroIVA_credito.rml 1970-01-01 00:00:00 +0000
1339@@ -1,203 +0,0 @@
1340-<?xml version="1.0"?>
1341-<document filename="test.pdf">
1342- <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
1343- <pageTemplate id="first">
1344- <frame id="first" x1="57.0" y1="57.0" width="498" height="678"/>
1345- </pageTemplate>
1346- </template>
1347- <stylesheet>
1348- <blockTableStyle id="Standard_Outline">
1349- <blockAlignment value="LEFT"/>
1350- <blockValign value="TOP"/>
1351- </blockTableStyle>
1352- <blockTableStyle id="Table1">
1353- <blockAlignment value="LEFT"/>
1354- <blockValign value="TOP"/>
1355- </blockTableStyle>
1356- <blockTableStyle id="Table2">
1357- <blockAlignment value="LEFT"/>
1358- <blockValign value="TOP"/>
1359- <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
1360- <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
1361- <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
1362- <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
1363- <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
1364- <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
1365- <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
1366- <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
1367- <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
1368- <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
1369- <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
1370- <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
1371- <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
1372- <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
1373- <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
1374- <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
1375- <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
1376- <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
1377- <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,0" stop="6,-1"/>
1378- <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
1379- <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
1380- <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,0" stop="7,-1"/>
1381- <lineStyle kind="LINEAFTER" colorName="#000000" start="7,0" stop="7,-1"/>
1382- <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
1383- <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
1384- <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
1385- <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
1386- <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
1387- <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
1388- <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
1389- <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
1390- <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
1391- <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
1392- <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
1393- <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
1394- <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,1" stop="5,-1"/>
1395- <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
1396- <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,1" stop="6,-1"/>
1397- <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
1398- <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,1" stop="7,-1"/>
1399- <lineStyle kind="LINEAFTER" colorName="#000000" start="7,1" stop="7,-1"/>
1400- <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
1401- <blockBackground colorName="#ffcc99" start="0,0" stop="0,-1"/>
1402- <blockBackground colorName="#ffcc99" start="1,0" stop="1,-1"/>
1403- <blockBackground colorName="#ffcc99" start="2,0" stop="2,-1"/>
1404- <blockBackground colorName="#ffcc99" start="3,0" stop="3,-1"/>
1405- <blockBackground colorName="#ffcc99" start="4,0" stop="4,-1"/>
1406- <blockBackground colorName="#ffcc99" start="5,0" stop="5,-1"/>
1407- <blockBackground colorName="#ffcc99" start="6,0" stop="6,-1"/>
1408- <blockBackground colorName="#ffcc99" start="7,0" stop="7,-1"/>
1409- <blockBackground colorName="#ffffff" start="0,1" stop="0,-1"/>
1410- <blockBackground colorName="#ffffff" start="1,1" stop="1,-1"/>
1411- <blockBackground colorName="#ffffff" start="2,1" stop="2,-1"/>
1412- <blockBackground colorName="#ffffff" start="3,1" stop="3,-1"/>
1413- <blockBackground colorName="#ffffff" start="4,1" stop="4,-1"/>
1414- <blockBackground colorName="#ffffff" start="5,1" stop="5,-1"/>
1415- <blockBackground colorName="#ffffff" start="6,1" stop="6,-1"/>
1416- <blockBackground colorName="#ffffff" start="7,1" stop="7,-1"/>
1417- </blockTableStyle>
1418- <initialize>
1419- <paraStyle name="all" alignment="justify"/>
1420- </initialize>
1421- <paraStyle name="P1" fontName="Times-Roman" alignment="RIGHT"/>
1422- <paraStyle name="P2" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
1423- <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
1424- <paraStyle name="P4" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
1425- <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
1426- <paraStyle name="P6" rightIndent="0.0" leftIndent="71.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
1427- <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
1428- <paraStyle name="P8" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
1429- <paraStyle name="P9" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
1430- <paraStyle name="P10" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
1431- <paraStyle name="P11" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
1432- <paraStyle name="P12" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
1433- <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
1434- <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
1435- <paraStyle name="P15" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT"/>
1436- <paraStyle name="P16" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
1437- <paraStyle name="P17" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
1438- <paraStyle name="Standard" fontName="Times-Roman"/>
1439- <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
1440- <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
1441- <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
1442- <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
1443- <paraStyle name="Index" fontName="Times-Roman"/>
1444- <paraStyle name="Table Contents" fontName="Times-Roman"/>
1445- <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
1446- <paraStyle name="Footer" fontName="Times-Roman"/>
1447- <paraStyle name="MP1" fontName="Times-Roman" alignment="RIGHT"/>
1448- </stylesheet>
1449- <images/>
1450- <story>
1451- <para style="P2">[[ repeatIn(objects, 'o') ]]</para>
1452- <blockTable colWidths="249.0,249.0" style="Table1">
1453- <tr>
1454- <td>
1455- <para style="P10">
1456- <font face="Times-Roman" size="10.0">[[ get_company(o) ]]</font>
1457- </para>
1458- </td>
1459- <td>
1460- <para style="P16">
1461- <font face="Times-Roman">REGISTRO IVA </font>
1462- </para>
1463- <para style="P16">
1464- <font face="Times-Roman">VENDITE </font>
1465- </para>
1466- </td>
1467- </tr>
1468- </blockTable>
1469- <para style="P2">
1470- <font color="white"> </font>
1471- </para>
1472- <para style="P11">[[ o.name ]] </para>
1473- <para style="P2">
1474- <font color="white"> </font>
1475- </para>
1476- <blockTable colWidths="39.0,50.0,92.0,45.0,54.0,76.0,69.0,74.0" repeatRows="1" style="Table2">
1477- <tr>
1478- <td>
1479- <para style="P7">Periodo</para>
1480- </td>
1481- <td>
1482- <para style="P7">Protocollo</para>
1483- </td>
1484- <td>
1485- <para style="P7">Cliente</para>
1486- </td>
1487- <td>
1488- <para style="P7">Numero</para>
1489- </td>
1490- <td>
1491- <para style="P7">Data fattura</para>
1492- </td>
1493- <td>
1494- <para style="P7">Aliquota</para>
1495- </td>
1496- <td>
1497- <para style="P7">Imponibile</para>
1498- </td>
1499- <td>
1500- <para style="P7">Imposta</para>
1501- </td>
1502- </tr>
1503- <tr>
1504- <td>
1505- <para style="P3">[[ repeatIn(get_lines(o), 'line') ]]</para>
1506- <para style="P3">[[ line['periodo'] ]]</para>
1507- </td>
1508- <td>
1509- <para style="P3">[[ line['protocollo'] ]]</para>
1510- </td>
1511- <td>
1512- <para style="P3">[[ line['causale'] ]]</para>
1513- </td>
1514- <td>
1515- <para style="P3">[[ line['numero'] ]]</para>
1516- </td>
1517- <td>
1518- <para style="P3">[[ line['data_doc'] ]]</para>
1519- </td>
1520- <td>
1521- <para style="P14">[[ line['aliquota'] ]]</para>
1522- </td>
1523- <td>
1524- <para style="P15">[[ line['imponibile'] ]]</para>
1525- </td>
1526- <td>
1527- <para style="P15">[[ line['imposta'] ]]</para>
1528- </td>
1529- </tr>
1530- </blockTable>
1531- <para style="P9">
1532- <font color="white"> </font>
1533- </para>
1534- <para style="P4">
1535- <font color="white"> </font>
1536- </para>
1537- <para style="P4">
1538- <font color="white"> </font>
1539- </para>
1540- </story>
1541-</document>
1542-
1543
1544=== removed file 'l10n_it/report/libroIVA_credito.sxw'
1545Binary files l10n_it/report/libroIVA_credito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_credito.sxw 1970-01-01 00:00:00 +0000 differ
1546=== removed file 'l10n_it/report/libroIVA_debito.py'
1547--- l10n_it/report/libroIVA_debito.py 2011-01-14 00:11:01 +0000
1548+++ l10n_it/report/libroIVA_debito.py 1970-01-01 00:00:00 +0000
1549@@ -1,80 +0,0 @@
1550-import datetime
1551-import time
1552-from report import report_sxw
1553-from osv import osv
1554-import pooler
1555-
1556-
1557-class l10n_chart_it_report_libroIVA_debito(report_sxw.rml_parse):
1558-
1559- def __init__(self, cr, uid, name, context):
1560- super(l10n_chart_it_report_libroIVA_debito,self).__init__(cr,uid,name,context)
1561- self.localcontext.update({
1562- 'time' : time,
1563- 'get_company' : self.get_company,
1564- 'get_periods' : self.get_periods,
1565- 'get_lines' : self.get_lines,
1566- })
1567-
1568-
1569- def get_company(self,fiscal_year):
1570- #print 'COMP = ',fiscal_year
1571- return ""
1572-
1573-
1574- def get_periods(self,fiscal_year):
1575- #print 'Fiscal year id:',fiscal_year.id
1576- obj=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
1577- fy=obj.browse(self.cr,self.uid,fiscal_year.id)
1578- #print 'Periods = ',fy.period_ids
1579- res=[rec for rec in fy.period_ids]
1580- #return fy.periods => non funziona?!? bool object !?!?
1581- return res
1582-
1583- def get_invoices(self,period):
1584- #print 'PERIOD = ',period.name
1585- obj=pooler.get_pool(self.cr.dbname).get('account.invoice')
1586- # Selezione tutte le fatture emesse nel periodo
1587- self.cr.execute( """
1588- SELECT id FROM account_invoice
1589- WHERE (state='open' OR state='paid') AND
1590- period_id="""+str(period.id)+"""
1591- AND (type='in_invoice' OR type='in_refund')
1592- """)
1593- ids=self.cr.fetchall()
1594- #print 'IDS = ',
1595- if ids:
1596- ids=[id[0] for id in ids ]
1597- invoices=obj.browse(self.cr,self.uid,ids)
1598- #print 'INVOICES = ',invoices
1599- return invoices
1600-
1601- def get_lines(self,fiscal_year):
1602- res=[]
1603- obj_fy=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
1604- fy=obj_fy.browse(self.cr,self.uid,fiscal_year.id)
1605- for period in fy.period_ids:
1606- invoices=self.get_invoices(period)
1607- for invoice in invoices:
1608- d={'periodo': period.name}
1609- d['protocollo']=invoice.number
1610- #print 'PARTNER ',invoice.partner_id.name
1611- causale=invoice.partner_id.name
1612- #print 'CAUSALE = ',causale
1613- d['causale']=causale
1614- d['numero']=invoice.reference
1615- d['data_doc']=invoice.date_invoice
1616- for tax in invoice.tax_line:
1617- #print '\tTAX: ',tax
1618- d['aliquota']=tax.tax_code_id.name
1619- d['imponibile']=tax.base
1620- d['imposta']=tax.amount
1621- res.append(d)
1622- d={'periodo':'', 'protocollo':'', 'causale':'', 'numero':'', 'data_doc':'', }
1623- return res
1624-
1625-
1626-
1627-report_sxw.report_sxw('report.l10n_it.report.libroIVA_debito','account.report_libroiva',
1628- 'l10n_it/report/libroIVA_debito.rml',
1629- parser=l10n_chart_it_report_libroIVA_debito,header=False)
1630
1631=== removed file 'l10n_it/report/libroIVA_debito.rml'
1632--- l10n_it/report/libroIVA_debito.rml 2011-01-14 00:11:01 +0000
1633+++ l10n_it/report/libroIVA_debito.rml 1970-01-01 00:00:00 +0000
1634@@ -1,195 +0,0 @@
1635-<?xml version="1.0"?>
1636-<document filename="test.pdf">
1637- <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
1638- <pageTemplate id="first">
1639- <frame id="first" x1="57.0" y1="57.0" width="498" height="678"/>
1640- </pageTemplate>
1641- </template>
1642- <stylesheet>
1643- <blockTableStyle id="Standard_Outline">
1644- <blockAlignment value="LEFT"/>
1645- <blockValign value="TOP"/>
1646- </blockTableStyle>
1647- <blockTableStyle id="Table2">
1648- <blockAlignment value="LEFT"/>
1649- <blockValign value="TOP"/>
1650- </blockTableStyle>
1651- <blockTableStyle id="Table1">
1652- <blockAlignment value="LEFT"/>
1653- <blockValign value="TOP"/>
1654- <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
1655- <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
1656- <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
1657- <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
1658- <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
1659- <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
1660- <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
1661- <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
1662- <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
1663- <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
1664- <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
1665- <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
1666- <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
1667- <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
1668- <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
1669- <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
1670- <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
1671- <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
1672- <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,0" stop="6,-1"/>
1673- <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
1674- <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
1675- <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,0" stop="7,-1"/>
1676- <lineStyle kind="LINEAFTER" colorName="#000000" start="7,0" stop="7,-1"/>
1677- <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
1678- <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
1679- <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
1680- <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
1681- <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
1682- <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
1683- <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
1684- <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
1685- <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
1686- <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
1687- <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
1688- <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
1689- <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,1" stop="5,-1"/>
1690- <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
1691- <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,1" stop="6,-1"/>
1692- <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
1693- <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,1" stop="7,-1"/>
1694- <lineStyle kind="LINEAFTER" colorName="#000000" start="7,1" stop="7,-1"/>
1695- <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
1696- <blockBackground colorName="#ffcc99" start="0,0" stop="0,-1"/>
1697- <blockBackground colorName="#ffcc99" start="1,0" stop="1,-1"/>
1698- <blockBackground colorName="#ffcc99" start="2,0" stop="2,-1"/>
1699- <blockBackground colorName="#ffcc99" start="3,0" stop="3,-1"/>
1700- <blockBackground colorName="#ffcc99" start="4,0" stop="4,-1"/>
1701- <blockBackground colorName="#ffcc99" start="5,0" stop="5,-1"/>
1702- <blockBackground colorName="#ffcc99" start="6,0" stop="6,-1"/>
1703- <blockBackground colorName="#ffcc99" start="7,0" stop="7,-1"/>
1704- <blockBackground colorName="#ffffff" start="0,1" stop="0,-1"/>
1705- <blockBackground colorName="#ffffff" start="1,1" stop="1,-1"/>
1706- <blockBackground colorName="#ffffff" start="2,1" stop="2,-1"/>
1707- <blockBackground colorName="#ffffff" start="3,1" stop="3,-1"/>
1708- <blockBackground colorName="#ffffff" start="4,1" stop="4,-1"/>
1709- <blockBackground colorName="#ffffff" start="5,1" stop="5,-1"/>
1710- <blockBackground colorName="#ffffff" start="6,1" stop="6,-1"/>
1711- <blockBackground colorName="#ffffff" start="7,1" stop="7,-1"/>
1712- </blockTableStyle>
1713- <initialize>
1714- <paraStyle name="all" alignment="justify"/>
1715- </initialize>
1716- <paraStyle name="P1" fontName="Times-Roman" alignment="RIGHT"/>
1717- <paraStyle name="P2" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
1718- <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
1719- <paraStyle name="P4" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT"/>
1720- <paraStyle name="P5" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
1721- <paraStyle name="P6" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
1722- <paraStyle name="P7" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
1723- <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
1724- <paraStyle name="P9" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
1725- <paraStyle name="P10" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
1726- <paraStyle name="P11" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
1727- <paraStyle name="P12" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
1728- <paraStyle name="Standard" fontName="Times-Roman"/>
1729- <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
1730- <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
1731- <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
1732- <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
1733- <paraStyle name="Index" fontName="Times-Roman"/>
1734- <paraStyle name="Table Contents" fontName="Times-Roman"/>
1735- <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
1736- <paraStyle name="Footer" fontName="Times-Roman"/>
1737- <paraStyle name="MP1" fontName="Times-Roman" alignment="RIGHT"/>
1738- </stylesheet>
1739- <images/>
1740- <story>
1741- <para style="P7">[[ repeatIn(objects, 'o') ]]</para>
1742- <blockTable colWidths="249.0,249.0" style="Table2">
1743- <tr>
1744- <td>
1745- <para style="P10">
1746- <font face="Times-Roman" size="10.0">[[ get_company(o) ]]</font>
1747- </para>
1748- </td>
1749- <td>
1750- <para style="P12">
1751- <font face="Times-Roman">REGISTRO IVA</font>
1752- </para>
1753- <para style="P12">
1754- <font face="Times-Roman">ACQUISTI</font>
1755- </para>
1756- </td>
1757- </tr>
1758- </blockTable>
1759- <para style="P7">
1760- <font color="white"> </font>
1761- </para>
1762- <para style="P11">[[ o.name ]] </para>
1763- <para style="P7">
1764- <font color="white"> </font>
1765- </para>
1766- <blockTable colWidths="39.0,50.0,92.0,45.0,54.0,76.0,69.0,74.0" repeatRows="1" style="Table1">
1767- <tr>
1768- <td>
1769- <para style="P8">Periodo</para>
1770- </td>
1771- <td>
1772- <para style="P8">Protocollo</para>
1773- </td>
1774- <td>
1775- <para style="P8">Fornitore</para>
1776- </td>
1777- <td>
1778- <para style="P8">Numero</para>
1779- </td>
1780- <td>
1781- <para style="P8">Data fattura</para>
1782- </td>
1783- <td>
1784- <para style="P8">Aliquota</para>
1785- </td>
1786- <td>
1787- <para style="P8">Imponibile</para>
1788- </td>
1789- <td>
1790- <para style="P8">Imposta</para>
1791- </td>
1792- </tr>
1793- <tr>
1794- <td>
1795- <para style="P2">[[ repeatIn(get_lines(o), 'line') ]]</para>
1796- <para style="P2">[[ line['periodo'] ]]</para>
1797- </td>
1798- <td>
1799- <para style="P2">[[ line['protocollo'] ]]</para>
1800- </td>
1801- <td>
1802- <para style="P2">[[ line['causale'] ]]</para>
1803- </td>
1804- <td>
1805- <para style="P2">[[ line['numero'] ]]</para>
1806- </td>
1807- <td>
1808- <para style="P2">[[ line['data_doc'] ]]</para>
1809- </td>
1810- <td>
1811- <para style="P3">[[ line['aliquota'] ]]</para>
1812- </td>
1813- <td>
1814- <para style="P4">[[ line['imponibile'] ]]</para>
1815- </td>
1816- <td>
1817- <para style="P4">[[ line['imposta'] ]]</para>
1818- </td>
1819- </tr>
1820- </blockTable>
1821- <para style="P5">
1822- <font color="white"> </font>
1823- </para>
1824- <para style="P6">
1825- <font color="white"> </font>
1826- </para>
1827- </story>
1828-</document>
1829-
1830
1831=== removed file 'l10n_it/report/libroIVA_debito.sxw'
1832Binary files l10n_it/report/libroIVA_debito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_debito.sxw 1970-01-01 00:00:00 +0000 differ
1833=== removed file 'l10n_it/report/normalized_oo2rml.xsl'
1834--- l10n_it/report/normalized_oo2rml.xsl 2011-01-14 00:11:01 +0000
1835+++ l10n_it/report/normalized_oo2rml.xsl 1970-01-01 00:00:00 +0000
1836@@ -1,696 +0,0 @@
1837-<?xml version="1.0" encoding="utf-8"?>
1838-<xsl:stylesheet
1839- version="1.0"
1840- xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
1841- xmlns:fo="http://www.w3.org/1999/XSL/Format"
1842- xmlns:office="http://openoffice.org/2000/office"
1843- xmlns:style="http://openoffice.org/2000/style"
1844- xmlns:text="http://openoffice.org/2000/text"
1845- xmlns:table="http://openoffice.org/2000/table"
1846- xmlns:draw="http://openoffice.org/2000/drawing"
1847- xmlns:xlink="http://www.w3.org/1999/xlink"
1848- xmlns:number="http://openoffice.org/2000/datastyle"
1849- xmlns:svg="http://www.w3.org/2000/svg"
1850- xmlns:chart="http://openoffice.org/2000/chart"
1851- xmlns:dr3d="http://openoffice.org/2000/dr3d"
1852- xmlns:math="http://www.w3.org/1998/Math/MathML"
1853- xmlns:form="http://openoffice.org/2000/form"
1854- xmlns:script="http://openoffice.org/2000/script"
1855- office:class="text" office:version="1.0"
1856- exclude-result-prefixes = "xsl fo office style text table draw xlink number svg chart dr3d math form script">
1857-
1858- <!--TODO's: indent, picture cache (trml2pdf) -->
1859-
1860-<xsl:output method="xml" indent="yes" />
1861-<xsl:strip-space elements="*"/>
1862-
1863-<xsl:key name="text_style" match="style:style[@style:family='text']" use="@style:name" />
1864-<xsl:key name="page_break_before" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-before='page']" use="@style:name" />
1865-<xsl:key name="page_break_after" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-after='page']" use="@style:name" />
1866-<xsl:key name="table_column_style" match="style:style[@style:family='table-column']" use="@style:name" />
1867-<xsl:key name="table_cell_style" match="style:style[@style:family='table-cell']" use="@style:name" />
1868-<xsl:key name="paragraph_style" match="style:style[@style:family='paragraph']" use="@style:name" />
1869-
1870-<xsl:template match="office:document-content">
1871- <document filename="test.pdf">
1872- <xsl:apply-templates select="office:automatic-styles" />
1873- <xsl:apply-templates select="office:body" />
1874- </document>
1875-</xsl:template>
1876-
1877-<xsl:template name="page_size">
1878- <xsl:attribute name="pageSize">
1879- <xsl:text>(</xsl:text>
1880- <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
1881- <xsl:text>,</xsl:text>
1882- <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
1883- <xsl:text>)</xsl:text>
1884- </xsl:attribute>
1885-</xsl:template>
1886-
1887-<xsl:template name="fixed_frame">
1888- <xsl:for-each select="//draw:text-box">
1889- <frame>
1890- <xsl:attribute name="id"><xsl:value-of select="./@draw:name" /></xsl:attribute>
1891- <xsl:attribute name="x1"><xsl:value-of select="./@svg:x" /></xsl:attribute>
1892- <xsl:attribute name="y1">
1893- <xsl:value-of
1894- select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height - ./@svg:y - ./@fo:min-height" />
1895- </xsl:attribute>
1896- <xsl:attribute name="width">
1897- <xsl:value-of select="./@svg:width" />
1898- </xsl:attribute>
1899- <xsl:attribute name="height">
1900- <xsl:value-of select="./@fo:min-height" />
1901- </xsl:attribute>
1902- </frame>
1903- </xsl:for-each>
1904-</xsl:template>
1905-
1906-<xsl:template name="margin_sizes">
1907- <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
1908- <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
1909- <xsl:variable name="margin_top" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-top" />
1910- <xsl:variable name="margin_bottom" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-bottom" />
1911- <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
1912- <xsl:variable name="page_height" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
1913- <xsl:attribute name="x1"><xsl:value-of select="$margin_left" /></xsl:attribute>
1914- <xsl:attribute name="y1"><xsl:value-of select="$margin_bottom" /></xsl:attribute>
1915- <xsl:attribute name="width"><xsl:value-of select="$page_width - $margin_left - $margin_right"/></xsl:attribute>
1916- <xsl:attribute name="height"><xsl:value-of select="$page_height - $margin_bottom - $margin_top"/></xsl:attribute>
1917-</xsl:template>
1918-
1919-<xsl:template name="text_width">
1920- <!-- You need this for the workaround to make primitive outlines-->
1921- <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
1922- <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
1923- <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
1924- <xsl:value-of select="$page_width - $margin_left - $margin_right - 18"/>
1925-</xsl:template>
1926-
1927-
1928-
1929-<xsl:template match="office:automatic-styles">
1930- <!--<template pageSize="(21cm, 29.7cm)" leftMargin="1.0cm" rightMargin="2.0cm" topMargin="1.0cm" bottomMargin="1.0cm" title="Test" author="Martin Simon" allowSplitting="20">-->
1931- <template pageSize="(21cm, 29.7cm)" title="Test" author="Martin Simon" allowSplitting="20">
1932- <xsl:call-template name="page_size" />
1933- <pageTemplate id="first">
1934- <xsl:call-template name="fixed_frame" />
1935- <frame id="first" x1="2cm" y1="2cm" width="17cm" height="26cm">
1936- <xsl:call-template name="margin_sizes" />
1937- </frame>
1938- </pageTemplate>
1939- </template>
1940- <stylesheet>
1941- <!--A table style to simulate primitive outlines -till the <addOutline> tag is implemented in trml2pdf -->
1942- <blockTableStyle id="Standard_Outline">
1943- <blockAlignment value="LEFT"/>
1944- <blockValign value="TOP"/>
1945- </blockTableStyle>
1946- <!--use two standard table grid styles like PyOpenOffice "Old Way": with and without a grid-->
1947- <!--TODO insert table cell colors here, not within the <td> tag - otherwise
1948- it will not work with flowables as cell content-->
1949- <xsl:call-template name="make_blocktablestyle" />
1950- <initialize>
1951- <paraStyle name="all" alignment="justify" />
1952- </initialize>
1953- <xsl:apply-templates select="style:style" />
1954- </stylesheet>
1955-</xsl:template>
1956-
1957-<xsl:template name="make_blocktablestyle">
1958- <xsl:for-each select="//table:table">
1959- <xsl:variable name="test">
1960- <xsl:value-of select="./@table:name" />
1961- </xsl:variable>
1962- <xsl:if test="not(boolean(count(preceding-sibling::table:table[@table:name=$test])))">
1963- <!--Test if this is the first table with this style, nested tables not counted-->
1964- <blockTableStyle id="{@table:name}">
1965- <xsl:if test=".//draw:image">
1966- <blockTopPadding value="0"/>
1967- <blockBottomPadding value="0"/>
1968- </xsl:if>
1969- <blockAlignment value="LEFT" />
1970- <blockValign value="TOP" />
1971- <xsl:call-template name="make_linestyle" />
1972- <xsl:call-template name="make_tablebackground" />
1973- </blockTableStyle>
1974- </xsl:if>
1975- </xsl:for-each>
1976-</xsl:template>
1977-
1978-<xsl:template name="make_linestyle">
1979- <xsl:for-each select=".//table:table-row">
1980- <xsl:variable name="row" select="position() - 1"/>
1981- <xsl:for-each select=".//table:table-cell">
1982- <xsl:variable name="col" select="position() - 1"/>
1983- <xsl:variable name="linebefore">
1984- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-left"/>
1985- </xsl:variable>
1986- <xsl:if test="not($linebefore='') and not($linebefore='none')">
1987- <xsl:variable name="colorname">
1988- <xsl:value-of select="substring-after($linebefore,'#')"/>
1989- </xsl:variable>
1990- <lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
1991- </xsl:if>
1992- <xsl:variable name="lineafter">
1993- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-right"/>
1994- </xsl:variable>
1995- <xsl:if test="not($lineafter='') and not($lineafter='none')">
1996- <xsl:variable name="colorname">
1997- <xsl:value-of select="substring-after($lineafter,'#')"/>
1998- </xsl:variable>
1999- <lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
2000- </xsl:if>
2001- <xsl:variable name="lineabove">
2002- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-top"/>
2003- </xsl:variable>
2004- <xsl:if test="not($lineabove='') and not($lineabove='none')">
2005- <xsl:variable name="colorname">
2006- <xsl:value-of select="substring-after($lineabove,'#')"/>
2007- </xsl:variable>
2008- <lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
2009- </xsl:if>
2010- <xsl:variable name="linebelow">
2011- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-bottom"/>
2012- </xsl:variable>
2013- <xsl:if test="not($linebelow='') and not($linebelow='none')">
2014- <xsl:variable name="colorname">
2015- <xsl:value-of select="substring-after($linebelow,'#')"/>
2016- </xsl:variable>
2017- <lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
2018- </xsl:if>
2019- <xsl:variable name="grid">
2020- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border"/>
2021- </xsl:variable>
2022- <xsl:if test="not($grid='') and not($grid='none')">
2023- <xsl:variable name="colorname">
2024- <xsl:value-of select="substring-after($grid,'#')"/>
2025- </xsl:variable>
2026- <!-- Don't use grid because we don't need a line between each rows -->
2027- <lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
2028- <lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
2029- <lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
2030- <lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
2031- </xsl:if>
2032- </xsl:for-each>
2033- </xsl:for-each>
2034-</xsl:template>
2035-
2036-<!-- Was needed to simulate bulleted lists:
2037-<xsl:template match="text:ordered-list|text:unordered-list">
2038- <xsl:variable name = "text_width">
2039- <xsl:call-template name="text_width" />
2040- </xsl:variable>
2041- <blockTable style="Standard_Outline" colWidths="18,{$text_width}">
2042- <xsl:apply-templates match="text:list-item" />
2043-</blockTable>
2044-</xsl:template>
2045-
2046-<xsl:template match="text:list-item">
2047- <tr>
2048- <td><para><font face="Helvetica-Bold" size="10">*</font></para></td>
2049- <td>
2050- <xsl:apply-templates />
2051- </td>
2052- </tr>
2053-</xsl:template>
2054-
2055--->
2056-
2057-
2058-<xsl:template match="office:body">
2059- <story>
2060- <xsl:apply-templates />
2061- <xsl:for-each select="//draw:text-box">
2062- <currentFrame>
2063- <xsl:attribute name="name">
2064- <xsl:value-of select="./@draw:name" />
2065- </xsl:attribute>
2066- </currentFrame>
2067- <xsl:apply-templates>
2068- <xsl:with-param name="skip_draw" select="0" />
2069- </xsl:apply-templates>
2070- <frameEnd />
2071- </xsl:for-each>
2072- <xsl:for-each select="//text:ordered-list">
2073- <para><seqReset id="{//text:ordered-list/@text:style-name}"/></para>
2074- </xsl:for-each>
2075- </story>
2076-</xsl:template>
2077-
2078-<xsl:template match="table:table">
2079- <blockTable>
2080- <xsl:attribute name="colWidths">
2081- <xsl:call-template name="make_columns" />
2082- </xsl:attribute>
2083- <xsl:call-template name="make_tableheaders" />
2084- <xsl:attribute name="style">
2085- <xsl:value-of select="@table:name" />
2086- </xsl:attribute>
2087- <xsl:apply-templates />
2088- </blockTable>
2089-</xsl:template>
2090-
2091-<xsl:template name="make_tableheaders">
2092- <xsl:if test="boolean(count(table:table-header-rows))">
2093- <xsl:attribute name="repeatRows">1</xsl:attribute>
2094- </xsl:if>
2095-</xsl:template>
2096-
2097-<xsl:template name="make_tablebackground">
2098- <xsl:for-each select=".//table:table-row">
2099- <!--Be careful when there are table:table-header-rows as
2100- parent node of table:table-row -->
2101- <xsl:variable name="row" select="position() - 1" />
2102- <xsl:for-each select="./table:table-cell">
2103- <xsl:variable name="col" select="position() - 1" />
2104- <xsl:variable name="background">
2105- <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:background-color" />
2106- </xsl:variable>
2107- <xsl:if test="not($background='') and boolean(key('table_cell_style',@table:style-name)/style:properties/@fo:background-color) and starts-with($background,'#')">
2108- <!--only RGB hexcolors are accepted -->
2109- <blockBackground colorName="{$background}" start="{$col},{$row}" stop="{$col},-1" />
2110- </xsl:if>
2111- </xsl:for-each>
2112- </xsl:for-each>
2113-</xsl:template>
2114-
2115-<xsl:template name="make_columns">
2116- <xsl:variable name="columns" >
2117- <xsl:for-each select="table:table-column">
2118- <xsl:value-of select="key('table_column_style',@table:style-name)/style:properties/@style:column-width" />
2119- <xsl:text>,</xsl:text>
2120- </xsl:for-each>
2121- </xsl:variable>
2122- <xsl:value-of select="substring($columns,1,string-length($columns) - 1)" />
2123- <!--strip the last comma-->
2124-</xsl:template>
2125-
2126-<xsl:template match="table:table-row">
2127- <tr>
2128- <xsl:apply-templates />
2129- </tr>
2130-</xsl:template>
2131-
2132-<xsl:template match="table:table-cell">
2133- <td>
2134- <xsl:apply-templates />
2135- </td>
2136-</xsl:template>
2137-
2138-<xsl:template match="text:section">
2139- <section>
2140- <xsl:apply-templates />
2141- </section>
2142-</xsl:template>
2143-
2144-
2145-<xsl:template match="text:span">
2146- <font>
2147- <xsl:call-template name="make_fontnames_span" />
2148- <xsl:call-template name="make_fontsize_span" />
2149- <xsl:apply-templates />
2150- </font>
2151-</xsl:template>
2152-
2153-<xsl:template name="make_fontsize_span">
2154- <xsl:variable name ="fontsize">
2155- <xsl:value-of select="key('text_style',@text:style-name)/style:properties/@fo:font-size" />
2156- </xsl:variable>
2157- <xsl:if test="not($fontsize='') and boolean(key('text_style',@text:style-name)/style:properties/@fo:font-size)" >
2158- <xsl:attribute name="size">
2159- <xsl:value-of select="$fontsize" />
2160- </xsl:attribute>
2161- </xsl:if>
2162-</xsl:template>
2163-
2164-<xsl:template name="make_fontnames_span">
2165- <xsl:attribute name="face">
2166- <xsl:call-template name="make_fontnames">
2167- <xsl:with-param name="fontName" select="key('text_style',@text:style-name)/style:properties/@style:font-name" />
2168- <xsl:with-param name="fontWeight" select="key('text_style',@text:style-name)/style:properties/@fo:font-weight" />
2169- <xsl:with-param name="fontStyle" select="key('text_style',@text:style-name)/style:properties/@fo:font-style" />
2170- </xsl:call-template>
2171- </xsl:attribute>
2172-</xsl:template>
2173-
2174-<xsl:template name="make_image">
2175- <illustration height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}">
2176- <image x="0" y="0" file="{substring-after(.//draw:image/@xlink:href,'#Pictures/')}" height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}" />
2177- </illustration>
2178-</xsl:template>
2179-
2180-<xsl:template name="empty_paragraph">
2181- <xsl:if test="not(boolean(count(descendant::node())))">
2182- <xsl:call-template name="distance_point">
2183- <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
2184- </xsl:call-template>
2185- </xsl:if>
2186-</xsl:template>
2187-
2188-<xsl:template name="distance_point">
2189- <xsl:param name="background" />
2190- <xsl:param name="tab_stop"></xsl:param>
2191- <xsl:variable name="local_back">
2192- <xsl:choose>
2193- <xsl:when test="not(boolean($background)) or not(contains($background,'#'))">
2194- <!-- Do not accept OO colors like "transparent", only hex-colors -->
2195- <xsl:text>white</xsl:text>
2196- </xsl:when>
2197- <xsl:otherwise>
2198- <xsl:value-of select="$background" />
2199- </xsl:otherwise>
2200- </xsl:choose>
2201- </xsl:variable>
2202- <font color="{$local_back}">
2203- <xsl:text> </xsl:text>
2204- <xsl:if test="boolean($tab_stop)">
2205- <!-- simulate a tabstop with white/background-color points -->
2206- <xsl:text>.........</xsl:text>
2207- </xsl:if>
2208- </font>
2209-</xsl:template>
2210-
2211-<xsl:template match="text:ordered-list">
2212- <xsl:apply-templates />
2213-
2214- <!-- Reset the counter. seqreset is not a trml2pdf tag, but a Platypus Intra Paragraph Markup,
2215- so it needs a dummy paragraph to enclose it -->
2216-</xsl:template>
2217-
2218-<xsl:template name="make_listitem">
2219- <xsl:if test="(name(..)='text:list-item')">
2220- <xsl:attribute name="leftIndent">15</xsl:attribute>
2221- <xsl:attribute name="bulletIndent">0</xsl:attribute>
2222- <xsl:choose>
2223- <xsl:when test="(name(../..)='text:unordered-list')">
2224- <xsl:variable name="fontsize">
2225- <xsl:value-of select="number(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)" />
2226- </xsl:variable>
2227- <xsl:choose>
2228- <xsl:when test="$fontsize='NaN'">
2229- <!-- you should exclude non-numerical values for bulletFontSize. <== Sometimes the preprocessing went wrong.-->
2230- <!--use a default bullet font size-->
2231- <xsl:attribute name="bulletFontSize">6</xsl:attribute>
2232- </xsl:when>
2233- <xsl:otherwise>
2234- <xsl:attribute name="bulletFontSize"><xsl:value-of select="floor(($fontsize div 2) + 1)" /></xsl:attribute>
2235- </xsl:otherwise>
2236- </xsl:choose>
2237- <xsl:attribute name="bulletFontName">ZapfDingbats</xsl:attribute>
2238- <xsl:attribute name="bulletText">l</xsl:attribute>
2239- </xsl:when>
2240- <xsl:otherwise>
2241- <!-- Generate the numbers for an ordered list -->
2242- <xsl:variable name="size">
2243- <xsl:value-of select="key('paragraph_style',@text:style-name)/style:properties/@fo:font-size" />
2244- </xsl:variable>
2245- <!-- For ordered lists we use the bullet tag from Platypus Intra Paragraph Markup -->
2246- <bullet>
2247- <xsl:if test="not($size='') and boolean(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)">
2248- <xsl:attribute name="size">
2249- <!-- adapt the fontsize to the fontsize of the current paragraph -->
2250- <xsl:value-of select="$size" />
2251- </xsl:attribute>
2252- </xsl:if>
2253- <seq id="{../../@text:style-name}"/>.</bullet>
2254-
2255- </xsl:otherwise>
2256- </xsl:choose>
2257- </xsl:if>
2258-</xsl:template>
2259-
2260-<xsl:template match="text:drop-down">
2261- <xsl:value-of select="text:label[2]/@text:value" />
2262-</xsl:template>
2263-
2264-
2265-<xsl:template match="text:p|text:h">
2266- <xsl:param name="skip_draw" select="1" />
2267- <xsl:if test="boolean(key('page_break_before',@text:style-name))" >
2268- <pageBreak />
2269- </xsl:if>
2270- <xsl:choose>
2271- <xsl:when test="boolean(.//draw:image)">
2272- <xsl:call-template name="make_image" />
2273- </xsl:when>
2274- <xsl:when test="boolean(name(..) = 'draw:text-box') and boolean($skip_draw)">
2275- </xsl:when>
2276- <xsl:otherwise>
2277- <para>
2278- <xsl:attribute name="style">
2279- <xsl:value-of select="@text:style-name" />
2280- </xsl:attribute>
2281- <xsl:call-template name="make_listitem" />
2282- <xsl:apply-templates />
2283- <xsl:call-template name="empty_paragraph" />
2284- </para>
2285- </xsl:otherwise>
2286- </xsl:choose>
2287- <xsl:if test="boolean(key('page_break_after',@text:style-name))" >
2288- <pageBreak />
2289- </xsl:if>
2290-</xsl:template>
2291-
2292-<xsl:template match="text:p/text:tab-stop">
2293- <!-- simulate a tabstop -->
2294- <xsl:call-template name="distance_point">
2295- <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
2296- <xsl:with-param name="tab_stop">yes</xsl:with-param>
2297- </xsl:call-template>
2298-</xsl:template>
2299-
2300-<!-- experimental - switched off
2301-<xsl:template match="text:h">
2302- <para>
2303- <xsl:attribute name="style">
2304- <xsl:value-of select="@text:style-name" />
2305- </xsl:attribute>
2306- <xsl:call-template name="make_number" />
2307- <xsl:apply-templates />
2308- <xsl:call-template name="empty_paragraph" />
2309- </para>
2310-</xsl:template>
2311-
2312-<xsl:template name="make_number">
2313- <xsl:choose>
2314- <xsl:when test="@text:level='1'">
2315- <xsl:number format="1. " />
2316- </xsl:when>
2317- <xsl:when test="@text:level='2'">
2318- <xsl:number count="text:h[@text:level='1']|text:h[text:level='2']" level="any" format="1.1." />
2319- </xsl:when>
2320- </xsl:choose>
2321-</xsl:template>
2322-
2323--->
2324-
2325-<xsl:template match="style:style[@style:family='paragraph']">
2326- <paraStyle>
2327- <xsl:attribute name="name">
2328- <xsl:value-of select="@style:name" />
2329- </xsl:attribute>
2330- <xsl:call-template name="make_indent_paragraph" />
2331- <xsl:call-template name="make_fontnames_paragraph" />
2332- <xsl:call-template name="make_fontsize" />
2333- <!--<xsl:call-template name="make_parent" /> not necessary -
2334- parent styles processed by PyOpenOffice -->
2335- <xsl:call-template name="make_alignment" />
2336- <xsl:call-template name="make_background" />
2337- <xsl:call-template name="make_space_beforeafter" />
2338- <xsl:call-template name="make_fontcolor" />
2339- </paraStyle>
2340-</xsl:template>
2341-
2342-<xsl:template name="make_indent_paragraph">
2343- <xsl:variable name="right_indent"><xsl:value-of select="style:properties/@fo:margin-right" /></xsl:variable>
2344- <xsl:variable name="left_indent"><xsl:value-of select="style:properties/@fo:margin-left" /></xsl:variable>
2345- <xsl:if test="not($right_indent='') and boolean(style:properties/@fo:margin-right)">
2346- <xsl:attribute name="rightIndent">
2347- <xsl:value-of select="$right_indent" />
2348- </xsl:attribute>
2349- </xsl:if>
2350- <xsl:if test="not($left_indent='') and boolean(style:properties/@fo:margin-left)">
2351- <xsl:attribute name="leftIndent">
2352- <xsl:value-of select="$left_indent" />
2353- </xsl:attribute>
2354- </xsl:if>
2355-</xsl:template>
2356-
2357-<xsl:template name="make_background">
2358- <xsl:variable name="background">
2359- <xsl:value-of select="style:properties/@fo:background-color" />
2360- </xsl:variable>
2361- <xsl:if test="not($background='') and boolean(style:properties/@fo:background-color) and starts-with($background,'#')" >
2362- <xsl:attribute name="backColor">
2363- <xsl:value-of select="$background" />
2364- </xsl:attribute>
2365- </xsl:if>
2366-</xsl:template>
2367-
2368-<xsl:template name="make_space_beforeafter">
2369- <xsl:variable name="before">
2370- <xsl:value-of select="style:properties/@fo:margin-top" />
2371- </xsl:variable>
2372- <xsl:variable name="after">
2373- <xsl:value-of select="style:properties/@fo:margin-bottom" />
2374- </xsl:variable>
2375- <xsl:if test="not($before='') and boolean(style:properties/@fo:margin-top)" >
2376- <xsl:attribute name="spaceBefore">
2377- <xsl:value-of select="$before" />
2378- </xsl:attribute>
2379- </xsl:if>
2380- <xsl:if test="not($after='') and boolean(style:properties/@fo:margin-bottom)" >
2381- <xsl:attribute name="spaceAfter">
2382- <xsl:value-of select="$after" />
2383- </xsl:attribute>
2384- </xsl:if>
2385-</xsl:template>
2386-
2387-<xsl:template name="make_fontsize">
2388- <xsl:variable name="fontSize">
2389- <xsl:value-of select="style:properties/@fo:font-size" />
2390- </xsl:variable>
2391- <xsl:if test="not($fontSize='') and boolean(style:properties/@fo:font-size)">
2392- <xsl:attribute name="fontSize">
2393- <xsl:value-of select="$fontSize" />
2394- </xsl:attribute>
2395- <xsl:attribute name="leading">
2396- <xsl:value-of select="$fontSize + floor($fontSize div 5) + 1" />
2397- <!--use a standard leading related to the font size -->
2398- </xsl:attribute>
2399- </xsl:if>
2400-</xsl:template>
2401-
2402-<!--this template is not needed anymore for "normalized" sxw files -->
2403-<xsl:template name="make_parent">
2404- <xsl:variable name="parent">
2405- <xsl:value-of select="@style:parent-style-name" />
2406- </xsl:variable>
2407- <xsl:if test="not($parent='') and boolean(@style:parent-style-name)">
2408- <xsl:attribute name="parent">
2409- <xsl:value-of select="$parent" />
2410- </xsl:attribute>
2411- </xsl:if>
2412-</xsl:template>
2413-
2414-<xsl:template name="make_alignment">
2415- <xsl:variable name="alignment">
2416- <xsl:value-of select="style:properties/@fo:text-align" />
2417- </xsl:variable>
2418- <xsl:if test="not($alignment='') and boolean(style:properties/@fo:text-align)">
2419- <xsl:choose>
2420- <xsl:when test="$alignment='start'">
2421- <xsl:attribute name="alignment">LEFT</xsl:attribute>
2422- </xsl:when>
2423- <xsl:when test="$alignment='center'">
2424- <xsl:attribute name="alignment">CENTER</xsl:attribute>
2425- </xsl:when>
2426- <xsl:when test="$alignment='end'">
2427- <xsl:attribute name="alignment">RIGHT</xsl:attribute>
2428- </xsl:when>
2429- <xsl:when test="$alignment='justify'">
2430- <xsl:attribute name="alignment">JUSTIFY</xsl:attribute>
2431- </xsl:when>
2432- </xsl:choose>
2433- </xsl:if>
2434-</xsl:template>
2435-
2436-<xsl:template name="make_fontnames_paragraph">
2437- <xsl:attribute name="fontName">
2438- <xsl:call-template name="make_fontnames">
2439- <xsl:with-param name="fontName" select="style:properties/@style:font-name" />
2440- <xsl:with-param name="fontWeight" select="style:properties/@fo:font-weight" />
2441- <xsl:with-param name="fontStyle" select="style:properties/@fo:font-style" />
2442- </xsl:call-template>
2443- </xsl:attribute>
2444-</xsl:template>
2445-
2446-<xsl:template name="make_fontnames">
2447- <!--much too verbose, needs improvement-->
2448-<xsl:param name="fontName" />
2449-<xsl:param name="fontWeight" />
2450-<xsl:param name="fontStyle" />
2451-<xsl:choose>
2452-<xsl:when test="not($fontName='') and boolean($fontName)">
2453- <xsl:choose>
2454- <xsl:when test="contains($fontName,'Courier')">
2455- <xsl:choose>
2456- <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
2457- <xsl:text>Courier-BoldOblique</xsl:text>
2458- </xsl:when>
2459- <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
2460- <xsl:text>Courier-Bold</xsl:text>
2461- </xsl:when>
2462- <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
2463- <xsl:text>Courier-Oblique</xsl:text>
2464- </xsl:when>
2465- <xsl:otherwise>
2466- <xsl:text>Courier</xsl:text>
2467- </xsl:otherwise>
2468- </xsl:choose>
2469- </xsl:when>
2470- <xsl:when test="contains($fontName,'Helvetica') or contains($fontName,'Arial') or contains($fontName,'Sans')">
2471- <xsl:choose>
2472- <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
2473- <xsl:text>Helvetica-BoldOblique</xsl:text>
2474- </xsl:when>
2475- <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
2476- <xsl:text>Helvetica-Bold</xsl:text>
2477- </xsl:when>
2478- <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
2479- <xsl:text>Helvetica-Oblique</xsl:text>
2480- </xsl:when>
2481- <xsl:otherwise>
2482- <xsl:text>Helvetica</xsl:text>
2483- </xsl:otherwise>
2484- </xsl:choose>
2485- </xsl:when>
2486- <xsl:otherwise>
2487- <xsl:choose>
2488- <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
2489- <xsl:text>Times-BoldItalic</xsl:text>
2490- </xsl:when>
2491- <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
2492- <xsl:text>Times-Bold</xsl:text>
2493- </xsl:when>
2494- <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
2495- <xsl:text>Times-Italic</xsl:text>
2496- </xsl:when>
2497- <xsl:otherwise>
2498- <xsl:text>Times-Roman</xsl:text>
2499- </xsl:otherwise>
2500- </xsl:choose>
2501- </xsl:otherwise>
2502- </xsl:choose>
2503-</xsl:when>
2504-<xsl:otherwise>
2505- <!--Use this as default -->
2506- <xsl:text>Times-Roman</xsl:text>
2507-</xsl:otherwise>
2508-</xsl:choose>
2509-</xsl:template>
2510-<xsl:template name="make_fontcolor">
2511- <xsl:variable name="textColor">
2512- <xsl:value-of select="style:properties/@fo:color"/>
2513- </xsl:variable>
2514- <xsl:if test="not($textColor='') and boolean(style:properties/@fo:color)">
2515- <xsl:attribute name="textColor">
2516- <xsl:value-of select="$textColor" />
2517- </xsl:attribute>
2518- </xsl:if>
2519-</xsl:template>
2520-
2521-<!--
2522-This stylesheet is part of:
2523-PyOpenOffice Version 0.4
2524-Copyright (C) 2005: Martin Simon
2525-Homepage: www.bezirksreiter.de
2526-
2527-GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999
2528--->
2529-
2530-</xsl:stylesheet>
2531-
2532-
2533
2534=== removed directory 'l10n_it/security'
2535=== removed file 'l10n_it/security/ir.model.access.csv'
2536--- l10n_it/security/ir.model.access.csv 2011-01-14 00:11:01 +0000
2537+++ l10n_it/security/ir.model.access.csv 1970-01-01 00:00:00 +0000
2538@@ -1,3 +0,0 @@
2539-"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
2540-"access_l10n_it_report_manager","l10n_it.report account manager","model_account_report_libroiva","account.group_account_manager",1,1,1,1
2541-"access_l10n_it_report_user","l10n_it_report account user","model_account_report_libroiva","account.group_account_user",1,1,1,1

Subscribers

People subscribed via source and target branches

to all changes: