openerp-brazil-team team mailing list archive
-
openerp-brazil-team team
-
Mailing list archive
-
Message #01359
[Merge] lp:~vdittgen/openerp.pt-br-localiz/tax_application_behaviour into lp:openerp.pt-br-localiz
Vinicius Dittgen - Proge.com.br has proposed merging lp:~vdittgen/openerp.pt-br-localiz/tax_application_behaviour into lp:openerp.pt-br-localiz.
Requested reviews:
OpenERP Brazil Core Team (openerp-brazil-core-team)
For more details, see:
https://code.launchpad.net/~vdittgen/openerp.pt-br-localiz/tax_application_behaviour/+merge/104653
Add tax_add,tax_retain and tax_include behavior. Can support service invoices with retained taxes.
fix price_subtotal calc in invoice, and tax calc in sale order for tax_add type(like ipi).
--
https://code.launchpad.net/~vdittgen/openerp.pt-br-localiz/tax_application_behaviour/+merge/104653
Your team OpenERP Brazil Team is subscribed to branch lp:openerp.pt-br-localiz.
=== added directory 'l10n_br'
=== added file 'l10n_br/__init__.py'
--- l10n_br/__init__.py 1970-01-01 00:00:00 +0000
+++ l10n_br/__init__.py 2012-05-03 23:39:20 +0000
@@ -0,0 +1,24 @@
+# -*- encoding: utf-8 -*-
+#################################################################################
+# #
+# Copyright (C) 2009 Renato Lima - Akretion #
+# #
+#This program is free software: you can redistribute it and/or modify #
+#it under the terms of the GNU Affero General Public License as published by #
+#the Free Software Foundation, either version 3 of the License, or #
+#(at your option) any later version. #
+# #
+#This program is distributed in the hope that it will be useful, #
+#but WITHOUT ANY WARRANTY; without even the implied warranty of #
+#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the #
+#GNU General Public License for more details. #
+# #
+#You should have received a copy of the GNU General Public License #
+#along with this program. If not, see <http://www.gnu.org/licenses/>. #
+#################################################################################
+
+import account
+import l10n_br
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
=== added file 'l10n_br/__openerp__.py'
--- l10n_br/__openerp__.py 1970-01-01 00:00:00 +0000
+++ l10n_br/__openerp__.py 2012-05-03 23:39:20 +0000
@@ -0,0 +1,69 @@
+# -*- encoding: utf-8 -*-
+#################################################################################
+#
+# Copyright (C) 2009 Renato Lima - Akretion
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+#################################################################################
+
+{
+ 'name': 'Brazilian - Accounting',
+ 'category': 'Localization/Account Charts',
+ 'description': """
+Base module for the Brazilian localization
+==========================================
+
+This module consists in:
+
+ - Generic Brazilian chart of accounts
+ - Brazilian taxes such as:
+
+ - IPI
+ - ICMS
+ - PIS
+ - COFINS
+ - ISS
+ - IR
+ - IRPJ
+ - CSLL
+
+ - Tax Situation Code (CST) required for the electronic fiscal invoicing (NFe)
+
+The field tax_discount has also been added in the account.tax.template and account.tax objects to allow the proper computation of some Brazilian VATs such as ICMS. The chart of account creation wizard has been extended to propagate those new data properly.
+
+It's important to note however that this module lack many implementations to use OpenERP properly in Brazil. Those implementations (such as the electronic fiscal Invoicing which is already operational) are brought by more than 15 additional modules of the Brazilian Launchpad localization project https://launchpad.net/openerp.pt-br-localiz and their dependencies in the extra addons branch. Those modules aim at not breaking with the remarkable OpenERP modularity, this is why they are numerous but small. One of the reasons for maintaining those modules apart is that Brazilian Localization leaders need commit rights agility to complete the localization as companies fund the remaining legal requirements (such as soon fiscal ledgers, accounting SPED, fiscal SPED and PAF ECF that are still missing as September 2011). Those modules are also strictly licensed under AGPL V3 and today don't come with any additional paid permission for online use of 'private modules'.""",
+ 'license': 'AGPL-3',
+ 'author': 'Akretion, PROGE, OpenERP Brasil',
+ 'website': 'http://openerpbrasil.org',
+ 'version': '0.6',
+ 'depends': ['account','account_chart'],
+ 'init_xml': [
+ 'data/account.account.type.csv',
+ 'data/account.tax.code.template.csv',
+ 'data/account.account.template.csv',
+ 'data/l10n_br_account_chart_template.xml',
+ 'data/account_tax_template.xml',
+ 'data/l10n_br_data.xml',
+ 'security/ir.model.access.csv',
+ ],
+ 'update_xml': [
+ 'account_view.xml',
+ 'l10n_br_view.xml',
+ ],
+ 'installable': True,
+ 'certificate' : '001280994939126801405',
+}
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
=== added file 'l10n_br/account.py'
--- l10n_br/account.py 1970-01-01 00:00:00 +0000
+++ l10n_br/account.py 2012-05-03 23:39:20 +0000
@@ -0,0 +1,150 @@
+# -*- encoding: utf-8 -*-
+#################################################################################
+# #
+# Copyright (C) 2009 Renato Lima - Akretion, Vinicius Dittgen - PROGE, Leonardo#
+#Santagada - PROGE #
+# #
+#This program is free software: you can redistribute it and/or modify #
+#it under the terms of the GNU Affero General Public License as published by #
+#the Free Software Foundation, either version 3 of the License, or #
+#(at your option) any later version. #
+# #
+#This program is distributed in the hope that it will be useful, #
+#but WITHOUT ANY WARRANTY; without even the implied warranty of #
+#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the #
+#GNU General Public License for more details. #
+# #
+#You should have received a copy of the GNU General Public License #
+#along with this program. If not, see <http://www.gnu.org/licenses/>. #
+#################################################################################
+
+import pooler
+from osv import fields, osv
+
+_columns = {
+ 'domain': fields.char('Domain', size=32, help="This field is only used if you develop your own module allowing developers to create specific taxes in a custom domain."),
+ 'tax_discount': fields.boolean('Tax Discounted in Price', help="Mark it for (ICMS, PIS e etc.)."),
+ 'tax_include': fields.boolean('Include the Tax Amount in Price', help="Mark it to include the Tax Amount in Price."),
+ }
+
+
+class account_tax_code_template(osv.osv):
+ _inherit = 'account.tax.code.template'
+ _columns = _columns
+
+account_tax_code_template()
+
+
+class account_tax_code(osv.osv):
+ _inherit = 'account.tax.code'
+ _columns = _columns
+
+account_tax_code()
+
+
+def change_digit_tax(cr):
+ res = pooler.get_pool(cr.dbname).get('decimal.precision').precision_get(cr, 1, 'Account')
+ return (16, res + 2)
+
+
+_columns_tax = {
+ 'tax_discount': fields.boolean('Tax Discounted in Price', help="Mark it for Brazilian legal Taxes(ICMS, PIS e etc.)."),
+ 'tax_add': fields.boolean('Add the Tax Amount in Price', help="Mark it to add the Tax Amount in Price."),
+ 'tax_include': fields.boolean('Include the Tax Amount in Price', help="Mark it to include the Tax Amount in Price."),
+ 'tax_retain': fields.boolean('Discount the Tax Amount in Price', help="Mark it to for clients who retain the Taxes."),
+ 'base_reduction': fields.float('Redution', required=True, digits_compute=change_digit_tax, help="Um percentual decimal em % entre 0-1."),
+ 'amount_mva': fields.float('MVA Percent', required=True, digits_compute=change_digit_tax, help="Um percentual decimal em % entre 0-1."),
+ 'type': fields.selection([('percent', 'Percentage'), ('fixed', 'Fixed Amount'),
+ ('none', 'None'), ('code', 'Python Code'),
+ ('balance', 'Balance'), ('quantity', 'Quantity')], 'Tax Type', required=True,
+ help="The computation method for the tax amount."),
+ }
+
+_defaults_tax = {
+ 'base_reduction': 0,
+ 'amount_mva': 0,
+ }
+
+
+class account_tax_common(object):
+ tax_code_name = 'account.tax.code.template'
+
+ def onchange_tax_code_id(self, cr, uid, ids, tax_code_id, context=None):
+ result = {'value': {}}
+ if not tax_code_id:
+ return result
+
+ tax_code = self.pool.get(self.tax_code_name).browse(cr, uid, tax_code_id)
+ if tax_code:
+ result['value']['tax_discount'] = tax_code.tax_discount
+ result['value']['tax_include'] = tax_code.tax_include
+ result['value']['domain'] = tax_code.domain
+
+ return result
+
+
+class account_tax_template(account_tax_common, osv.osv):
+ _inherit = 'account.tax.template'
+ tax_code_name = 'account.tax.code.template'
+ _columns = _columns_tax
+ _defaults = _defaults_tax
+
+account_tax_template()
+
+
+class account_tax(account_tax_common, osv.osv):
+ _inherit = 'account.tax'
+ tax_code_name = 'account.tax.code'
+ _columns = _columns_tax
+ _defaults = _defaults_tax
+
+account_tax()
+
+
+class wizard_multi_charts_accounts(osv.osv_memory):
+ _inherit = 'wizard.multi.charts.accounts'
+
+ def execute(self, cr, uid, ids, context=None):
+ super(wizard_multi_charts_accounts, self).execute(cr, uid, ids, context)
+
+ obj_multi = self.browse(cr, uid, ids[0])
+ obj_tax = self.pool.get('account.tax')
+ obj_tax_tmp = self.pool.get('account.tax.template')
+ obj_tax_code = self.pool.get('account.tax.code')
+ obj_tax_code_tmp = self.pool.get('account.tax.code.template')
+ obj_cst = self.pool.get('l10n_br_account.cst')
+ obj_cst_tmp = self.pool.get('l10n_br_account.cst.template')
+
+ # Creating Account
+ tax_code_root_id = obj_multi.chart_template_id.tax_code_root_id.id
+ company_id = obj_multi.company_id.id
+
+ child_tax_code_temp_ids = obj_tax_code_tmp.search(cr, uid, [('parent_id', 'child_of', [tax_code_root_id])], order='id')
+ child_tax_code_temp_ids.sort()
+ for tax_code_template in obj_tax_code_tmp.browse(cr, uid, child_tax_code_temp_ids, context=context):
+ tax_code_id = obj_tax_code.search(cr, uid, [('code', '=', tax_code_template.code),
+ ('company_id', '=', company_id)])
+ if tax_code_id:
+ obj_tax_code.write(cr, uid, tax_code_id, {'domain': tax_code_template.domain,
+ 'notprintable': tax_code_template.notprintable,
+ 'tax_discount': tax_code_template.tax_discount,
+ 'tax_include': tax_code_template.tax_include})
+
+ cst_tmp_ids = obj_cst_tmp.search(cr, uid, [('tax_code_template_id', '=', tax_code_template.id)], order='id')
+ for cst_tmp in obj_cst_tmp.browse(cr, uid, cst_tmp_ids, context=context):
+ obj_cst.create(cr, uid, {'code': cst_tmp.code,
+ 'name': cst_tmp.name,
+ 'tax_code_id': tax_code_id[0]})
+
+ tax_ids = obj_tax_tmp.search(cr, uid, [])
+ for tax_template in obj_tax_tmp.browse(cr, uid, tax_ids, context=context):
+ tax_id = obj_tax.search(cr, uid, [('name', '=', tax_template.name)])
+ if tax_template.id:
+ obj_tax.write(cr, uid, tax_id, {'domain': tax_template.tax_code_id.domain,
+ 'tax_discount': tax_template.tax_discount,
+ 'price_include': tax_template.price_include,
+ 'tax_add': tax_template.tax_add,
+ 'tax_retain': tax_template.tax_retain,
+ 'tax_include': tax_template.tax_include})
+
+wizard_multi_charts_accounts()
=== added file 'l10n_br/account_view.xml'
--- l10n_br/account_view.xml 1970-01-01 00:00:00 +0000
+++ l10n_br/account_view.xml 2012-05-03 23:39:20 +0000
@@ -0,0 +1,114 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+
+ <!-- include domain field em account.tax.code and account.tax.code.template from -->
+ <record model="ir.ui.view" id="view_l10n_br_accout_tax_code_form">
+ <field name="name">l10n_br_account.tax.code.form</field>
+ <field name="model">account.tax.code</field>
+ <field name="inherit_id" ref="account.view_tax_code_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="parent_id">
+ <field name="domain"/>
+ <field name="tax_discount" />
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_accout_tax_code_template_form">
+ <field name="name">l10n_br_account.tax.code.template.form</field>
+ <field name="model">account.tax.code.template</field>
+ <field name="inherit_id" ref="account.view_tax_code_template_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="parent_id">
+ <field name="domain"/>
+ <field name="tax_discount" />
+ </field>
+ </field>
+ </record>
+
+ <!-- Incluir o campo desconto do imposto -->
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_template_form">
+ <field name="name">l10n_br_account.tax.template.form</field>
+ <field name="model">account.tax.template</field>
+ <field name="inherit_id" ref="account.view_account_tax_template_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="price_include">
+ <field groups="base.group_extended" name="tax_discount"/>
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_form">
+ <field name="name">l10n_br_account.tax.form</field>
+ <field name="model">account.tax</field>
+ <field name="inherit_id" ref="account.view_tax_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="price_include">
+ <field groups="base.group_extended" name="tax_discount"/>
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_template_form1">
+ <field name="name">l10n_br_account.tax.template.form1</field>
+ <field name="model">account.tax.template</field>
+ <field name="inherit_id" ref="account.view_account_tax_template_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="amount">
+ <field groups="base.group_extended" name="base_reduction"/>
+ <field groups="base.group_extended" name="amount_mva"/>
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_form1">
+ <field name="name">l10n_br_account.tax.form1</field>
+ <field name="model">account.tax</field>
+ <field name="inherit_id" ref="account.view_tax_form"/>
+ <field name="arch" type="xml">
+ <field position="after" name="amount">
+ <field groups="base.group_extended" name="base_reduction"/>
+ <field groups="base.group_extended" name="amount_mva"/>
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_form2">
+ <field name="name">l10n_br_account.tax.form2</field>
+ <field name="model">account.tax</field>
+ <field name="inherit_id" ref="account.view_tax_form"/>
+ <field name="arch" type="xml">
+ <field name="tax_code_id" position="replace" >
+ <field name="tax_code_id" on_change="onchange_tax_code_id(tax_code_id)" />
+ </field>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_account_tax_template_form2">
+ <field name="name">l10n_br_account.tax.template.form2</field>
+ <field name="model">account.tax.template</field>
+ <field name="inherit_id" ref="account.view_account_tax_template_form"/>
+ <field name="arch" type="xml">
+ <field name="tax_code_id" position="replace" >
+ <field name="tax_code_id" on_change="onchange_tax_code_id(tax_code_id)" />
+ </field>
+ </field>
+ </record>
+
+ <record id="view_l10n_br_journal_form_inherit" model="ir.ui.view">
+ <field name="name">l10n_br.journal.form.inherit</field>
+ <field name="model">account.journal</field>
+ <field name="type">form</field>
+ <field name="inherit_id" ref="account.view_account_journal_form"/>
+ <field name="arch" type="xml">
+ <field name="sequence_id" position="after">
+ <field name="internal_sequence"/>
+ </field>
+ </field>
+ </record>
+
+ </data>
+
+</openerp>
+
=== added directory 'l10n_br/data'
=== added file 'l10n_br/data/account.account.template.csv'
--- l10n_br/data/account.account.template.csv 1970-01-01 00:00:00 +0000
+++ l10n_br/data/account.account.template.csv 2012-05-03 23:39:20 +0000
@@ -0,0 +1,639 @@
+"id","code","name","parent_id:id","type","user_type:id","reconcile"
+"account_template_1","0","Plano de Contas Padrão",,"view","ativo","True"
+"account_template_2","1","ATIVO","account_template_1","view","ativo","True"
+"account_template_3","1.1","CIRCULANTE","account_template_2","view","ativo","True"
+"account_template_4","1.1.01","DISPONIBILIDADES","account_template_3","view","ativo","True"
+"account_template_5","1.1.01.01","CAIXA","account_template_4","view","ativo","True"
+"account_template_6","1.1.01.01.0001","Caixa Geral","account_template_5","other","ativo","True"
+"account_template_7","1.1.01.01.0002","Fundo Fixo","account_template_5","other","ativo","True"
+"account_template_8","1.1.01.02","BANCOS ","account_template_4","view","ativo","True"
+"account_template_9","1.1.01.02.0001","Banco C/ Movimento","account_template_8","other","ativo","True"
+"account_template_10","1.1.01.03","VALORES MOBILIÁRIOS-MERC.CAP.INTERNOS","account_template_4","view","ativo","True"
+"account_template_11","1.1.01.03.0001","Aplicações Nacionais","account_template_10","other","ativo","True"
+"account_template_12","1.1.01.04","TITULOS DE CAPITALIZAÇÃO","account_template_4","view","ativo","True"
+"account_template_13","1.1.01.04.0001","Banco Título de Capitalização","account_template_12","other","ativo","True"
+"account_template_14","1.1.02","CRÉDITOS","account_template_3","view","ativo","True"
+"account_template_15","1.1.02.01","CLIENTES NACIONAIS","account_template_14","view","ativo","True"
+"account_template_16","1.1.02.01.0001","Clientes Nacionais","account_template_15","receivable","ativo","True"
+"account_template_17","1.1.02.02","CLIENTES NO EXTERIOR","account_template_14","view","ativo","True"
+"account_template_18","1.1.02.02.0001","Clientes Internacionais","account_template_17","receivable","ativo","True"
+"account_template_19","1.1.02.03","OUTROS VALORES A RECEBER","account_template_14","view","ativo","True"
+"account_template_20","1.1.02.03.0001","Outras Contas a Receber","account_template_19","receivable","ativo","True"
+"account_template_21","1.1.02.04","DUPLICATAS CONTA VINCULADA","account_template_14","view","ativo","True"
+"account_template_22","1.1.02.04.0001","Banco Conta Garantida","account_template_21","other","ativo","True"
+"account_template_23","1.1.02.05","DUPLICATAS CAUCIONADAS","account_template_14","view","ativo","True"
+"account_template_24","1.1.02.05.0001","Banco Conta Caucionada","account_template_23","other","ativo","True"
+"account_template_25","1.1.02.06","CHEQUES DEVOLVIDOS","account_template_14","view","ativo","True"
+"account_template_26","1.1.02.06.0001","Cheques Devolvidos","account_template_25","other","ativo","True"
+"account_template_27","1.1.02.07","ADIANTAMENTOS","account_template_14","view","ativo","True"
+"account_template_28","1.1.02.07.0002","Adiantamento de Salários","account_template_27","other","ativo","True"
+"account_template_29","1.1.02.07.0003","Adiantamento Despesa de Viagem","account_template_27","other","ativo","True"
+"account_template_30","1.1.02.07.0004","Adiantamento de Férias","account_template_27","other","ativo","True"
+"account_template_31","1.1.02.07.0005","Adiantamento 13º Salário","account_template_27","other","ativo","True"
+"account_template_32","1.1.02.07.0006","Adiantamento de Pro-Labore a Diretores","account_template_27","other","ativo","True"
+"account_template_33","1.1.02.07.0001","Adiantamento de PIS a Empregados","account_template_27","other","ativo","True"
+"account_template_34","1.1.02.08","ADIANTAMENTO A FORNECEDORES","account_template_14","view","ativo","True"
+"account_template_35","1.1.02.08.0001","Adiantamento a Fornecedor","account_template_34","other","ativo","True"
+"account_template_36","1.1.02.09","IMPOSTOS E CONTRIBUIÇÕES A RECUPERAR","account_template_14","view","ativo","True"
+"account_template_37","1.1.02.09.0001","CSLL a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_38","1.1.02.09.0002","CSLL a Compensar Lei 10.833/03","account_template_36","other","ativo","True"
+"account_template_39","1.1.02.09.0003","COFINS a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_40","1.1.02.09.0004","COFINS a Compensar Lei 10.833/03","account_template_36","other","ativo","True"
+"account_template_41","1.1.02.09.0008","Crédito COFINS Não-Cumulativo","account_template_36","other","ativo","True"
+"account_template_42","1.1.02.09.0009","ICMS a Recuperar","account_template_36","other","ativo","True"
+"account_template_43","1.1.02.09.0010","ICMS a Recup. s/Ativo Imobilizado","account_template_36","other","ativo","True"
+"account_template_44","1.1.02.09.0012","IPI a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_45","1.1.02.09.0013","IPI a Compensar Pedido Restituição","account_template_36","other","ativo","True"
+"account_template_46","1.1.02.09.0015","IRF s/Aplicações Financeiras","account_template_36","other","ativo","True"
+"account_template_47","1.1.02.09.0016","IRRF a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_48","1.1.02.09.0017","IRPJ a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_49","1.1.02.09.0019","PIS a Recuperar/Compensar","account_template_36","other","ativo","True"
+"account_template_50","1.1.02.09.0020","PIS a Compensar Lei 10.833/03","account_template_36","other","ativo","True"
+"account_template_51","1.1.02.09.0022","PIS/COFINS/CSLL a Recuperar","account_template_36","other","ativo","True"
+"account_template_52","1.1.02.09.0007","Crédito de PIS Não-Cumulativo","account_template_36","other","ativo","True"
+"account_template_53","1.1.02.10","CRÉDITOS FISCAIS CSLL BASE CALC.NEGATIVA","account_template_14","view","ativo","True"
+"account_template_54","1.1.02.10.0001","Base Negativa CSLL - Exerc. Anteriores","account_template_53","other","ativo","True"
+"account_template_55","1.1.02.11","CRÉDITOS FISCAIS IRPJ-BASE CALC.NEGATIVA","account_template_14","view","ativo","True"
+"account_template_56","1.1.02.11.0001","Base Negativa IRPJ - Exerc. Anteriores","account_template_55","other","ativo","True"
+"account_template_57","1.1.03","ESTOQUES","account_template_3","view","ativo","True"
+"account_template_58","1.1.03.01","ESTOQUE DE MERCADORIAS","account_template_57","view","ativo","True"
+"account_template_59","1.1.03.01.0001","Insumos (Materiais Diretos)","account_template_58","other","ativo","True"
+"account_template_60","1.1.03.01.0002","Material de Consumo-Almoxarifado","account_template_58","other","ativo","True"
+"account_template_61","1.1.03.01.0003","Mercadorias para Revenda","account_template_58","other","ativo","True"
+"account_template_62","1.1.03.01.0004","Produtos Acabados","account_template_58","other","ativo","True"
+"account_template_63","1.1.03.01.0005","Produtos em Elaboração","account_template_58","other","ativo","True"
+"account_template_64","1.1.03.02","(-) DEVOLUÇÕES DE COMPRAS","account_template_57","view","ativo","True"
+"account_template_65","1.1.03.02.0001","Devoluções de Compras","account_template_64","other","ativo","True"
+"account_template_66","1.1.03.03","TRANSFERÊNCIA DE MERCADORIAS","account_template_57","view","ativo","True"
+"account_template_67","1.1.03.03.0001","Transferência de Mercadorias","account_template_66","other","ativo","True"
+"account_template_68","1.1.03.04","ESTOQUE DE TERCEIROS EM NOSSO PODER","account_template_57","view","ativo","True"
+"account_template_69","1.1.03.04.0001","Estoque de Terceiros em N/Poder","account_template_68","other","ativo","True"
+"account_template_70","1.1.03.04.0002","Entrada P/Industrialização","account_template_68","other","ativo","True"
+"account_template_71","1.1.03.04.0003","Entrada P/Conserto","account_template_68","other","ativo","True"
+"account_template_72","1.1.03.04.0004","Entrada P/Demonstração","account_template_68","other","ativo","True"
+"account_template_73","1.1.03.04.0005","Entrada P/Empréstimo","account_template_68","other","ativo","True"
+"account_template_74","1.1.03.04.0006","Entrada em Consignação","account_template_68","other","ativo","True"
+"account_template_75","1.1.03.04.0007","Entrada p/ Garantia","account_template_68","other","ativo","True"
+"account_template_76","1.1.03.04.0008","Entrada p/ Locação","account_template_68","other","ativo","True"
+"account_template_77","1.1.03.04.0009","Entrada em Comodato","account_template_68","other","ativo","True"
+"account_template_78","1.1.03.05","NOSSO ESTOQUE EM PODER DE TERCEIROS","account_template_57","view","ativo","True"
+"account_template_79","1.1.03.05.0001","N/Estoque em Poder de Terceiros","account_template_78","other","ativo","True"
+"account_template_80","1.1.03.05.0002","Remessa P/Industrialização","account_template_78","other","ativo","True"
+"account_template_81","1.1.03.05.0003","Remessa P/Conserto","account_template_78","other","ativo","True"
+"account_template_82","1.1.03.05.0004","Remessa P/Demonstração","account_template_78","other","ativo","True"
+"account_template_83","1.1.03.05.0005","Remessa P/Exposição","account_template_78","other","ativo","True"
+"account_template_84","1.1.03.05.0006","Remessa P/Empréstimo","account_template_78","other","ativo","True"
+"account_template_85","1.1.03.05.0007","Remessa em Consignação","account_template_78","other","ativo","True"
+"account_template_86","1.1.03.05.0008","Remessa P/Locação","account_template_78","other","ativo","True"
+"account_template_87","1.1.03.05.0009","Remessa em Garantia","account_template_78","other","ativo","True"
+"account_template_88","1.1.03.06","(-) IMPOSTOS S/ESTOQUE DE TERCEIROS","account_template_57","view","ativo","True"
+"account_template_89","1.1.03.06.0001","(-) ICMS s/Estoque de Terceiros","account_template_88","other","ativo","True"
+"account_template_90","1.1.03.06.0002","(-) IPI s/Estoque de Terceiros","account_template_88","other","ativo","True"
+"account_template_91","1.1.03.07","IMPORTAÇÕES EM ANDAMENTO","account_template_57","view","ativo","True"
+"account_template_92","1.1.03.07.0001","D.I. nº 0000000-0 Importação","account_template_91","other","ativo","True"
+"account_template_93","1.1.03.08","COMPRAS PARA ENTREGA FUTURA","account_template_57","view","ativo","True"
+"account_template_94","1.1.03.08.0001","Compras p/Entrega Futura","account_template_93","other","ativo","True"
+"account_template_95","1.1.04","DESPESAS DO EXERCÍCIO SEGUINTE","account_template_3","view","ativo","True"
+"account_template_96","1.1.04.01","SEGUROS A APROPRIAR","account_template_95","view","ativo","True"
+"account_template_97","1.1.04.01.0001","Seguros de Veículos","account_template_96","other","ativo","True"
+"account_template_98","1.1.04.01.0002","Seguros Prédios/Bens/Estoques","account_template_96","other","ativo","True"
+"account_template_99","1.1.04.01.0003","Seguros s/Lucros Cessantes","account_template_96","other","ativo","True"
+"account_template_100","1.1.04.02","ASSINATURAS A APROPRIAR","account_template_95","view","ativo","True"
+"account_template_101","1.1.04.02.0001","Assinaturas de Jornais/Boletins/Revistas","account_template_100","other","ativo","True"
+"account_template_102","1.1.04.03","DESPESAS FINANCEIRAS A APROPRIAR","account_template_95","view","ativo","True"
+"account_template_103","1.1.04.03.0001","Juros s/ Financiamentos a Apropriar","account_template_102","other","ativo","True"
+"account_template_104","1.1.05","CONTAS RETIFICADORAS","account_template_3","view","ativo","True"
+"account_template_105","1.1.05.01","(-) DUPLICATAS DESCONTADAS","account_template_104","view","ativo","True"
+"account_template_106","1.1.05.01.0001","(-) Banco Conta - Duplicata Descontada","account_template_105","other","ativo","True"
+"account_template_107","1.2","ATIVO NÃO CIRCULANTE","account_template_2","view","ativo","True"
+"account_template_108","1.2.01","REALIZÁVEL A LONGO PRAZO","account_template_107","view","ativo","True"
+"account_template_109","1.2.01.01","VALORES MOBILIÁRIOS-MERC.CAP.INTERNO","account_template_108","view","ativo","True"
+"account_template_110","1.2.01.01.0001","Aplicações Nacionais","account_template_109","other","ativo","True"
+"account_template_111","1.2.01.02","DÉBITOS DE SÓCIOS","account_template_108","view","ativo","True"
+"account_template_112","1.2.01.02.0001","Sócio","account_template_111","other","ativo","True"
+"account_template_113","1.2.01.03","EMPRÉSTIMOS A EMPRESAS LIGADAS","account_template_108","view","ativo","True"
+"account_template_114","1.2.01.03.0001","Empresa Ligada","account_template_113","other","ativo","True"
+"account_template_115","1.2.01.04","EMPRÉSTIMOS A TERCEIROS","account_template_108","view","ativo","True"
+"account_template_116","1.2.01.04.0001","Empréstimo de Terceiros","account_template_115","other","ativo","True"
+"account_template_117","1.2.01.05","DEPÓSITOS JUDICIAIS","account_template_108","view","ativo","True"
+"account_template_118","1.2.01.05.0001","Depósitos Judiciais","account_template_117","other","ativo","True"
+"account_template_119","1.2.02","INVESTIMENTOS","account_template_107","view","ativo","True"
+"account_template_120","1.2.02.01","PARTICIPAÇÕES SOCIETÁRIAS","account_template_119","view","ativo","True"
+"account_template_121","1.2.02.01.0001","Participação Societárias","account_template_120","other","ativo","True"
+"account_template_122","1.2.03","IMOBILIZADO - MATRIZ","account_template_107","view","ativo","True"
+"account_template_123","1.2.03.01","IMOBILIZADO","account_template_122","view","ativo","True"
+"account_template_124","1.2.03.01.0001","Máquinas e Equipamentos ","account_template_123","other","ativo","True"
+"account_template_125","1.2.03.01.0002","Terrenos","account_template_123","other","ativo","True"
+"account_template_126","1.2.03.01.0003","Ferramentas","account_template_123","other","ativo","True"
+"account_template_127","1.2.03.01.0004","Modelos, Moldes e Matrizes","account_template_123","other","ativo","True"
+"account_template_128","1.2.03.01.0005","Móveis e Utensílios","account_template_123","other","ativo","True"
+"account_template_129","1.2.03.01.0006","Veículos","account_template_123","other","ativo","True"
+"account_template_130","1.2.03.01.0007","Equipamentos de Informática","account_template_123","other","ativo","True"
+"account_template_131","1.2.03.01.0008","Instalações","account_template_123","other","ativo","True"
+"account_template_132","1.2.03.01.0009","Benfeitoria em Imóveis de Terceiros","account_template_123","other","ativo","True"
+"account_template_133","1.2.03.01.0010","Direito de Uso Linhas Telefônicas","account_template_123","other","ativo","True"
+"account_template_134","1.2.03.01.0011","Edifícios e Construções","account_template_123","other","ativo","True"
+"account_template_135","1.2.03.02","CONSTRUÇÕES EM ANDAMENTO","account_template_122","view","ativo","True"
+"account_template_136","1.2.03.02.0001","Imóvel","account_template_135","other","ativo","True"
+"account_template_137","1.2.03.04","PARTICIPAÇÃO EM CONSÓRCIOS","account_template_122","view","ativo","True"
+"account_template_138","1.2.03.04.0001","Consórcio","account_template_137","other","ativo","True"
+"account_template_139","1.2.03.05","(-) DEPRECIAÇÃO ACUMULADA","account_template_122","view","ativo","True"
+"account_template_140","1.2.03.05.0001","Deprec.de Máquinas e Equipamentos","account_template_139","other","ativo","True"
+"account_template_141","1.2.03.05.0002","Deprec.de Modelos, Moldes e Matrizes","account_template_139","other","ativo","True"
+"account_template_142","1.2.03.05.0003","Deprec.de Móveis e Utensílios","account_template_139","other","ativo","True"
+"account_template_143","1.2.03.05.0004","Deprec.de Veículos","account_template_139","other","ativo","True"
+"account_template_144","1.2.03.05.0005","Deprec.de Equip.de Informática","account_template_139","other","ativo","True"
+"account_template_145","1.2.03.05.0006","Deprec.de Instalações","account_template_139","other","ativo","True"
+"account_template_146","1.2.03.05.0007","Deprec.de Ferramentas","account_template_139","other","ativo","True"
+"account_template_147","1.2.03.05.0008","Deprec.de Edificações","account_template_139","other","ativo","True"
+"account_template_148","1.2.03.06","(-) AMORTIZAÇÃO ACUMULADA","account_template_122","view","ativo","True"
+"account_template_149","1.2.03.06.0001","Amortiz.Benfeit.em Imóveis de Terceiros","account_template_148","other","ativo","True"
+"account_template_150","1.2.03.06.0002","Amortiz.Direito Uso Linhas Telefônica","account_template_148","other","ativo","True"
+"account_template_151","1.2.03.07","ICMS S/IMOBILIZADO-PARCELA NÃO CREDITADA","account_template_122","view","ativo","True"
+"account_template_152","1.2.03.07.0001","ICMS s/ Imobilizado parc. não creditável","account_template_151","other","ativo","True"
+"account_template_153","1.2.03.07.0002","(-) Amortização ICMS não creditado","account_template_151","other","ativo","True"
+"account_template_154","1.2.04","IMOBILIZADO - FILIAL","account_template_107","view","ativo","True"
+"account_template_155","1.2.04.01","IMOBILIZADO","account_template_154","view","ativo","True"
+"account_template_156","1.2.04.01.0001","Máquinas e Equipamentos","account_template_155","other","ativo","True"
+"account_template_157","1.2.04.01.0002","Terrenos","account_template_155","other","ativo","True"
+"account_template_158","1.2.04.01.0003","Ferramentas","account_template_155","other","ativo","True"
+"account_template_159","1.2.04.01.0004","Edifícios","account_template_155","other","ativo","True"
+"account_template_160","1.2.04.01.0005","Móveis e Utensílios","account_template_155","other","ativo","True"
+"account_template_161","1.2.04.01.0006","Veículos","account_template_155","other","ativo","True"
+"account_template_162","1.2.04.01.0007","Equipamentos de Informática","account_template_155","other","ativo","True"
+"account_template_163","1.2.04.01.0008","Instalações","account_template_155","other","ativo","True"
+"account_template_164","1.2.04.02","(-) DEPRECIAÇÃO ACUMULADA - FILIAL","account_template_154","view","ativo","True"
+"account_template_165","1.2.04.02.0001","Deprec.de Máquinas e Equipamentos","account_template_164","other","ativo","True"
+"account_template_166","1.2.04.02.0003","Deprec.de Móveis e Utensílios","account_template_164","other","ativo","True"
+"account_template_167","1.2.04.02.0004","Deprec.de Veículos","account_template_164","other","ativo","True"
+"account_template_168","1.2.04.02.0005","Deprec.de Equip.de Informática","account_template_164","other","ativo","True"
+"account_template_169","1.2.04.02.0006","Deprec.de Instalações","account_template_164","other","ativo","True"
+"account_template_170","1.2.04.02.0007","Deprec.de Ferramentas","account_template_164","other","ativo","True"
+"account_template_171","1.2.04.02.0008","Deprec.de Edifícios","account_template_164","other","ativo","True"
+"account_template_172","1.2.04.03","(-) AMORTIZAÇÃO ACUMULADA - FILIAL","account_template_154","view","ativo","True"
+"account_template_173","1.2.04.03.0001","Amortização Acumulada","account_template_172","other","ativo","True"
+"account_template_174","1.2.05","BENS INTAGÍVEIS - MATRIZ","account_template_107","view","ativo","True"
+"account_template_175","1.2.05.01","INTANGÍVEL","account_template_174","view","ativo","True"
+"account_template_176","1.2.05.01.0001","Marcas e Patentes","account_template_175","other","ativo","True"
+"account_template_177","1.2.05.01.0002","Softwares","account_template_175","other","ativo","True"
+"account_template_178","1.2.05.02","(-) AMORTIZAÇÃO DO INTANGÍVEL","account_template_174","view","ativo","True"
+"account_template_179","1.2.05.02.0001","Amortiz.de Marcas e Patentes","account_template_178","other","ativo","True"
+"account_template_180","1.2.05.02.0002","Amortização de Softwares","account_template_178","other","ativo","True"
+"account_template_181","1.2.06","BENS INTANGÍVEIS - FILIAL","account_template_107","view","ativo","True"
+"account_template_182","1.2.06.01","INTANGÍVEL","account_template_181","view","ativo","True"
+"account_template_183","1.2.06.01.0001","Softwares","account_template_182","other","ativo","True"
+"account_template_184","1.2.06.02","(-) AMORTIZAÇÃO DO INTANGÍVEL","account_template_181","view","ativo","True"
+"account_template_185","1.2.06.02.0001","Amortização de Softwares","account_template_184","other","ativo","True"
+"account_template_186","1.2.07","TRANSFERÊNCIAS DE ATIVO IMOBILIZADO","account_template_107","view","ativo","True"
+"account_template_187","1.2.07.01","TRANSFERÊNCIA DE ATIVO IMOBILIZADO","account_template_186","view","ativo","True"
+"account_template_188","1.2.07.01.0001","Transferência de Ativo Imobilizado","account_template_187","other","ativo","True"
+"account_template_189","1.2.08","DIFERIDO","account_template_107","view","ativo","True"
+"account_template_190","1.2.08.01","DESPESAS PRÉ-INDUSTRIAIS","account_template_189","view","ativo","True"
+"account_template_191","1.2.08.01.0001","Gastos Gerais de Implantação","account_template_190","other","ativo","True"
+"account_template_192","1.2.08.01.0002","(-) Amortização Acumulada","account_template_190","other","ativo","True"
+"account_template_193","2","PASSIVO","account_template_1","view","passivo","True"
+"account_template_194","2.1","CIRCULANTE","account_template_193","view","passivo","True"
+"account_template_195","2.1.01","OBRIGAÇÕES A CURTO PRAZO","account_template_194","view","passivo","True"
+"account_template_196","2.1.01.01","FINANCIAMENTOS A CURTO PRAZO - SFN","account_template_195","view","passivo","True"
+"account_template_197","2.1.01.01.0001","Banco Conta Empréstimo","account_template_196","other","passivo","True"
+"account_template_198","2.1.01.02","CHEQUES A COMPENSAR","account_template_195","view","passivo","True"
+"account_template_199","2.1.01.02.0001","Banco Conta a Compensar","account_template_198","other","passivo","True"
+"account_template_200","2.1.01.03","LIMITE DE CRÉDITO CHEQUE ESPECIAL","account_template_195","view","passivo","True"
+"account_template_201","2.1.01.03.0001","Banco Conta Limite","account_template_200","other","passivo","True"
+"account_template_202","2.1.02","FORNECEDORES ","account_template_194","view","passivo","True"
+"account_template_203","2.1.02.01","FORNECEDORES NACIONAIS","account_template_202","view","passivo","True"
+"account_template_204","2.1.02.01.0001","Fornecedores Nacionais","account_template_203","payable","passivo","True"
+"account_template_205","2.1.02.02","FORNECEDORES ESTRANGEIROS","account_template_202","view","passivo","True"
+"account_template_206","2.1.02.02.0001","Fornecedores Internacionais","account_template_205","payable","passivo","True"
+"account_template_207","2.1.03","OBRIGAÇÕES TRABALHISTAS","account_template_194","view","passivo","True"
+"account_template_208","2.1.03.01","FOLHA DE PAGAMENTO - EMPREGADOS","account_template_207","view","passivo","True"
+"account_template_209","2.1.03.01.0001","Salários a Pagar","account_template_208","other","passivo","True"
+"account_template_210","2.1.03.01.0002","Férias a Pagar","account_template_208","other","passivo","True"
+"account_template_211","2.1.03.01.0003","Rescisões a Pagar","account_template_208","other","passivo","True"
+"account_template_212","2.1.03.01.0004","13º Salário a Pagar","account_template_208","other","passivo","True"
+"account_template_213","2.1.03.01.0005","Comissões a Pagar","account_template_208","other","passivo","True"
+"account_template_214","2.1.03.02","PROVISÕES DE FÉRIAS E 13º SALÁRIO","account_template_207","view","passivo","True"
+"account_template_215","2.1.03.02.0001","Provisão de Férias","account_template_214","other","passivo","True"
+"account_template_216","2.1.03.02.0002","Provisão de INSS s/Férias","account_template_214","other","passivo","True"
+"account_template_217","2.1.03.02.0003","Provisão de FGTS s/Férias","account_template_214","other","passivo","True"
+"account_template_218","2.1.03.02.0004","Provisão de 13º Salário","account_template_214","other","passivo","True"
+"account_template_219","2.1.03.02.0005","Provisão de INSS s/13º Salário","account_template_214","other","passivo","True"
+"account_template_220","2.1.03.02.0006","Provisão FGTS s/13º Salário","account_template_214","other","passivo","True"
+"account_template_221","2.1.03.03","FOLHA DE PAGAMENTO - AUTÔNOMOS","account_template_207","view","passivo","True"
+"account_template_222","2.1.03.03.0001","Rendimentos a Pagar","account_template_221","other","passivo","True"
+"account_template_223","2.1.03.04","FOLHA DE PAGAMENTO - DIRIGENTES","account_template_207","view","passivo","True"
+"account_template_224","2.1.03.04.0001","Pro-Labore a Pagar","account_template_223","other","passivo","True"
+"account_template_225","2.1.03.05","ENCARGOS SOCIAIS A PAGAR","account_template_207","view","passivo","True"
+"account_template_226","2.1.03.05.0001","INSS a Recolher","account_template_225","other","passivo","True"
+"account_template_227","2.1.03.05.0002","FGTS a Recolher","account_template_225","other","passivo","True"
+"account_template_228","2.1.03.05.0003","Contribuição Sindical a Pagar","account_template_225","other","passivo","True"
+"account_template_229","2.1.03.05.0004","Previdência Privada a Recolher","account_template_225","other","passivo","True"
+"account_template_230","2.1.04","OBRIGAÇÕES TRIBUTÁRIAS","account_template_194","view","passivo","True"
+"account_template_231","2.1.04.01","IMPOSTOS RETIDOS A RECOLHER","account_template_230","view","passivo","True"
+"account_template_232","2.1.04.01.0001","IRRF a Recolher - Pessoa Física","account_template_231","other","passivo","True"
+"account_template_233","2.1.04.01.0002","IRRF a Recolher - Pessoa Jurídica","account_template_231","other","passivo","True"
+"account_template_234","2.1.04.01.0003","ISS Retido a Recolher","account_template_231","other","passivo","True"
+"account_template_235","2.1.04.01.0004","PIS/COFINS/CSLL Retido a Recolher","account_template_231","other","passivo","True"
+"account_template_236","2.1.04.01.0005","INSS Retido a Recolher","account_template_231","other","passivo","True"
+"account_template_237","2.1.04.02","IMPOSTOS E CONTRIBUIÇÃO S/ O LUCRO","account_template_230","view","passivo","True"
+"account_template_238","2.1.04.02.0001","Provisão para o Imposto de Renda","account_template_237","other","passivo","True"
+"account_template_239","2.1.04.02.0002","Provisão Contrib.Social s/Lucro Líquido","account_template_237","other","passivo","True"
+"account_template_240","2.1.04.03","IMPOSTOS E CONTRIBUIÇÃO S/ RECEITAS","account_template_230","view","passivo","True"
+"account_template_241","2.1.04.03.0001","ICMS a Recolher","account_template_240","other","passivo","True"
+"account_template_242","2.1.04.03.0002","COFINS a Recolher","account_template_240","other","passivo","True"
+"account_template_243","2.1.04.03.0003","PIS a Recolher","account_template_240","other","passivo","True"
+"account_template_244","2.1.04.03.0004","IPI a Recolher","account_template_240","other","passivo","True"
+"account_template_245","2.1.04.03.0005","ISS a Recolher","account_template_240","other","passivo","True"
+"account_template_246","2.1.05","PARCELAMENTOS CURTO PRAZO","account_template_194","view","passivo","True"
+"account_template_247","2.1.05.01","PARCELAMENTOS TRIBUTÁRIOS","account_template_246","view","passivo","True"
+"account_template_248","2.1.05.01.0001","COFINS Parcelamento","account_template_247","other","passivo","True"
+"account_template_249","2.1.05.01.0002","PIS Parcelamento","account_template_247","other","passivo","True"
+"account_template_250","2.1.05.01.0003","IPI Parcelamento","account_template_247","other","passivo","True"
+"account_template_251","2.1.05.01.0004","ICMS Parcelamento","account_template_247","other","passivo","True"
+"account_template_252","2.1.05.01.0005","IRPJ Parcelamento","account_template_247","other","passivo","True"
+"account_template_253","2.1.05.01.0006","CSLL Parcelamento","account_template_247","other","passivo","True"
+"account_template_254","2.1.05.01.0007","INSS Parcelamento","account_template_247","other","passivo","True"
+"account_template_255","2.1.05.01.0008","FGTS Parcelamento","account_template_247","other","passivo","True"
+"account_template_256","2.1.06","OUTRAS OBRIGAÇÕES","account_template_194","view","passivo","True"
+"account_template_257","2.1.06.01","CONTAS DE CONSUMO","account_template_256","view","passivo","True"
+"account_template_258","2.1.06.01.0001","Consumo de Água/Esgoto","account_template_257","other","passivo","True"
+"account_template_259","2.1.06.01.0003","Consumo de Energia Elétrica","account_template_257","other","passivo","True"
+"account_template_260","2.1.06.01.0004","Consumo de Telefone","account_template_257","other","passivo","True"
+"account_template_261","2.1.06.01.0005","Consumo de Internet","account_template_257","other","passivo","True"
+"account_template_262","2.1.06.02","OUTRAS CONTAS A PAGAR","account_template_256","view","passivo","True"
+"account_template_263","2.1.06.02.0001","Cheques a Compensar","account_template_262","other","passivo","True"
+"account_template_264","2.1.06.02.0002","Seguros a Pagar","account_template_262","other","passivo","True"
+"account_template_265","2.1.06.02.0003","Assinaturas de Periódicos a Pagar","account_template_262","other","passivo","True"
+"account_template_266","2.1.06.02.0004","Aluguel a Pagar","account_template_262","other","passivo","True"
+"account_template_267","2.1.06.02.0005","Doações a Pagar","account_template_262","other","passivo","True"
+"account_template_268","2.1.06.02.0006","Pensão Alimenticia a Pagar","account_template_262","other","passivo","True"
+"account_template_269","2.1.06.03","ADIANTAMENTO DE CLIENTES","account_template_256","view","passivo","True"
+"account_template_270","2.1.06.03.0001","Adiantamento Clientes","account_template_269","other","passivo","True"
+"account_template_271","2.2","PASSIVO NÃO CIRCULANTE","account_template_193","view","passivo","True"
+"account_template_272","2.2.01","EXIGÍVEL A LONGO PRAZO","account_template_271","view","passivo","True"
+"account_template_273","2.2.01.01","FINANCIAMENTOS A LONGO PRAZO - SFN","account_template_272","view","passivo","True"
+"account_template_274","2.2.01.01.0001","Banco Conta Empréstimo","account_template_273","other","passivo","True"
+"account_template_275","2.2.01.02","EMPRÉSTIMO DE SÓCIOS","account_template_272","view","passivo","True"
+"account_template_276","2.2.01.02.0001","Sócio","account_template_275","other","passivo","True"
+"account_template_277","2.2.01.03","EMPRÉSTIMO DE EMPRESAS LIGADAS","account_template_272","view","passivo","True"
+"account_template_278","2.2.01.03.0001","Empresas Ligadas","account_template_277","other","passivo","True"
+"account_template_279","2.2.01.04","EMPRÉSTIMOS A TERCEIROS","account_template_272","view","passivo","True"
+"account_template_280","2.2.01.04.0001","Terceiro","account_template_279","other","passivo","True"
+"account_template_281","2.2.01.05","PARCELAMENTOS TRIBUTÁRIOS","account_template_272","view","passivo","True"
+"account_template_282","2.2.01.05.0001","COFINS Parcelamento","account_template_281","other","passivo","True"
+"account_template_283","2.2.01.05.0002","PIS Parcelamento","account_template_281","other","passivo","True"
+"account_template_284","2.2.01.05.0003","IPI Parcelamento","account_template_281","other","passivo","True"
+"account_template_285","2.2.01.05.0004","ICMS Parcelamento","account_template_281","other","passivo","True"
+"account_template_286","2.2.01.05.0005","ISS Parcelamento","account_template_281","other","passivo","True"
+"account_template_287","2.2.01.05.0006","IRPJ Parcelamento","account_template_281","other","passivo","True"
+"account_template_288","2.2.01.05.0007","CSLL Parcelamento","account_template_281","other","passivo","True"
+"account_template_289","2.2.01.05.0008","INSS Parcelamento","account_template_281","other","passivo","True"
+"account_template_290","2.2.01.05.0009","FGTS Parcelamento","account_template_281","other","passivo","True"
+"account_template_291","2.2.03","RECEITA DIFERIDA","account_template_271","view","passivo","True"
+"account_template_292","2.2.03.01","RECEITAS DIFERIDAS","account_template_291","view","passivo","True"
+"account_template_293","2.2.03.01.0001","Receitas a Realizar","account_template_292","other","passivo","True"
+"account_template_294","2.2.03.02","CUSTOS DIFERIDOS","account_template_291","view","passivo","True"
+"account_template_295","2.2.03.02.0001","Custos Diferidos","account_template_294","other","passivo","True"
+"account_template_296","2.2.03.03","DESPESAS DIFERIDAS","account_template_291","view","passivo","True"
+"account_template_297","2.2.03.03.0001","Despesas Diferidas","account_template_296","other","passivo","True"
+"account_template_298","2.4","PATRIMÔNIO LÍQUIDO","account_template_193","view","passivo","True"
+"account_template_299","2.4.01","CAPITAL SOCIAL","account_template_298","view","passivo","True"
+"account_template_300","2.4.01.01","CAPITAL SOCIAL REALIZADO","account_template_299","view","passivo","True"
+"account_template_301","2.4.01.01.0001","Capital Social Realizado","account_template_300","other","passivo","True"
+"account_template_302","2.4.01.02","(-) CAPITAL A REALIZAR","account_template_299","view","passivo","True"
+"account_template_303","2.4.01.02.0001","Capital Social a Realizar ","account_template_302","other","passivo","True"
+"account_template_304","2.4.02","RESERVAS","account_template_298","view","passivo","True"
+"account_template_305","2.4.02.01","RESERVAS DE CAPITAL","account_template_304","view","passivo","True"
+"account_template_306","2.4.02.01.0001","Reserva de Correção do Capital Realizado","account_template_305","other","passivo","True"
+"account_template_307","2.4.02.02","AJUSTES DE AVALIAÇÃO PATRIMONIAL","account_template_304","view","passivo","True"
+"account_template_308","2.4.02.02.0001","Ajustes de Avaliação Patrimonial","account_template_307","other","passivo","True"
+"account_template_309","2.4.02.03","RESERVAS DE LUCROS","account_template_304","view","passivo","True"
+"account_template_310","2.4.02.03.0001","Reserva de Lucros","account_template_309","other","passivo","True"
+"account_template_311","2.4.02.03.0002","Reserva para Aumento de Capital","account_template_309","other","passivo","True"
+"account_template_312","2.4.02.04","PREJUÍZOS ACUMULADOS","account_template_304","view","passivo","True"
+"account_template_313","2.4.02.04.0002","(-) Prejuízos Acumulados","account_template_312","other","passivo","True"
+"account_template_314","2.4.02.04.0003","Ajustes Credores Exercícios Anteriores","account_template_312","other","passivo","True"
+"account_template_315","2.4.02.04.0001","Ajustes Devedores Exercícios Anteriores","account_template_312","other","passivo","True"
+"account_template_316","2.4.02.05","RESULTADO DO EXERCÍCIO","account_template_304","view","passivo","True"
+"account_template_317","2.4.02.05.0001","Lucro do Exercício","account_template_316","other","passivo","True"
+"account_template_318","2.4.02.05.0002","Prejuízo do Exercício","account_template_316","other","passivo","True"
+"account_template_319","2.4.02.06","(-) LUCROS DISTRIBUÍDOS","account_template_304","view","passivo","True"
+"account_template_320","2.4.02.06.0001","Lucros Distribuídos","account_template_319","other","passivo","True"
+"account_template_321","3","CONTAS DE RESULTADO - CUSTOS E DESPESAS","account_template_1","view","despesa","True"
+"account_template_322","3.1","CUSTOS","account_template_321","view","despesa","True"
+"account_template_323","3.1.01","CUSTOS DAS MERCADORIAS E PRODUTOS","account_template_322","view","despesa","True"
+"account_template_324","3.1.01.01","CUSTOS DAS MERCADORIAS VENDIDAS","account_template_323","view","despesa","True"
+"account_template_325","3.1.01.01.0001","Custo das Mercadorias Vendidas","account_template_324","other","despesa","True"
+"account_template_326","3.1.02","CUSTO DOS PRODUTOS VENDIDOS","account_template_322","view","despesa","True"
+"account_template_327","3.1.02.01","CUSTO DAS MATÉRIAS PRIMAS","account_template_326","view","despesa","True"
+"account_template_328","3.1.02.01.0001","Custo das Matérias Primas","account_template_327","other","despesa","True"
+"account_template_329","3.1.02.02","CUSTO DOS PRODUTOS ACABADOS","account_template_326","view","despesa","True"
+"account_template_330","3.1.02.02.0001","Custo dos Produtos Acabados","account_template_329","other","despesa","True"
+"account_template_331","3.1.02.03","CUSTO DE MÃO-DE-OBRA DIRETA","account_template_326","view","despesa","True"
+"account_template_332","3.1.02.03.0001","Salários","account_template_331","other","despesa","True"
+"account_template_333","3.1.02.03.0002","Horas Extras","account_template_331","other","despesa","True"
+"account_template_334","3.1.02.03.0003","Adicional Noturno","account_template_331","other","despesa","True"
+"account_template_335","3.1.02.03.0004","Férias","account_template_331","other","despesa","True"
+"account_template_336","3.1.02.03.0005","13º Salário","account_template_331","other","despesa","True"
+"account_template_337","3.1.02.03.0006","Aviso Prévio/Indeniz.Trabalhistas","account_template_331","other","despesa","True"
+"account_template_338","3.1.02.03.0007","Gratificações","account_template_331","other","despesa","True"
+"account_template_339","3.1.02.03.0008","INSS Empresa","account_template_331","other","despesa","True"
+"account_template_340","3.1.02.03.0009","FGTS ","account_template_331","other","despesa","True"
+"account_template_341","3.1.02.03.0010","Adicional Insalubridade","account_template_331","other","despesa","True"
+"account_template_342","3.1.02.03.0011","Vale Transporte","account_template_331","other","despesa","True"
+"account_template_343","3.1.02.03.0012","PAT - Programa Alim. Trabalhador","account_template_331","other","despesa","True"
+"account_template_344","3.1.02.03.0013","Assistência Médica","account_template_331","other","despesa","True"
+"account_template_345","3.1.02.03.0014","DSR - Descanso Semanal Remunerado","account_template_331","other","despesa","True"
+"account_template_346","3.1.02.03.0015","Salário Estagiários","account_template_331","other","despesa","True"
+"account_template_347","3.1.02.03.0016","Previdência Privada","account_template_331","other","despesa","True"
+"account_template_348","3.1.02.03.0017","Vestuário","account_template_331","other","despesa","True"
+"account_template_349","3.1.02.03.0018","Assiduidade","account_template_331","other","despesa","True"
+"account_template_350","3.1.02.03.0019","Abono Salarial","account_template_331","other","despesa","True"
+"account_template_351","3.1.02.03.0020","Vale Refeição","account_template_331","other","despesa","True"
+"account_template_352","3.1.02.03.0021","Farmácia","account_template_331","other","despesa","True"
+"account_template_353","3.1.02.03.0022","Pró-Labore","account_template_331","other","despesa","True"
+"account_template_354","3.1.02.04","GASTOS GERAIS DE FABRICAÇÃO","account_template_326","view","despesa","True"
+"account_template_355","3.1.02.04.0001","Aluguel","account_template_354","other","despesa","True"
+"account_template_356","3.1.02.04.0002","Água e Esgoto","account_template_354","other","despesa","True"
+"account_template_357","3.1.02.04.0003","Energia Elétrica","account_template_354","other","despesa","True"
+"account_template_358","3.1.02.04.0004","Fretes e Carretos","account_template_354","other","despesa","True"
+"account_template_359","3.1.02.04.0005","Material de Consumo","account_template_354","other","despesa","True"
+"account_template_360","3.1.02.04.0006","Condução","account_template_354","other","despesa","True"
+"account_template_361","3.1.02.04.0007","Contribuição Sindical/Assoc.de Classe","account_template_354","other","despesa","True"
+"account_template_362","3.1.02.04.0008","Material de Limpeza","account_template_354","other","despesa","True"
+"account_template_363","3.1.02.04.0009","Seguros","account_template_354","other","despesa","True"
+"account_template_364","3.1.02.04.0010","Viagens e Estadias","account_template_354","other","despesa","True"
+"account_template_365","3.1.02.04.0011","Manutenção de Equipamentos","account_template_354","other","despesa","True"
+"account_template_366","3.1.02.04.0012","Depreciações e Amortizações","account_template_354","other","despesa","True"
+"account_template_367","3.1.02.04.0013","Combustíveis e Lubrificantes","account_template_354","other","despesa","True"
+"account_template_368","3.1.02.04.0014","Bens de Pequeno Valor","account_template_354","other","despesa","True"
+"account_template_369","3.1.02.04.0015","Leasing","account_template_354","other","despesa","True"
+"account_template_370","3.1.02.04.0016","Formação de Pessoal","account_template_354","other","despesa","True"
+"account_template_371","3.1.02.04.0017","Serviços de Terceiros - Pessoa Jurídica","account_template_354","other","despesa","True"
+"account_template_372","3.1.02.04.0018","Locação de Equipamentos","account_template_354","other","despesa","True"
+"account_template_373","3.1.02.04.0019","Feiras/Congressos/Simpósios/Cursos","account_template_354","other","despesa","True"
+"account_template_374","3.1.02.04.0020","Telefone","account_template_354","other","despesa","True"
+"account_template_375","3.1.02.04.0021","Comissões sobre Serviços","account_template_354","other","despesa","True"
+"account_template_376","3.1.02.04.0022","Jornais, Revistas e Periódicos","account_template_354","other","despesa","True"
+"account_template_377","3.1.02.04.0023","Confraternizações","account_template_354","other","despesa","True"
+"account_template_378","3.1.02.04.0024","Manutenção de Prédios","account_template_354","other","despesa","True"
+"account_template_379","3.1.02.04.0025","Brindes e Amostras","account_template_354","other","despesa","True"
+"account_template_380","3.1.02.04.0026","Aluguel de Equipamentos","account_template_354","other","despesa","True"
+"account_template_381","3.1.02.04.0027","Serv.de Terceiros P.Física - Autônomos","account_template_354","other","despesa","True"
+"account_template_382","3.1.02.04.0028","Manutenção de Veículos","account_template_354","other","despesa","True"
+"account_template_383","3.1.02.04.0029","Despesas de Importação","account_template_354","other","despesa","True"
+"account_template_384","3.1.02.04.0030","(-) Crédito PIS Não-Cumulativo","account_template_354","other","despesa","True"
+"account_template_385","3.1.02.04.0031","(-) Crédito Cofins Não-Cumulativo","account_template_354","other","despesa","True"
+"account_template_386","3.1.02.05","ESTOQUE INICIAL DE PROD.EM ELABORAÇÃO","account_template_326","view","despesa","True"
+"account_template_387","3.1.02.05.0001","Estoque Inicial de Prod. em Elaboração","account_template_386","other","despesa","True"
+"account_template_388","3.1.02.06","ESTOQUE INICIAL DE PROD.ACABADOS","account_template_326","view","despesa","True"
+"account_template_389","3.1.02.06.0001","Estoque Inicial de Prod.Acabados","account_template_388","other","despesa","True"
+"account_template_390","3.1.02.07","ESTOQUE FINAL DE PROD.EM ELABORAÇÃO","account_template_326","view","despesa","True"
+"account_template_391","3.1.02.07.0001","Estoque Final de Prod.em Elaboração","account_template_390","other","despesa","True"
+"account_template_392","3.1.02.08","ESTOQUE FINAL DE PROD.ACABADOS","account_template_326","view","despesa","True"
+"account_template_393","3.1.02.08.0001","Estoque Final de Prod.Acabados","account_template_392","other","despesa","True"
+"account_template_394","3.2","despesa","account_template_321","view","despesa","True"
+"account_template_395","3.2.01","DESPESAS OPERACIONAIS COMERCIAIS","account_template_394","view","despesa","True"
+"account_template_396","3.2.01.01","DESPESAS TRABALHISTAS","account_template_395","view","despesa","True"
+"account_template_397","3.2.01.01.0001","Salários","account_template_396","other","despesa","True"
+"account_template_398","3.2.01.01.0002","Horas Extras","account_template_396","other","despesa","True"
+"account_template_399","3.2.01.01.0003","Vale Transporte","account_template_396","other","despesa","True"
+"account_template_400","3.2.01.01.0004","Férias","account_template_396","other","despesa","True"
+"account_template_401","3.2.01.01.0005","13º Salário","account_template_396","other","despesa","True"
+"account_template_402","3.2.01.01.0006","Aviso Prévio/Indeniz.Trabalhisas","account_template_396","other","despesa","True"
+"account_template_403","3.2.01.01.0007","Gratificações","account_template_396","other","despesa","True"
+"account_template_404","3.2.01.01.0008","Assiduidade","account_template_396","other","despesa","True"
+"account_template_405","3.2.01.01.0009","Abono Salarial","account_template_396","other","despesa","True"
+"account_template_406","3.2.01.01.0010","Adicional de Insalubridade","account_template_396","other","despesa","True"
+"account_template_407","3.2.01.01.0011","Vale Refeição","account_template_396","other","despesa","True"
+"account_template_408","3.2.01.01.0012","Adicional Noturno","account_template_396","other","despesa","True"
+"account_template_409","3.2.01.01.0013","Farmácia","account_template_396","other","despesa","True"
+"account_template_410","3.2.01.01.0014","PAT - Programa Alim. Trabalhador","account_template_396","other","despesa","True"
+"account_template_411","3.2.01.01.0015","Pró-Labore","account_template_396","other","despesa","True"
+"account_template_412","3.2.01.01.0016","Assistência Médica","account_template_396","other","despesa","True"
+"account_template_413","3.2.01.02","ENCARGOS SOCIAIS","account_template_395","view","despesa","True"
+"account_template_414","3.2.01.02.0001","Inss","account_template_413","other","despesa","True"
+"account_template_415","3.2.01.02.0002","Fgts","account_template_413","other","despesa","True"
+"account_template_416","3.2.01.03","DESPESAS GERAIS COMERCIAIS","account_template_395","view","despesa","True"
+"account_template_417","3.2.01.03.0001","Comissões sobre Vendas","account_template_416","other","despesa","True"
+"account_template_418","3.2.01.03.0002","Aluguel","account_template_416","other","despesa","True"
+"account_template_419","3.2.01.03.0003","Agua e Esgoto","account_template_416","other","despesa","True"
+"account_template_420","3.2.01.03.0004","Energia Elétrica","account_template_416","other","despesa","True"
+"account_template_421","3.2.01.03.0006","Material de Expediente","account_template_416","other","despesa","True"
+"account_template_422","3.2.01.03.0007","Condução","account_template_416","other","despesa","True"
+"account_template_423","3.2.01.03.0008","Correios e Malotes","account_template_416","other","despesa","True"
+"account_template_424","3.2.01.03.0009","Material de Limpeza","account_template_416","other","despesa","True"
+"account_template_425","3.2.01.03.0010","Seguros","account_template_416","other","despesa","True"
+"account_template_426","3.2.01.03.0011","Viagens e Estadias","account_template_416","other","despesa","True"
+"account_template_427","3.2.01.03.0012","Manutenção e Conservação","account_template_416","other","despesa","True"
+"account_template_428","3.2.01.03.0013","Depreciação e Amortização","account_template_416","other","despesa","True"
+"account_template_429","3.2.01.03.0014","Propaganda e Publicidade","account_template_416","other","despesa","True"
+"account_template_430","3.2.01.03.0015","Fretes e Carretos","account_template_416","other","despesa","True"
+"account_template_431","3.2.01.03.0016","Combustíveis e Lubrificantes","account_template_416","other","despesa","True"
+"account_template_432","3.2.01.03.0017","Leasing","account_template_416","other","despesa","True"
+"account_template_433","3.2.01.03.0018","Serv.Terceiros P.Física - Autônomos","account_template_416","other","despesa","True"
+"account_template_434","3.2.01.03.0019","Serv.Terceiros Pessoa Jurídica","account_template_416","other","despesa","True"
+"account_template_435","3.2.01.03.0020","Feiras/Congressos/Simpósios/Cursos","account_template_416","other","despesa","True"
+"account_template_436","3.2.01.03.0021","Telefone","account_template_416","other","despesa","True"
+"account_template_437","3.2.01.03.0022","Despesas com Exportação","account_template_416","other","despesa","True"
+"account_template_438","3.2.01.03.0024","Jornais, Revistas e Periódicos","account_template_416","other","despesa","True"
+"account_template_439","3.2.01.03.0025","Refeições e Lanches","account_template_416","other","despesa","True"
+"account_template_440","3.2.01.03.0026","Confraternizações","account_template_416","other","despesa","True"
+"account_template_441","3.2.01.03.0027","Brindes","account_template_416","other","despesa","True"
+"account_template_442","3.2.01.03.0028","Internet","account_template_416","other","despesa","True"
+"account_template_443","3.2.02","DESPESAS ADMINISTRATIVAS","account_template_394","view","despesa","True"
+"account_template_444","3.2.02.01","DESPESAS TRABALHISTAS","account_template_443","view","despesa","True"
+"account_template_445","3.2.02.01.0001","Pro-Labore","account_template_444","other","despesa","True"
+"account_template_446","3.2.02.01.0002","Salários","account_template_444","other","despesa","True"
+"account_template_447","3.2.02.01.0003","Horas Extras","account_template_444","other","despesa","True"
+"account_template_448","3.2.02.01.0004","Férias","account_template_444","other","despesa","True"
+"account_template_449","3.2.02.01.0005","13º Salário","account_template_444","other","despesa","True"
+"account_template_450","3.2.02.01.0006","Aviso Prévio/Indeniz.Trabalhistas","account_template_444","other","despesa","True"
+"account_template_451","3.2.02.01.0007","Gratificações","account_template_444","other","despesa","True"
+"account_template_452","3.2.02.01.0008","Adicional Insalubridade","account_template_444","other","despesa","True"
+"account_template_453","3.2.02.01.0009","Adicional Noturno","account_template_444","other","despesa","True"
+"account_template_454","3.2.02.01.0010","Vale Transporte","account_template_444","other","despesa","True"
+"account_template_455","3.2.02.01.0011","Farmácia","account_template_444","other","despesa","True"
+"account_template_456","3.2.02.01.0012","Vale Refeição","account_template_444","other","despesa","True"
+"account_template_457","3.2.02.01.0013","PAT - Programa Alim. Trabalhador","account_template_444","other","despesa","True"
+"account_template_458","3.2.02.01.0014","Salário Estagiários","account_template_444","other","despesa","True"
+"account_template_459","3.2.02.01.0015","Assiduidade","account_template_444","other","despesa","True"
+"account_template_460","3.2.02.01.0016","Abono Salarial","account_template_444","other","despesa","True"
+"account_template_461","3.2.02.01.0017","Previdência Privada","account_template_444","other","despesa","True"
+"account_template_462","3.2.02.01.0018","Assistência Médica","account_template_444","other","despesa","True"
+"account_template_463","3.2.02.02","ENCARGOS SOCIAIS","account_template_443","view","despesa","True"
+"account_template_464","3.2.02.02.0001","Inss","account_template_463","other","despesa","True"
+"account_template_465","3.2.02.02.0002","Fgts","account_template_463","other","despesa","True"
+"account_template_466","3.2.02.03","DESPESAS GERAIS ADMINISTRATIVAS","account_template_443","view","despesa","True"
+"account_template_467","3.2.02.03.0001","Aluguel","account_template_466","other","despesa","True"
+"account_template_468","3.2.02.03.0002","Água e Esgoto","account_template_466","other","despesa","True"
+"account_template_469","3.2.02.03.0003","Energia Elétrica","account_template_466","other","despesa","True"
+"account_template_470","3.2.02.03.0004","Copa, Cozinha e Refeitório","account_template_466","other","despesa","True"
+"account_template_471","3.2.02.03.0005","Material de Escritório","account_template_466","other","despesa","True"
+"account_template_472","3.2.02.03.0006","Fretes e Carretos","account_template_466","other","despesa","True"
+"account_template_473","3.2.02.03.0007","Correios e Malotes","account_template_466","other","despesa","True"
+"account_template_474","3.2.02.03.0008","Material de Limpeza","account_template_466","other","despesa","True"
+"account_template_475","3.2.02.03.0009","Seguros","account_template_466","other","despesa","True"
+"account_template_476","3.2.02.03.0010","Viagens e Estadias","account_template_466","other","despesa","True"
+"account_template_477","3.2.02.03.0011","Manutenção e Conservação","account_template_466","other","despesa","True"
+"account_template_478","3.2.02.03.0012","Depreciação e Amortização","account_template_466","other","despesa","True"
+"account_template_479","3.2.02.03.0013","Sindicato Patronal/Assoc.de Classe","account_template_466","other","despesa","True"
+"account_template_480","3.2.02.03.0014","Feiras/Congressos/Simpósios/Cursos","account_template_466","other","despesa","True"
+"account_template_481","3.2.02.03.0015","Internet","account_template_466","other","despesa","True"
+"account_template_482","3.2.02.03.0016","Combustíveis e Lubrificantes","account_template_466","other","despesa","True"
+"account_template_483","3.2.02.03.0017","Leasing","account_template_466","other","despesa","True"
+"account_template_484","3.2.02.03.0018","Serviço de Terceiros - Pessoa Jurídica","account_template_466","other","despesa","True"
+"account_template_485","3.2.02.03.0019","Telefone","account_template_466","other","despesa","True"
+"account_template_486","3.2.02.03.0020","Legais e Judiciais","account_template_466","other","despesa","True"
+"account_template_487","3.2.02.03.0021","Bens de Pequeno Valor","account_template_466","other","despesa","True"
+"account_template_488","3.2.02.03.0022","Jornais Revistas e Periódicos","account_template_466","other","despesa","True"
+"account_template_489","3.2.02.03.0023","Cópias e Reproduções","account_template_466","other","despesa","True"
+"account_template_490","3.2.02.03.0024","Confraternizações","account_template_466","other","despesa","True"
+"account_template_491","3.2.02.03.0025","Formação de Pessoal","account_template_466","other","despesa","True"
+"account_template_492","3.2.02.03.0026","Segurança e Vigilância","account_template_466","other","despesa","True"
+"account_template_493","3.2.02.03.0027","Despesas com Veículos","account_template_466","other","despesa","True"
+"account_template_494","3.2.02.03.0028","Impressos","account_template_466","other","despesa","True"
+"account_template_495","3.2.02.03.0029","Refeições e Lanches","account_template_466","other","despesa","True"
+"account_template_496","3.2.02.03.0030","Comissões","account_template_466","other","despesa","True"
+"account_template_497","3.2.02.03.0031","Condução ","account_template_466","other","despesa","True"
+"account_template_498","3.2.02.03.0032","Telefone Linha Fixa","account_template_466","other","despesa","True"
+"account_template_499","3.2.02.03.0033","Telefone Móvel Celular","account_template_466","other","despesa","True"
+"account_template_500","3.2.02.03.0034","Telefone Nextel","account_template_466","other","despesa","True"
+"account_template_501","3.2.02.03.0035","Crea-PR","account_template_466","other","despesa","True"
+"account_template_502","3.2.02.03.0036","Despesas de Cartório","account_template_466","other","despesa","True"
+"account_template_503","3.2.02.03.0037","Material de Consumo","account_template_466","other","despesa","True"
+"account_template_504","3.2.02.03.0038","Donativos e Contribuições","account_template_466","other","despesa","True"
+"account_template_505","3.2.02.03.0039","Locação de Equipamentos","account_template_466","other","despesa","True"
+"account_template_506","3.2.02.04","DESPESAS INDEDUTÍVEIS","account_template_443","view","despesa","True"
+"account_template_507","3.2.02.04.0001","Autos de Infração","account_template_506","other","despesa","True"
+"account_template_508","3.2.02.04.0002","Multas Punitívas","account_template_506","other","despesa","True"
+"account_template_509","3.2.02.04.0003","Contribuições e Doações","account_template_506","other","despesa","True"
+"account_template_510","3.2.02.04.0004","Impostos Federais - Exerc. Anteriores","account_template_506","other","despesa","True"
+"account_template_511","3.2.02.04.0005","Impostos Estaduais - Exerc. Anteriores","account_template_506","other","despesa","True"
+"account_template_512","3.2.02.04.0006","Impostos Municipais - Exerc.Anteriores","account_template_506","other","despesa","True"
+"account_template_513","3.2.03","DESPESAS FINANCEIRAS","account_template_394","view","despesa","True"
+"account_template_514","3.2.03.01","DESPESAS COM ATUALIZAÇÕES","account_template_513","view","despesa","True"
+"account_template_515","3.2.03.01.0001","Variação Monetária Passiva","account_template_514","other","despesa","True"
+"account_template_516","3.2.03.01.0002","Variação Cambial Passiva","account_template_514","other","despesa","True"
+"account_template_517","3.2.03.01.0003","Despesas de Cobrança","account_template_514","other","despesa","True"
+"account_template_518","3.2.03.01.0004","Despesas Bancárias","account_template_514","other","despesa","True"
+"account_template_519","3.2.03.02","JUROS E DESCONTOS","account_template_513","view","despesa","True"
+"account_template_520","3.2.03.02.0001","Juros de Mora","account_template_519","other","despesa","True"
+"account_template_521","3.2.03.02.0002","Descontos Concedidos","account_template_519","other","despesa","True"
+"account_template_522","3.2.03.02.0003","Juros s/ Empréstimos e Financiamentos","account_template_519","other","despesa","True"
+"account_template_523","3.2.03.02.0004","Juros s/ Descontos de Duplicatas","account_template_519","other","despesa","True"
+"account_template_524","3.2.04","DESPESAS TRIBUTÁRIAS","account_template_394","view","despesa","True"
+"account_template_525","3.2.04.01","IMPOSTOS, TAXAS E CONTRIBUIÇÕES","account_template_524","view","despesa","True"
+"account_template_526","3.2.04.01.0001","IOF","account_template_525","other","despesa","True"
+"account_template_527","3.2.04.01.0002","CPMF","account_template_525","other","despesa","True"
+"account_template_528","3.2.04.01.0003","IPTU","account_template_525","other","despesa","True"
+"account_template_529","3.2.04.01.0004","IPVA","account_template_525","other","despesa","True"
+"account_template_530","3.2.04.01.0005","IRF (Exclusivo na Fonte)","account_template_525","other","despesa","True"
+"account_template_531","3.2.04.01.0006","Impostos e Taxas Federais","account_template_525","other","despesa","True"
+"account_template_532","3.2.04.01.0007","Impostos e Taxas Estaduais","account_template_525","other","despesa","True"
+"account_template_533","3.2.04.01.0008","Impostos e Taxas Municipais","account_template_525","other","despesa","True"
+"account_template_534","3.2.04.02","MULTAS","account_template_524","view","despesa","True"
+"account_template_535","3.2.04.02.0001","Multas Fiscais Compensatórias","account_template_534","other","despesa","True"
+"account_template_536","3.2.04.02.0002","Multas de Mora","account_template_534","other","despesa","True"
+"account_template_537","3.2.04.02.0003","Multas Contratuais","account_template_534","other","despesa","True"
+"account_template_538","3.2.05","OUTRAS DESPESAS OPERACIONAIS","account_template_394","view","despesa","True"
+"account_template_539","3.2.05.01","PERDAS","account_template_538","view","despesa","True"
+"account_template_540","3.2.05.01.0001","Perdas com Duplicatas Incobráveis","account_template_539","other","despesa","True"
+"account_template_541","3.2.06","DESPESAS NÃO OPERACIONAIS","account_template_394","view","despesa","True"
+"account_template_542","3.2.06.01","PERDAS","account_template_541","view","despesa","True"
+"account_template_543","3.2.06.01.0002","Perda crédito de ICMS s/ Imobilizado","account_template_542","other","despesa","True"
+"account_template_544","3.2.06.01.0003","Perdas com Sinistros","account_template_542","other","despesa","True"
+"account_template_545","3.2.06.01.0004","Perdas na Alienação de Imobilizado","account_template_542","other","despesa","True"
+"account_template_546","3.2.06.01.0001","Perdas na Alienação de Investimentos","account_template_542","other","despesa","True"
+"account_template_547","3.2.06.01.0005","Perdas, Deterioração de Mercadorias","account_template_542","other","despesa","True"
+"account_template_548","4","CONTAS DE RESULTADO - RECEITAS","account_template_1","view","receita","True"
+"account_template_549","4.1","RECEITAS","account_template_548","view","receita","True"
+"account_template_550","4.1.01","RECEITAS OPERACIONAIS VENDAS E SERVIÇOS","account_template_549","view","receita","True"
+"account_template_551","4.1.01.01","RECEITA BRUTA VENDAS NO PAÍS ","account_template_550","view","receita","True"
+"account_template_552","4.1.01.01.0001","Venda Produtos Fabricação Própria","account_template_551","other","receita","True"
+"account_template_553","4.1.01.01.0002","Industrialização de Mercadorias","account_template_551","other","receita","True"
+"account_template_554","4.1.01.01.0003","Revenda de Mercadorias","account_template_551","other","receita","True"
+"account_template_555","4.1.01.01.0004","Venda Fabricação Própria","account_template_551","other","receita","True"
+"account_template_556","4.1.01.01.0005","Industriazalição de Mercadorias","account_template_551","other","receita","True"
+"account_template_557","4.1.01.01.0006","Revenda de Mercadorias","account_template_551","other","receita","True"
+"account_template_558","4.1.01.02","RECEITA DE SERVIÇOS NO PAIS ","account_template_550","view","receita","True"
+"account_template_559","4.1.01.02.0001","Receita de Serviços","account_template_558","other","receita","True"
+"account_template_560","4.1.01.02.0002","Receita de Serviços","account_template_558","other","receita","True"
+"account_template_561","4.1.01.03","RECEITA BRUTA DE VENDAS P/EXTERIOR","account_template_550","view","receita","True"
+"account_template_562","4.1.01.03.0001","Venda de Produtos Fabricação Própria(EX)","account_template_561","other","receita","True"
+"account_template_563","4.1.01.03.0002","Revenda de Mercadorias (EX)","account_template_561","other","receita","True"
+"account_template_564","4.1.02","(-) DEDUÇÕES DA RECEITA BRUTA","account_template_549","view","receita","True"
+"account_template_565","4.1.02.01","DEVOLUÇÕES E ABATIMENTOS","account_template_564","view","receita","True"
+"account_template_566","4.1.02.01.0001","Devolução de Vendas","account_template_565","other","receita","True"
+"account_template_567","4.1.02.01.0002","Abatimentos Concedidos","account_template_565","other","receita","True"
+"account_template_568","4.1.02.01.0003","Devolução de Vendas","account_template_565","other","receita","True"
+"account_template_569","4.1.02.01.0004","Abatimentos Concedidos","account_template_565","other","receita","True"
+"account_template_570","4.1.02.02","IMPOSTOS SOBRE VENDAS E SERVIÇOS","account_template_564","view","receita","True"
+"account_template_571","4.1.02.02.0001","ICMS sobre Vendas","account_template_570","other","receita","True"
+"account_template_572","4.1.02.02.0002","IPI sobre Vendas","account_template_570","other","receita","True"
+"account_template_573","4.1.02.02.0003","PIS sobre Vendas ","account_template_570","other","receita","True"
+"account_template_574","4.1.02.02.0004","COFINS sobre Vendas","account_template_570","other","receita","True"
+"account_template_575","4.1.02.02.0005","ISS sobre Serviços","account_template_570","other","receita","True"
+"account_template_579","4.1.02.03","(-) IMPOSTOS S/ DEVOLUÇÃO DE VENDAS","account_template_564","view","receita","True"
+"account_template_580","4.1.02.03.0001","(-) Cofins Não-Cumulativo s/ Dev. Vendas","account_template_579","other","receita","True"
+"account_template_581","4.1.02.03.0002","(-) ICMS sobre Devolução de Vendas","account_template_579","other","receita","True"
+"account_template_582","4.1.02.03.0003","(-) IPI s/Devolução de Vendas","account_template_579","other","receita","True"
+"account_template_583","4.1.02.03.0004","(-) Pis Não-Cumulativo s/ Dev. Vendas","account_template_579","other","receita","True"
+"account_template_584","4.1.03","RECEITAS FINANCEIRAS","account_template_549","view","receita","True"
+"account_template_585","4.1.03.01","RECEITAS COM ATUALIZAÇÕES","account_template_584","view","receita","True"
+"account_template_586","4.1.03.01.0001","Variação Monetária Ativa","account_template_585","other","receita","True"
+"account_template_587","4.1.03.01.0002","Variação Cambial Ativa","account_template_585","other","receita","True"
+"account_template_588","4.1.03.02","GANHOS COM APLICAÇÕES FINANCEIRAS","account_template_584","view","receita","True"
+"account_template_589","4.1.03.02.0001","Rend. Aplic.Automática C/Corrente","account_template_588","other","receita","True"
+"account_template_590","4.1.03.02.0002","Ganho Real Aplicações Renda Fixa","account_template_588","other","receita","True"
+"account_template_591","4.1.03.02.0003","Ganho Real Aplic.Renda Variável","account_template_588","other","receita","True"
+"account_template_592","4.1.03.02.0004","Rendimento Caderneta de Poupança","account_template_588","other","receita","True"
+"account_template_593","4.1.03.03","JUROS E DESCONTOS OBTIDOS","account_template_584","view","receita","True"
+"account_template_594","4.1.03.03.0001","Juros Recebidos","account_template_593","other","receita","True"
+"account_template_595","4.1.03.03.0002","Descontos Obtidos","account_template_593","other","receita","True"
+"account_template_596","4.1.03.04","(-) TRIBUTOS S/RECEITAS FINANCEIRAS","account_template_584","view","receita","True"
+"account_template_597","4.1.03.04.0001","PIS sobre Receitas Financeiras","account_template_596","other","receita","True"
+"account_template_598","4.1.03.04.0002","COFINS sobre Receitas Financeiras","account_template_596","other","receita","True"
+"account_template_599","4.1.04","OUTRAS RECEITAS OPERACIONAIS","account_template_549","view","receita","True"
+"account_template_600","4.1.04.01","LUCROS PARTIC.EM OUTRAS SOCIEDADES","account_template_599","view","receita","True"
+"account_template_601","4.1.04.01.0001","Resultado de Coligadas e Controladas","account_template_600","other","receita","True"
+"account_template_602","4.1.04.02","VENDAS DIVERSAS","account_template_599","view","receita","True"
+"account_template_603","4.1.04.02.0001","Venda de Sucatas","account_template_602","other","receita","True"
+"account_template_604","4.1.04.03","BRINDES E AMOSTRAS","account_template_599","view","receita","True"
+"account_template_605","4.1.04.03.0001","Brindes e Bonificações","account_template_604","other","receita","True"
+"account_template_606","4.1.04.03.0002","Amostras","account_template_604","other","receita","True"
+"account_template_607","4.2","RESULTADOS NÃO OPERACIONAIS","account_template_548","view","receita","True"
+"account_template_608","4.2.01","ALIENAÇÃO DE BENS PERMANENTES","account_template_607","view","receita","True"
+"account_template_609","4.2.01.01","ALIENAÇÃO DE INVESTIMENTOS","account_template_608","view","receita","True"
+"account_template_610","4.2.01.01.0001","Dividendos Recebidos","account_template_609","other","receita","True"
+"account_template_611","4.2.01.01.0002","Alienação Partic.Societárias","account_template_609","other","receita","True"
+"account_template_612","4.2.01.02","ALIENAÇÃO DE IMOBILIZADO","account_template_608","view","receita","True"
+"account_template_613","4.2.01.02.0001","Alienação de Máquinas e Equipamentos","account_template_612","other","receita","True"
+"account_template_614","4.2.01.02.0002","Alienação de Móveis e Utensílios","account_template_612","other","receita","True"
+"account_template_615","4.2.01.02.0003","Alienação de Ferramentas","account_template_612","other","receita","True"
+"account_template_616","4.2.01.02.0004","Alienação de Imóveis","account_template_612","other","receita","True"
+"account_template_617","4.2.01.02.0005","Alienação de Veículos","account_template_612","other","receita","True"
+"account_template_618","4.2.01.02.0006","Alienação de Equip.de Informática","account_template_612","other","receita","True"
+"account_template_619","4.2.02","DEDUÇÕES DAS ALIENAÇÕES DE BENS","account_template_607","view","receita","True"
+"account_template_620","4.2.02.01","CUSTO DA ALIENAÇÃO DE INVESTIMENTOS","account_template_619","view","receita","True"
+"account_template_621","4.2.02.01.0001","Custo Alienação Partic.Societárias","account_template_620","other","receita","True"
+"account_template_622","4.2.02.02","CUSTO DA ALIENAÇÃO DE IMOBILIZADO","account_template_619","view","receita","True"
+"account_template_623","4.2.02.02.0001","Custo Alienação Máqs.e Equipamentos","account_template_622","other","receita","True"
+"account_template_624","4.2.02.02.0002","Custo Alienação Movs.e Utensílios","account_template_622","other","receita","True"
+"account_template_625","4.2.02.02.0003","Custo Alienação Ferramentas","account_template_622","other","receita","True"
+"account_template_626","4.2.02.02.0004","Custo Alienação de Imóveis","account_template_622","other","receita","True"
+"account_template_627","4.2.02.02.0005","Custo Alienação de Veículos","account_template_622","other","receita","True"
+"account_template_628","4.2.02.02.0006","Custo Alienação Equip.Informática","account_template_622","other","receita","True"
+"account_template_629","4.2.03","OUTRAS RECEITAS NÃO OPERACIONAIS","account_template_607","view","receita","True"
+"account_template_630","4.2.03.01","INDENIZAÇÃO DE SEGUROS","account_template_629","view","receita","True"
+"account_template_631","4.2.03.01.0001","Indenização de Seguros","account_template_630","other","receita","True"
+"account_template_632","4.2.03.02","OUTRAS RECEITAS","account_template_629","view","receita","True"
+"account_template_633","4.2.03.02.0001","Recuperação de Despesas","account_template_632","other","receita","True"
+"account_template_634","5","CONTAS DE FECHAMENTO DE BALANÇO","account_template_1","view","resultado","True"
+"account_template_635","5.1","RESULTADO DO EXERCÍCIO","account_template_634","view","resultado","True"
+"account_template_636","5.1.01","RESULTADO OPERACIONAL","account_template_635","view","resultado","True"
+"account_template_637","5.1.01.01","PROVISÃO IMPOSTOS E CONTRIB. S/ O LUCRO","account_template_636","view","resultado","True"
+"account_template_638","5.1.01.01.0001","Provisão para IRPJ","account_template_637","closed","resultado","True"
+"account_template_639","5.1.01.01.0002","Provisão para Contribuição Social","account_template_637","closed","resultado","True"
+"account_template_640","5.1.01.02","RESULTADO FINAL DO EXERCÍCIO","account_template_636","view","resultado","True"
+"account_template_641","5.1.01.02.0001","Resultado Líquido do Exercício","account_template_640","closed","resultado","True"
=== added file 'l10n_br/data/account.account.type.csv'
--- l10n_br/data/account.account.type.csv 1970-01-01 00:00:00 +0000
+++ l10n_br/data/account.account.type.csv 2012-05-03 23:39:20 +0000
@@ -0,0 +1,7 @@
+"id","code","name","close_method"
+"ativo","1","Ativo","unreconciled"
+"passivo","2","Passivo","unreconciled"
+"despesa","3","Despesas","balance"
+"receita","4","Receita","balance"
+"resultado","5","Resultado","balance"
+
=== added file 'l10n_br/data/account.tax.code.template.csv'
--- l10n_br/data/account.tax.code.template.csv 1970-01-01 00:00:00 +0000
+++ l10n_br/data/account.tax.code.template.csv 2012-05-03 23:39:20 +0000
@@ -0,0 +1,11 @@
+"id","code","name","parent_id:id","sign","domain","tax_discount","tax_include"
+"tax_code_chart_root","","Códigos de Impostos Brasileiros","","1","",False,False
+"tax_code_1","ICMS","ICMS","tax_code_chart_root","1","icms",True,True
+"tax_code_3","ICMS Subist","ICMS Subist","tax_code_chart_root","1","icmsst",True,True
+"tax_code_4","IPI","IPI","tax_code_chart_root","1","ipi",True,False
+"tax_code_5","PIS","PIS","tax_code_chart_root","1","pis",True,True
+"tax_code_6","COFINS","COFINS","tax_code_chart_root","1","cofins",True,True
+"tax_code_7","IRPJ","IRPJ","tax_code_chart_root","1","irpj",True,True
+"tax_code_8","IR","IR","tax_code_chart_root","1","ir",True,True
+"tax_code_9","ISS","ISS","tax_code_chart_root","1","iss",True,False
+"tax_code_10","CSLL","CSLL","tax_code_chart_root","1","csll",True,True
=== added file 'l10n_br/data/account_tax_template.xml'
--- l10n_br/data/account_tax_template.xml 1970-01-01 00:00:00 +0000
+++ l10n_br/data/account_tax_template.xml 2012-05-03 23:39:20 +0000
@@ -0,0 +1,755 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data noupdate="True">
+
+ <record id="tax_template_1" model="account.tax.template">
+ <field name="description">IPI</field>
+ <field name="name">IPI</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_3" model="account.tax.template">
+ <field name="description">IPI 2%</field>
+ <field name="name">IPI 2%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.02</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_4" model="account.tax.template">
+ <field name="description">IPI 3%</field>
+ <field name="name">IPI 3%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.03</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_5" model="account.tax.template">
+ <field name="description">IPI 4%</field>
+ <field name="name">IPI 4%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.04</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_6" model="account.tax.template">
+ <field name="description">IPI 5%</field>
+ <field name="name">IPI 5%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.05</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_7" model="account.tax.template">
+ <field name="description">IPI 7%</field>
+ <field name="name">IPI 7%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.07</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_8" model="account.tax.template">
+ <field name="description">IPI 8%</field>
+ <field name="name">IPI 8%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.08</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_9" model="account.tax.template">
+ <field name="description">IPI 10%</field>
+ <field name="name">IPI 10%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.10</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_10" model="account.tax.template">
+ <field name="description">IPI 12%</field>
+ <field name="name">IPI 12%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.12</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_11" model="account.tax.template">
+ <field name="description">IPI 13%</field>
+ <field name="name">IPI 13%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.13</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_12" model="account.tax.template">
+ <field name="description">IPI 15%</field>
+ <field name="name">IPI 15%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.15</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_13" model="account.tax.template">
+ <field name="description">IPI 16%</field>
+ <field name="name">IPI 16%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.16</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_14" model="account.tax.template">
+ <field name="description">IPI 18%</field>
+ <field name="name">IPI 18%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.18</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_15" model="account.tax.template">
+ <field name="description">IPI 20%</field>
+ <field name="name">IPI 20%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.20</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_16" model="account.tax.template">
+ <field name="description">IPI 22%</field>
+ <field name="name">IPI 22%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.22</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">False</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_17" model="account.tax.template">
+ <field name="description">IPI 25%</field>
+ <field name="name">IPI 25%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.25</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_18" model="account.tax.template">
+ <field name="description">IPI 27%</field>
+ <field name="name">IPI 27%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.27</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_19" model="account.tax.template">
+ <field name="description">IPI 30%</field>
+ <field name="name">IPI 30%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.30</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_20" model="account.tax.template">
+ <field name="description">IPI 35%</field>
+ <field name="name">IPI 35%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.35</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_21" model="account.tax.template">
+ <field name="description">IPI 40%</field>
+ <field name="name">IPI 40%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.40</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_22" model="account.tax.template">
+ <field name="description">IPI 42%</field>
+ <field name="name">IPI 42%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.42</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_23" model="account.tax.template">
+ <field name="description">IPI 45%</field>
+ <field name="name">IPI 45%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.45</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_24" model="account.tax.template">
+ <field name="description">IPI 50%</field>
+ <field name="name">IPI 50%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.50</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_25" model="account.tax.template">
+ <field name="description">IPI 60%</field>
+ <field name="name">IPI 60%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.60</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_26" model="account.tax.template">
+ <field name="description">IPI 330%</field>
+ <field name="name">IPI 330%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">3.30</field>
+ <field ref="account_template_244" name="account_collected_id"/>
+ <field ref="account_template_44" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_4" name="base_code_id"/>
+ <field ref="tax_code_4" name="tax_code_id"/>
+ <field ref="tax_code_4" name="ref_base_code_id"/>
+ <field ref="tax_code_4" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_27" model="account.tax.template">
+ <field name="description">ICMS Interno</field>
+ <field name="name">ICMS Interno</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_28" model="account.tax.template">
+ <field name="description">ICMS Externo</field>
+ <field name="name">ICMS Externo</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_29" model="account.tax.template">
+ <field name="description">ICMS Subist</field>
+ <field name="name">ICMS Subist</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_3" name="base_code_id"/>
+ <field ref="tax_code_3" name="tax_code_id"/>
+ <field ref="tax_code_3" name="ref_base_code_id"/>
+ <field ref="tax_code_3" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_30" model="account.tax.template">
+ <field name="description">ICMS 7%</field>
+ <field name="name">ICMS 7%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.07</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_31" model="account.tax.template">
+ <field name="description">ICMS 12%</field>
+ <field name="name">ICMS 12%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.12</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_32" model="account.tax.template">
+ <field name="description">ICMS 19%</field>
+ <field name="name">ICMS 19%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.19</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_33" model="account.tax.template">
+ <field name="description">ICMS 26%</field>
+ <field name="name">ICMS 26%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.26</field>
+ <field ref="account_template_241" name="account_collected_id"/>
+ <field ref="account_template_42" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_1" name="base_code_id"/>
+ <field ref="tax_code_1" name="tax_code_id"/>
+ <field ref="tax_code_1" name="ref_base_code_id"/>
+ <field ref="tax_code_1" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_34" model="account.tax.template">
+ <field name="description">PIS</field>
+ <field name="name">PIS</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field ref="account_template_243" name="account_collected_id"/>
+ <field ref="account_template_49" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_5" name="base_code_id"/>
+ <field ref="tax_code_5" name="tax_code_id"/>
+ <field ref="tax_code_5" name="ref_base_code_id"/>
+ <field ref="tax_code_5" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_35" model="account.tax.template">
+ <field name="description">PIS 0,65%</field>
+ <field name="name">PIS 0,65%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.0065</field>
+ <field ref="account_template_243" name="account_collected_id"/>
+ <field ref="account_template_49" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_5" name="base_code_id"/>
+ <field ref="tax_code_5" name="tax_code_id"/>
+ <field ref="tax_code_5" name="ref_base_code_id"/>
+ <field ref="tax_code_5" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_36" model="account.tax.template">
+ <field name="description">COFINS</field>
+ <field name="name">COFINS</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field ref="account_template_242" name="account_collected_id"/>
+ <field ref="account_template_39" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_6" name="base_code_id"/>
+ <field ref="tax_code_6" name="tax_code_id"/>
+ <field ref="tax_code_6" name="ref_base_code_id"/>
+ <field ref="tax_code_6" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_37" model="account.tax.template">
+ <field name="description">COFINS 3%</field>
+ <field name="name">COFINS 3%</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.03</field>
+ <field ref="account_template_242" name="account_collected_id"/>
+ <field ref="account_template_39" name="account_paid_id"/>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_6" name="base_code_id"/>
+ <field ref="tax_code_6" name="tax_code_id"/>
+ <field ref="tax_code_6" name="ref_base_code_id"/>
+ <field ref="tax_code_6" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_38" model="account.tax.template">
+ <field name="description">IRPJ</field>
+ <field name="name">IRPJ</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_7" name="base_code_id"/>
+ <field ref="tax_code_7" name="tax_code_id"/>
+ <field ref="tax_code_7" name="ref_base_code_id"/>
+ <field ref="tax_code_7" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_39" model="account.tax.template">
+ <field name="description">IR</field>
+ <field name="name">IR</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_8" name="base_code_id"/>
+ <field ref="tax_code_8" name="tax_code_id"/>
+ <field ref="tax_code_8" name="ref_base_code_id"/>
+ <field ref="tax_code_8" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_40" model="account.tax.template">
+ <field name="description">ISS</field>
+ <field name="name">ISS</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">True</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">False</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_9" name="base_code_id"/>
+ <field ref="tax_code_9" name="tax_code_id"/>
+ <field ref="tax_code_9" name="ref_base_code_id"/>
+ <field ref="tax_code_9" name="ref_tax_code_id"/>
+ </record>
+
+ <record id="tax_template_41" model="account.tax.template">
+ <field name="description">CSLL</field>
+ <field name="name">CSLL</field>
+ <field name="tax_group">vat</field>
+ <field name="amount">0.00</field>
+ <field name="price_include">False</field>
+ <field name="tax_discount">True</field>
+ <field name="tax_add">False</field>
+ <field name="tax_retain">False</field>
+ <field name="tax_include">True</field>
+ <field ref="l10n_br_account_chart_template" name="chart_template_id"/>
+ <field ref="tax_code_10" name="base_code_id"/>
+ <field ref="tax_code_10" name="tax_code_id"/>
+ <field ref="tax_code_10" name="ref_base_code_id"/>
+ <field ref="tax_code_10" name="ref_tax_code_id"/>
+ </record>
+ </data>
+</openerp>
=== added file 'l10n_br/data/l10n_br_account_chart_template.xml'
--- l10n_br/data/l10n_br_account_chart_template.xml 1970-01-01 00:00:00 +0000
+++ l10n_br/data/l10n_br_account_chart_template.xml 2012-05-03 23:39:20 +0000
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+<openerp>
+ <data>
+
+ <record id="l10n_br_account_chart_template" model="account.chart.template">
+ <field name="name">Planilha de Contas Brasileira</field>
+ <field name="account_root_id" ref="account_template_1" />
+ <field name="tax_code_root_id" ref="tax_code_chart_root"/>
+ <field name="bank_account_view_id" ref="account_template_9"/>
+ <field name="property_account_receivable" ref="account_template_16"/>
+ <field name="property_account_payable" ref="account_template_204" />
+ <field name="property_account_expense_categ" ref="account_template_330" />
+ <field name="property_account_income_categ" ref="account_template_552" />
+ </record>
+
+ <record id="config_call_account_template_brazilian_localization" model="ir.actions.todo">
+ <field name="name">Generate Chart of Accounts from a Chart Template</field>
+ <field name="note">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.
+ This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template.</field>
+ <field name="action_id" ref="account.action_wizard_multi_chart"/>
+ <field name="state">open</field>
+ <field name="type">once</field>
+ </record>
+
+ </data>
+
+</openerp>
=== added file 'l10n_br/data/l10n_br_data.xml'
--- l10n_br/data/l10n_br_data.xml 1970-01-01 00:00:00 +0000
+++ l10n_br/data/l10n_br_data.xml 2012-05-03 23:39:20 +0000
@@ -0,0 +1,673 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data noupdate="1">
+
+ <!-- l10n_br_account.cst.template -->
+ <record id="l10n_br_cst_template_1" model="l10n_br_account.cst.template">
+ <field name="code">01</field>
+ <field name="name">Operação Tributável com Alíquota Básica</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_2" model="l10n_br_account.cst.template">
+ <field name="code">02</field>
+ <field name="name">Operação Tributável com Alíquota Diferenciada</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_3" model="l10n_br_account.cst.template">
+ <field name="code">03</field>
+ <field name="name">Operação Tributável com Alíquota por Unidade de Medida de Produto</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_4" model="l10n_br_account.cst.template">
+ <field name="code">04</field>
+ <field name="name">Operação Tributável Monofásica - Revenda a Alíquota Zero</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_5" model="l10n_br_account.cst.template">
+ <field name="code">05</field>
+ <field name="name">Operação Tributável por Substituição Tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_6" model="l10n_br_account.cst.template">
+ <field name="code">06</field>
+ <field name="name">Operação Tributável a Alíquota zero</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_7" model="l10n_br_account.cst.template">
+ <field name="code">07</field>
+ <field name="name">Operação Isenta da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_8" model="l10n_br_account.cst.template">
+ <field name="code">08</field>
+ <field name="name">Operação sem Incidência da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_9" model="l10n_br_account.cst.template">
+ <field name="code">09</field>
+ <field name="name">Operação com Suspensão da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_10" model="l10n_br_account.cst.template">
+ <field name="code">49</field>
+ <field name="name">Outras Operações de Saída</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_11" model="l10n_br_account.cst.template">
+ <field name="code">50</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_12" model="l10n_br_account.cst.template">
+ <field name="code">51</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita Não-Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_13" model="l10n_br_account.cst.template">
+ <field name="code">52</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_14" model="l10n_br_account.cst.template">
+ <field name="code">53</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_15" model="l10n_br_account.cst.template">
+ <field name="code">54</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_16" model="l10n_br_account.cst.template">
+ <field name="code">55</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Não Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_17" model="l10n_br_account.cst.template">
+ <field name="code">56</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_18" model="l10n_br_account.cst.template">
+ <field name="code">60</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_19" model="l10n_br_account.cst.template">
+ <field name="code">61</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita Não-Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_20" model="l10n_br_account.cst.template">
+ <field name="code">62</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_21" model="l10n_br_account.cst.template">
+ <field name="code">63</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_22" model="l10n_br_account.cst.template">
+ <field name="code">64</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_23" model="l10n_br_account.cst.template">
+ <field name="code">65</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Não-Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_24" model="l10n_br_account.cst.template">
+ <field name="code">66</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_25" model="l10n_br_account.cst.template">
+ <field name="code">67</field>
+ <field name="name">Crédito Presumido - Outras Operações</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_26" model="l10n_br_account.cst.template">
+ <field name="code">70</field>
+ <field name="name">Operação de Aquisição sem Direito a Crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_27" model="l10n_br_account.cst.template">
+ <field name="code">71</field>
+ <field name="name">Operação de Aquisição com Isenção</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_28" model="l10n_br_account.cst.template">
+ <field name="code">72</field>
+ <field name="name">Operação de Aquisição com Suspensão</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_29" model="l10n_br_account.cst.template">
+ <field name="code">73</field>
+ <field name="name">Operação de Aquisição a Alíquota Zero</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_30" model="l10n_br_account.cst.template">
+ <field name="code">74</field>
+ <field name="name">Operação de Aquisição sem Incidência da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_31" model="l10n_br_account.cst.template">
+ <field name="code">75</field>
+ <field name="name">Operação de Aquisição por Substituição Tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_32" model="l10n_br_account.cst.template">
+ <field name="code">98</field>
+ <field name="name">Outras Operações de Entrada</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_33" model="l10n_br_account.cst.template">
+ <field name="code">99</field>
+ <field name="name">Outras Operações</field>
+ <field name="tax_code_template_id" ref="tax_code_5" />
+ </record>
+
+ <record id="l10n_br_cst_template_34" model="l10n_br_account.cst.template">
+ <field name="code">01</field>
+ <field name="name">Operação Tributável com Alíquota Básica</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_35" model="l10n_br_account.cst.template">
+ <field name="code">02</field>
+ <field name="name">Operação Tributável com Alíquota Diferenciada</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_36" model="l10n_br_account.cst.template">
+ <field name="code">03</field>
+ <field name="name">Operação Tributável com Alíquota por Unidade de Medida de Produto</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_37" model="l10n_br_account.cst.template">
+ <field name="code">04</field>
+ <field name="name">Operação Tributável Monofásica - Revenda a Alíquota Zero</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_38" model="l10n_br_account.cst.template">
+ <field name="code">05</field>
+ <field name="name">Operação Tributável por Substituição Tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_39" model="l10n_br_account.cst.template">
+ <field name="code">06</field>
+ <field name="name">Operação Tributável a Alíquota Zero</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_40" model="l10n_br_account.cst.template">
+ <field name="code">07</field>
+ <field name="name">Operação Isenta da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_41" model="l10n_br_account.cst.template">
+ <field name="code">08</field>
+ <field name="name">Operação sem Incidência da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_42" model="l10n_br_account.cst.template">
+ <field name="code">09</field>
+ <field name="name">Operação com Suspensão da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_43" model="l10n_br_account.cst.template">
+ <field name="code">49</field>
+ <field name="name">Outras Operações de Saída</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_44" model="l10n_br_account.cst.template">
+ <field name="code">50</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_45" model="l10n_br_account.cst.template">
+ <field name="code">51</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita Não Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_46" model="l10n_br_account.cst.template">
+ <field name="code">52</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada Exclusivamente a Receita de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_47" model="l10n_br_account.cst.template">
+ <field name="code">53</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_48" model="l10n_br_account.cst.template">
+ <field name="code">54</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_49" model="l10n_br_account.cst.template">
+ <field name="code">55</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Não-Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_50" model="l10n_br_account.cst.template">
+ <field name="code">56</field>
+ <field name="name">Operação com Direito a Crédito - Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno, e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_51" model="l10n_br_account.cst.template">
+ <field name="code">60</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_52" model="l10n_br_account.cst.template">
+ <field name="code">61</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita Não-Tributada no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_53" model="l10n_br_account.cst.template">
+ <field name="code">62</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada Exclusivamente a Receita de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_54" model="l10n_br_account.cst.template">
+ <field name="code">63</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_55" model="l10n_br_account.cst.template">
+ <field name="code">64</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_56" model="l10n_br_account.cst.template">
+ <field name="code">65</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Não-Tributadas no Mercado Interno e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_57" model="l10n_br_account.cst.template">
+ <field name="code">66</field>
+ <field name="name">Crédito Presumido - Operação de Aquisição Vinculada a Receitas Tributadas e Não-Tributadas no Mercado Interno, e de Exportação</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_58" model="l10n_br_account.cst.template">
+ <field name="code">67</field>
+ <field name="name">Crédito Presumido - Outras Operações</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_59" model="l10n_br_account.cst.template">
+ <field name="code">70</field>
+ <field name="name">Operação de Aquisição sem Direito a Crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_60" model="l10n_br_account.cst.template">
+ <field name="code">71</field>
+ <field name="name">Operação de Aquisição com Isenção</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_61" model="l10n_br_account.cst.template">
+ <field name="code">72</field>
+ <field name="name">Operação de Aquisição com Suspensão</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_62" model="l10n_br_account.cst.template">
+ <field name="code">73</field>
+ <field name="name">Operação de Aquisição a Alíquota Zero</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_63" model="l10n_br_account.cst.template">
+ <field name="code">74</field>
+ <field name="name">Operação de Aquisição sem Incidência da Contribuição</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_64" model="l10n_br_account.cst.template">
+ <field name="code">75</field>
+ <field name="name">Operação de Aquisição por Substituição Tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_65" model="l10n_br_account.cst.template">
+ <field name="code">98</field>
+ <field name="name">Outras Operações de Entrada</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_66" model="l10n_br_account.cst.template">
+ <field name="code">99</field>
+ <field name="name">Outras Operações</field>
+ <field name="tax_code_template_id" ref="tax_code_4" />
+ </record>
+
+ <record id="l10n_br_cst_template_67" model="l10n_br_account.cst.template">
+ <field name="code">00</field>
+ <field name="name">Entrada com recuperação de crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_68" model="l10n_br_account.cst.template">
+ <field name="code">01</field>
+ <field name="name">Entrada tributada com alíquota zero</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_69" model="l10n_br_account.cst.template">
+ <field name="code">02</field>
+ <field name="name">Entrada isenta</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_70" model="l10n_br_account.cst.template">
+ <field name="code">03</field>
+ <field name="name">Entrada não-tributada</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_71" model="l10n_br_account.cst.template">
+ <field name="code">04</field>
+ <field name="name">Entrada imune</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_72" model="l10n_br_account.cst.template">
+ <field name="code">05</field>
+ <field name="name">Entrada com suspensão</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_73" model="l10n_br_account.cst.template">
+ <field name="code">49</field>
+ <field name="name">Outras entradas</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_74" model="l10n_br_account.cst.template">
+ <field name="code">50</field>
+ <field name="name">Saída tributada</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_75" model="l10n_br_account.cst.template">
+ <field name="code">51</field>
+ <field name="name">Saída tributada com alíquota zero</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_76" model="l10n_br_account.cst.template">
+ <field name="code">52</field>
+ <field name="name">Saída isenta</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_77" model="l10n_br_account.cst.template">
+ <field name="code">53</field>
+ <field name="name">Saída não-tributada</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_78" model="l10n_br_account.cst.template">
+ <field name="code">54</field>
+ <field name="name">Saída imune</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_79" model="l10n_br_account.cst.template">
+ <field name="code">55</field>
+ <field name="name">Saída com suspensão</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_80" model="l10n_br_account.cst.template">
+ <field name="code">99</field>
+ <field name="name">Outras saídas</field>
+ <field name="tax_code_template_id" ref="tax_code_3" />
+ </record>
+
+ <record id="l10n_br_cst_template_92" model="l10n_br_account.cst.template">
+ <field name="code">00</field>
+ <field name="name">Tributada integralmente</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_93" model="l10n_br_account.cst.template">
+ <field name="code">10</field>
+ <field name="name">Tributada e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_94" model="l10n_br_account.cst.template">
+ <field name="code">20</field>
+ <field name="name">Com redução de base de cálculo</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_95" model="l10n_br_account.cst.template">
+ <field name="code">30</field>
+ <field name="name">Isenta ou não tributada e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_96" model="l10n_br_account.cst.template">
+ <field name="code">40</field>
+ <field name="name">Isenta</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_97" model="l10n_br_account.cst.template">
+ <field name="code">41</field>
+ <field name="name">Não tributada</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_98" model="l10n_br_account.cst.template">
+ <field name="code">50</field>
+ <field name="name">Suspensão</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_99" model="l10n_br_account.cst.template">
+ <field name="code">51</field>
+ <field name="name">Diferimento</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_100" model="l10n_br_account.cst.template">
+ <field name="code">60</field>
+ <field name="name">ICMS cobrado anteriormente por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_101" model="l10n_br_account.cst.template">
+ <field name="code">70</field>
+ <field name="name">Com redução de base de cálculo e cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_102" model="l10n_br_account.cst.template">
+ <field name="code">90</field>
+ <field name="name">Outras</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_103" model="l10n_br_account.cst.template">
+ <field name="code">101</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional com permissão de crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_104" model="l10n_br_account.cst.template">
+ <field name="code">102</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional sem permissão de crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_105" model="l10n_br_account.cst.template">
+ <field name="code">103</field>
+ <field name="name">Simples Nacional - Isenção do ICMS no Simples Nacional para faixa de receita bruta</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_106" model="l10n_br_account.cst.template">
+ <field name="code">201</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional com permissão de crédito e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_107" model="l10n_br_account.cst.template">
+ <field name="code">202</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional sem permissão de crédito e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_108" model="l10n_br_account.cst.template">
+ <field name="code">203</field>
+ <field name="name">Simples Nacional - Isenção do ICMS no Simples Nacional para faixa de receita bruta e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_109" model="l10n_br_account.cst.template">
+ <field name="code">300</field>
+ <field name="name">Simples Nacional - Imune</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_110" model="l10n_br_account.cst.template">
+ <field name="code">400</field>
+ <field name="name">Simples Nacional - Não tributada pelo Simples Nacional</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_111" model="l10n_br_account.cst.template">
+ <field name="code">500</field>
+ <field name="name">Simples Nacional - ICMS cobrado anteriormente por substituição tributária (substituído) ou por antecipação</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_112" model="l10n_br_account.cst.template">
+ <field name="code">900</field>
+ <field name="name">Simples Nacional - Outros</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_103" model="l10n_br_account.cst.template">
+ <field name="code">101</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional com permissão de crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_104" model="l10n_br_account.cst.template">
+ <field name="code">102</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional sem permissão de crédito</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_105" model="l10n_br_account.cst.template">
+ <field name="code">103</field>
+ <field name="name">Simples Nacional - Isenção do ICMS no Simples Nacional para faixa de receita bruta</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_106" model="l10n_br_account.cst.template">
+ <field name="code">201</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional com permissão de crédito e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_107" model="l10n_br_account.cst.template">
+ <field name="code">202</field>
+ <field name="name">Simples Nacional - Tributada pelo Simples Nacional sem permissão de crédito e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_108" model="l10n_br_account.cst.template">
+ <field name="code">203</field>
+ <field name="name">Simples Nacional - Isenção do ICMS no Simples Nacional para faixa de receita bruta e com cobrança do ICMS por substituição tributária</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_109" model="l10n_br_account.cst.template">
+ <field name="code">300</field>
+ <field name="name">Simples Nacional - Imune</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_110" model="l10n_br_account.cst.template">
+ <field name="code">400</field>
+ <field name="name">Simples Nacional - Não tributada pelo Simples Nacional</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_111" model="l10n_br_account.cst.template">
+ <field name="code">500</field>
+ <field name="name">Simples Nacional - ICMS cobrado anteriormente por substituição tributária (substituído) ou por antecipação</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ <record id="l10n_br_cst_template_112" model="l10n_br_account.cst.template">
+ <field name="code">900</field>
+ <field name="name">Simples Nacional - Outros</field>
+ <field name="tax_code_template_id" ref="tax_code_1" />
+ </record>
+
+ </data>
+</openerp>
=== added directory 'l10n_br/i18n'
=== added file 'l10n_br/i18n/l10n_br.pot'
--- l10n_br/i18n/l10n_br.pot 1970-01-01 00:00:00 +0000
+++ l10n_br/i18n/l10n_br.pot 2012-05-03 23:39:20 +0000
@@ -0,0 +1,170 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+# * l10n_br
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1beta\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2011-12-23 09:56+0000\n"
+"PO-Revision-Date: 2011-12-23 09:56+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: l10n_br
+#: field:account.tax,tax_discount:0
+#: field:account.tax.code,tax_discount:0
+#: field:account.tax.code.template,tax_discount:0
+#: field:account.tax.template,tax_discount:0
+msgid "Discount this Tax in Prince"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.actions.act_window,name:l10n_br.action_l10n_br_cst_form
+#: model:ir.model,name:l10n_br.model_l10n_br_account_cst
+#: model:ir.ui.menu,name:l10n_br.menu_action_l10n_br_cst
+#: view:l10n_br_account.cst:0
+msgid "Tax Situation Code"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_code
+#: field:l10n_br_account.cst,tax_code_id:0
+msgid "Tax Code"
+msgstr ""
+
+#. module: l10n_br
+#: help:account.tax.code,domain:0
+#: help:account.tax.code.template,domain:0
+msgid "This field is only used if you develop your own module allowing developers to create specific taxes in a custom domain."
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.resultado
+msgid "Resultado"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_template
+msgid "account.tax.template"
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.passivo
+msgid "Passivo"
+msgstr ""
+
+#. module: l10n_br
+#: field:l10n_br_account.cst,name:0
+#: field:l10n_br_account.cst.template,name:0
+msgid "Description"
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.despesa
+msgid "Despesas"
+msgstr ""
+
+#. module: l10n_br
+#: field:account.tax,amount_mva:0
+#: field:account.tax.template,amount_mva:0
+msgid "MVA Percent"
+msgstr ""
+
+#. module: l10n_br
+#: help:account.tax.template,amount_mva:0
+#: help:account.tax.template,base_reduction:0
+msgid "For taxes of type percentage, enter % ratio between 0-1."
+msgstr ""
+
+#. module: l10n_br
+#: field:account.tax,base_reduction:0
+#: field:account.tax.template,base_reduction:0
+msgid "Redution"
+msgstr ""
+
+#. module: l10n_br
+#: constraint:account.tax.code.template:0
+msgid "Error ! You can not create recursive Tax Codes."
+msgstr ""
+
+#. module: l10n_br
+#: sql_constraint:account.tax:0
+msgid "Tax Name must be unique per company!"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax
+msgid "account.tax"
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.receita
+msgid "Receita"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.actions.act_window,name:l10n_br.action_l10n_br_cst_template_form
+#: model:ir.model,name:l10n_br.model_l10n_br_account_cst_template
+#: model:ir.ui.menu,name:l10n_br.menu_action_l10n_br_cst_template
+#: view:l10n_br_account.cst.template:0
+msgid "Tax Situation Code Template"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_wizard_multi_charts_accounts
+msgid "wizard.multi.charts.accounts"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.actions.todo,note:l10n_br.config_call_account_template_brazilian_localization
+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"
+" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
+msgstr ""
+
+#. module: l10n_br
+#: help:account.tax,tax_discount:0
+#: help:account.tax.code,tax_discount:0
+#: help:account.tax.code.template,tax_discount:0
+#: help:account.tax.template,tax_discount:0
+msgid "Mark it for (ICMS, PIS e etc.)."
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.ativo
+msgid "Ativo"
+msgstr ""
+
+#. module: l10n_br
+#: field:account.tax.code,domain:0
+#: field:account.tax.code.template,domain:0
+msgid "Domain"
+msgstr ""
+
+#. module: l10n_br
+#: field:l10n_br_account.cst,code:0
+#: field:l10n_br_account.cst.template,code:0
+msgid "Code"
+msgstr ""
+
+#. module: l10n_br
+#: constraint:account.tax.code:0
+msgid "Error ! You can not create recursive accounts."
+msgstr ""
+
+#. module: l10n_br
+#: help:account.tax,amount_mva:0
+#: help:account.tax,base_reduction:0
+msgid "Um percentual decimal em % entre 0-1."
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_code_template
+#: field:l10n_br_account.cst.template,tax_code_template_id:0
+msgid "Tax Code Template"
+msgstr ""
+
=== added file 'l10n_br/i18n/pt_BR.po'
--- l10n_br/i18n/pt_BR.po 1970-01-01 00:00:00 +0000
+++ l10n_br/i18n/pt_BR.po 2012-05-03 23:39:20 +0000
@@ -0,0 +1,188 @@
+# Brazilian Portuguese translation for openobject-addons
+# Copyright (c) 2011 Rosetta Contributors and Canonical Ltd 2011
+# This file is distributed under the same license as the openobject-addons package.
+# FIRST AUTHOR <EMAIL@ADDRESS>, 2011.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: openobject-addons\n"
+"Report-Msgid-Bugs-To: FULL NAME <EMAIL@ADDRESS>\n"
+"POT-Creation-Date: 2011-12-23 09:56+0000\n"
+"PO-Revision-Date: 2012-02-17 09:10+0000\n"
+"Last-Translator: tamnil <Unknown>\n"
+"Language-Team: Brazilian Portuguese <pt_BR@xxxxxx>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Launchpad-Export-Date: 2012-02-18 06:43+0000\n"
+"X-Generator: Launchpad (build 14814)\n"
+
+#. module: l10n_br
+#: field:account.tax,tax_discount:0
+#: field:account.tax.code,tax_discount:0
+#: field:account.tax.code.template,tax_discount:0
+#: field:account.tax.template,tax_discount:0
+msgid "Discount this Tax in Prince"
+msgstr "Desconta esta taxa no Preço"
+
+#. module: l10n_br
+#: model:ir.actions.act_window,name:l10n_br.action_l10n_br_cst_form
+#: model:ir.model,name:l10n_br.model_l10n_br_account_cst
+#: model:ir.ui.menu,name:l10n_br.menu_action_l10n_br_cst
+#: view:l10n_br_account.cst:0
+msgid "Tax Situation Code"
+msgstr "Código de Situação da Taxa"
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_code
+#: field:l10n_br_account.cst,tax_code_id:0
+msgid "Tax Code"
+msgstr "Código da Taxa"
+
+#. module: l10n_br
+#: help:account.tax.code,domain:0
+#: help:account.tax.code.template,domain:0
+msgid ""
+"This field is only used if you develop your own module allowing developers "
+"to create specific taxes in a custom domain."
+msgstr ""
+"Este campo é usado apenas se você desenvolver o seu próprio módulo "
+"permitindo aos desenvolvedores criar impostos específicos num domínio "
+"personalizado."
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.resultado
+msgid "Resultado"
+msgstr "Resultado"
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_template
+msgid "account.tax.template"
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.passivo
+msgid "Passivo"
+msgstr "Passivo"
+
+#. module: l10n_br
+#: field:l10n_br_account.cst,name:0
+#: field:l10n_br_account.cst.template,name:0
+msgid "Description"
+msgstr "Descrição"
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.despesa
+msgid "Despesas"
+msgstr "Despesas"
+
+#. module: l10n_br
+#: field:account.tax,amount_mva:0
+#: field:account.tax.template,amount_mva:0
+msgid "MVA Percent"
+msgstr "Porcentagem MVA"
+
+#. module: l10n_br
+#: help:account.tax.template,amount_mva:0
+#: help:account.tax.template,base_reduction:0
+msgid "For taxes of type percentage, enter % ratio between 0-1."
+msgstr ""
+
+#. module: l10n_br
+#: field:account.tax,base_reduction:0
+#: field:account.tax.template,base_reduction:0
+msgid "Redution"
+msgstr "Redução"
+
+#. module: l10n_br
+#: constraint:account.tax.code.template:0
+msgid "Error ! You can not create recursive Tax Codes."
+msgstr ""
+
+#. module: l10n_br
+#: sql_constraint:account.tax:0
+msgid "Tax Name must be unique per company!"
+msgstr "O Nome da taxa tem que ser único por companhia!"
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax
+msgid "account.tax"
+msgstr ""
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.receita
+msgid "Receita"
+msgstr "Receita"
+
+#. module: l10n_br
+#: model:ir.actions.act_window,name:l10n_br.action_l10n_br_cst_template_form
+#: model:ir.model,name:l10n_br.model_l10n_br_account_cst_template
+#: model:ir.ui.menu,name:l10n_br.menu_action_l10n_br_cst_template
+#: view:l10n_br_account.cst.template:0
+msgid "Tax Situation Code Template"
+msgstr "Modelo do Código de Situação da Taxa"
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_wizard_multi_charts_accounts
+msgid "wizard.multi.charts.accounts"
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.actions.todo,note:l10n_br.config_call_account_template_brazilian_localization
+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"
+" This is the same wizard that runs from Financial "
+"Management/Configuration/Financial Accounting/Financial Accounts/Generate "
+"Chart of Accounts from a Chart Template."
+msgstr ""
+"Gera o Plano de Contas a partir de um Plano Modelo. Será solicitado que você "
+"informe o nome da empresa, o modelo do plano para seguir, o número de "
+"dígitos para gerar o código de suas contas, a conta bancária e moeda para "
+"criar os diários. Assim, a cópia pura do Plano Modelo é gerada.\n"
+" Este é o mesmo assistente que roda a partir de Contas/Configuração/Conta "
+"Financeira/Conta/Contas/Gerar Plano de Contas a partir de um Plano Modelo."
+
+#. module: l10n_br
+#: help:account.tax,tax_discount:0
+#: help:account.tax.code,tax_discount:0
+#: help:account.tax.code.template,tax_discount:0
+#: help:account.tax.template,tax_discount:0
+msgid "Mark it for (ICMS, PIS e etc.)."
+msgstr "Marque para (ICMS, PIS e etc.)."
+
+#. module: l10n_br
+#: model:account.account.type,name:l10n_br.ativo
+msgid "Ativo"
+msgstr ""
+
+#. module: l10n_br
+#: field:account.tax.code,domain:0
+#: field:account.tax.code.template,domain:0
+msgid "Domain"
+msgstr ""
+
+#. module: l10n_br
+#: field:l10n_br_account.cst,code:0
+#: field:l10n_br_account.cst.template,code:0
+msgid "Code"
+msgstr ""
+
+#. module: l10n_br
+#: constraint:account.tax.code:0
+msgid "Error ! You can not create recursive accounts."
+msgstr ""
+
+#. module: l10n_br
+#: help:account.tax,amount_mva:0
+#: help:account.tax,base_reduction:0
+msgid "Um percentual decimal em % entre 0-1."
+msgstr ""
+
+#. module: l10n_br
+#: model:ir.model,name:l10n_br.model_account_tax_code_template
+#: field:l10n_br_account.cst.template,tax_code_template_id:0
+msgid "Tax Code Template"
+msgstr ""
=== added directory 'l10n_br/images'
=== added file 'l10n_br/images/1_config_chart_l10n_br.jpeg'
Binary files l10n_br/images/1_config_chart_l10n_br.jpeg 1970-01-01 00:00:00 +0000 and l10n_br/images/1_config_chart_l10n_br.jpeg 2012-05-03 23:39:20 +0000 differ
=== added file 'l10n_br/images/2_l10n_br_chart.jpeg'
Binary files l10n_br/images/2_l10n_br_chart.jpeg 1970-01-01 00:00:00 +0000 and l10n_br/images/2_l10n_br_chart.jpeg 2012-05-03 23:39:20 +0000 differ
=== added file 'l10n_br/l10n_br.py'
--- l10n_br/l10n_br.py 1970-01-01 00:00:00 +0000
+++ l10n_br/l10n_br.py 2012-05-03 23:39:20 +0000
@@ -0,0 +1,84 @@
+# -*- encoding: utf-8 -*-
+#################################################################################
+# #
+# Copyright (C) 2009 Renato Lima - Akretion #
+# #
+#This program is free software: you can redistribute it and/or modify #
+#it under the terms of the GNU Affero General Public License as published by #
+#the Free Software Foundation, either version 3 of the License, or #
+#(at your option) any later version. #
+# #
+#This program is distributed in the hope that it will be useful, #
+#but WITHOUT ANY WARRANTY; without even the implied warranty of #
+#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the #
+#GNU General Public License for more details. #
+# #
+#You should have received a copy of the GNU General Public License #
+#along with this program. If not, see <http://www.gnu.org/licenses/>. #
+#################################################################################
+
+from osv import fields, osv
+
+class l10n_br_account_cst_template(osv.osv):
+ _name = 'l10n_br_account.cst.template'
+ _description = 'Tax Situation Code Template'
+ _columns = {
+ 'code': fields.char('Code', size=8,required=True),
+ 'name': fields.char('Description', size=64),
+ 'tax_code_template_id': fields.many2one('account.tax.code.template', 'Tax Code Template',required=True),
+ }
+
+ def name_search(self, cr, user, name, args=None, operator='ilike', context=None, limit=80):
+ if not args:
+ args = []
+ if context is None:
+ context = {}
+ ids = self.search(cr, user, ['|',('name',operator,name),('code',operator,name)] + args, limit=limit, context=context)
+ return self.name_get(cr, user, ids, context)
+
+ def name_get(self, cr, uid, ids, context=None):
+ if not ids:
+ return []
+ reads = self.read(cr, uid, ids, ['name', 'code'], context=context)
+ res = []
+ for record in reads:
+ name = record['name']
+ if record['code']:
+ name = record['code'] + ' - '+name
+ res.append((record['id'], name))
+ return res
+
+l10n_br_account_cst_template()
+
+class l10n_br_account_cst(osv.osv):
+ _name = 'l10n_br_account.cst'
+ _description = 'Tax Situation Code'
+ _columns = {
+ 'code': fields.char('Code', size=8,required=True),
+ 'name': fields.char('Description', size=64),
+ 'tax_code_id': fields.many2one('account.tax.code', 'Tax Code',required=True),
+ }
+
+ def name_search(self, cr, user, name, args=None, operator='ilike', context=None, limit=80):
+ if not args:
+ args = []
+ if context is None:
+ context = {}
+ ids = self.search(cr, user, ['|',('name',operator,name),('code',operator,name)] + args, limit=limit, context=context)
+ return self.name_get(cr, user, ids, context)
+
+ def name_get(self, cr, uid, ids, context=None):
+ if not ids:
+ return []
+ reads = self.read(cr, uid, ids, ['name', 'code'], context=context)
+ res = []
+ for record in reads:
+ name = record['name']
+ if record['code']:
+ name = record['code'] + ' - '+name
+ res.append((record['id'], name))
+ return res
+
+l10n_br_account_cst()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file
=== added file 'l10n_br/l10n_br_view.xml'
--- l10n_br/l10n_br_view.xml 1970-01-01 00:00:00 +0000
+++ l10n_br/l10n_br_view.xml 2012-05-03 23:39:20 +0000
@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+
+ <record model="ir.ui.view" id="view_l10n_br_cst_template_form">
+ <field name="name">l10n_br.cst.form</field>
+ <field name="model">l10n_br_account.cst.template</field>
+ <field name="type">form</field>
+ <field name="arch" type="xml">
+ <form string="Tax Situation Code Template">
+ <field name="code" select="1"/>
+ <field name="name" select="1"/>
+ <field name="tax_code_template_id" select="2"/>
+ </form>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_cst_template_tree">
+ <field name="name">l10n_br.cst.tree</field>
+ <field name="model">l10n_br_account.cst.template</field>
+ <field name="type">tree</field>
+ <field name="arch" type="xml">
+ <tree string="Tax Situation Code Template">
+ <field name="code" select="1"/>
+ <field name="name" select="1"/>
+ <field name="tax_code_template_id" select="2"/>
+ </tree>
+ </field>
+ </record>
+
+ <record model="ir.actions.act_window" id="action_l10n_br_cst_template_form">
+ <field name="name">Tax Situation Code Template</field>
+ <field name="type">ir.actions.act_window</field>
+ <field name="res_model">l10n_br_account.cst.template</field>
+ <field name="view_mode">tree,form</field>
+ <field name="view_type">form</field>
+ <field name="view_id" ref="view_l10n_br_cst_template_tree"/>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_cst_form">
+ <field name="name">l10n_br.cst.form</field>
+ <field name="model">l10n_br_account.cst</field>
+ <field name="type">form</field>
+ <field name="arch" type="xml">
+ <form string="Tax Situation Code">
+ <field name="code" select="1"/>
+ <field name="name" select="1"/>
+ <field name="tax_code_id" select="2"/>
+ </form>
+ </field>
+ </record>
+
+ <record model="ir.ui.view" id="view_l10n_br_cst_tree">
+ <field name="name">l10n_br.cst.tree</field>
+ <field name="model">l10n_br_account.cst</field>
+ <field name="type">tree</field>
+ <field name="arch" type="xml">
+ <tree string="Tax Situation Code">
+ <field name="code" select="1"/>
+ <field name="name" select="1"/>
+ <field name="tax_code_id" select="2"/>
+ </tree>
+ </field>
+ </record>
+
+ <record model="ir.actions.act_window" id="action_l10n_br_cst_form">
+ <field name="name">Tax Situation Code</field>
+ <field name="type">ir.actions.act_window</field>
+ <field name="res_model">l10n_br_account.cst</field>
+ <field name="view_mode">tree,form</field>
+ <field name="view_type">form</field>
+ <field name="view_id" ref="view_l10n_br_cst_tree"/>
+ </record>
+
+ <menuitem name="Tax Situation Code Template" id="menu_action_l10n_br_cst_template" sequence="99" parent="account.account_template_taxes" action="action_l10n_br_cst_template_form"/>
+
+ <menuitem name="Tax Situation Code" id="menu_action_l10n_br_cst" parent="account.next_id_27" sequence="99" action="action_l10n_br_cst_form"/>
+
+ </data>
+</openerp>
\ No newline at end of file
=== added directory 'l10n_br/security'
=== added file 'l10n_br/security/ir.model.access.csv'
--- l10n_br/security/ir.model.access.csv 1970-01-01 00:00:00 +0000
+++ l10n_br/security/ir.model.access.csv 2012-05-03 23:39:20 +0000
@@ -0,0 +1,3 @@
+id,name,model_id:id,group_id:id,perm_read,perm_write,perm_create,perm_unlink
+l10n_br_account_cst,l10n_br_account.cst,model_l10n_br_account_cst,account.group_account_invoice,1,1,1,1
+l10n_br_account_cst_template,l10n_br_account.cst.template,model_l10n_br_account_cst_template,account.group_account_invoice,1,1,1,1
=== modified file 'l10n_br_account/account.py'
--- l10n_br_account/account.py 2012-05-03 22:02:44 +0000
+++ l10n_br_account/account.py 2012-05-03 23:39:20 +0000
@@ -2,6 +2,7 @@
#################################################################################
# #
# Copyright (C) 2009 Renato Lima - Akretion #
+# Copyright (C) 2011 Vinicius Dittgen - PROGE, Leonardo Santagada - PROGE #
# #
#This program is free software: you can redistribute it and/or modify #
#it under the terms of the GNU Affero General Public License as published by #
@@ -43,86 +44,226 @@
}
"""
- tax_obj = self.pool.get('account.tax')
- result = super(account_tax, self).compute_all(cr, uid, taxes, price_unit, quantity, address_id, product, partner, force_excluded)
- totaldc = totalbr = 0.0
-
- obj_precision = self.pool.get('decimal.precision')
- prec = obj_precision.precision_get(cr, uid, 'Account')
-
- icms_base = icms_value = icms_percent = 0.0
- ipi_base = ipi_value = ipi_percent = 0.0
-
- for tax in result['taxes']:
+ totaldc = 0.0
+
+ icms_value = 0
+ icms_percent = 0
+ ipi_value = 0
+
+ precision = self.pool.get('decimal.precision').precision_get(cr, uid, 'Account')
+ totalin = totalex = round(price_unit * quantity, precision)
+ tin = [] # tax_include
+ tad = [] # tax_add
+ tre = [] # tax_retain
+ pin = [] # price_include
+ ntax = [] # normal tax
+
+ for tax in taxes:
+ if tax.tax_discount:
+ if tax.tax_include:
+ tin.append(tax)
+ elif tax.tax_retain:
+ tax.amount = (tax.amount * -1)
+ tre.append(tax)
+ elif tax.tax_add:
+ tad.append(tax)
+ elif tax.price_include:
+ pin.append(tax)
+ else:
+ ntax.append(tax)
+ pin = super(account_tax, self).compute_inv(cr, uid, pin, price_unit, quantity, address_id=address_id, product=product, partner=partner)
+ for r in pin:
+ totalex -= r.get('amount', 0.0)
+ totlex_qty = 0.0
+ try:
+ totlex_qty = totalex / quantity
+ except:
+ pass
+
+ tin = self.l10n_br_compute_inv(cr, uid, tin, price_unit, quantity, address_id=address_id, product=product, partner=partner)
+
+ all_tad = tad + ntax + tre
+ all_tad = super(account_tax, self)._compute(cr, uid, all_tad, totlex_qty, quantity, address_id=address_id, product=product, partner=partner)
+
+ for r in all_tad:
+ totalin += r.get('amount', 0.0)
+
+ tax_obj = self.pool.get('account.tax')
+ res_taxes = pin + tin + all_tad
+
+ for tax in res_taxes:
tax_brw = tax_obj.browse(cr, uid, tax['id'])
if tax_brw.domain in ['icms', 'icmsst']:
continue
if tax_brw.type == 'quantity':
- tax['amount'] = round((quantity * product.weight_net) * tax_brw.amount, prec)
+ tax['amount'] = round((quantity * product.weight_net) * tax_brw.amount, precision)
- if tax_brw.base_code_id.tax_discount:
-
- if tax_brw.base_reduction <> 0:
- tax['amount'] = round(tax['amount'] * (1 - tax_brw.base_reduction), prec)
+ if tax_brw.tax_discount:
+ if tax_brw.base_reduction != 0:
+ tax['amount'] = round(tax['amount'] * (1 - tax_brw.base_reduction), precision)
+
totaldc += tax['amount']
- if tax_brw.amount <> 0:
- tax['total_base'] = round(result['total'] * (1 - tax_brw.base_reduction), prec)
+ if tax_brw.amount != 0:
+ if tax_brw.include_base_amount:
+ tax['total_base'] = tax['price_unit']
+ else:
+ tax['total_base'] = round(totalex * (1 - tax_brw.base_reduction), precision)
else:
tax['total_base'] = 0
#Guarda o valor do ipi para ser usado para calcular a st
if tax_brw.domain == 'ipi':
- ipi_base = tax['total_base']
ipi_value = tax['amount']
- ipi_percent = tax_brw.amount
-
-
- for tax_icms in result['taxes']:
+
+ for tax in res_taxes:
+ tax_brw = tax_obj.browse(cr, uid, tax['id'])
+
#Guarda o valor do icms para ser usado para calcular a st
- tax_brw_icms = tax_obj.browse(cr, uid, tax_icms['id'])
- if tax_brw_icms.domain == 'icms':
+ if tax_brw.domain == 'icms':
- if fiscal_operation and fiscal_operation.asset_operation or False:
- tax_base = result['total'] + ipi_value
- tax_icms['amount'] = round(tax_base * tax_brw_icms.amount, prec)
+ if fiscal_operation and fiscal_operation.asset_operation:
+ tax_base = totalex + ipi_value
+ tax['amount'] = round(tax_base * tax_brw.amount, precision)
else:
- tax_base = result['total']
-
- if tax_brw_icms.type == 'quantity':
- tax_icms['amount'] = round((quantity * product.weight_net) * tax_brw_icms.amount, prec)
-
- if tax_brw_icms.base_reduction <> 0:
- tax_icms['amount'] = round(tax_icms['amount'] * (1 - tax_brw_icms.base_reduction), prec)
-
- if tax_brw_icms.base_code_id.tax_discount:
-
- totaldc += tax_icms['amount']
+ tax_base = totalex
+
+ if tax_brw.type == 'quantity':
+ tax['amount'] = round((quantity * product.weight_net) * tax_brw.amount, precision)
+
+ if tax_brw.base_reduction <> 0:
+ tax['amount'] = round(tax['amount'] * (1 - tax_brw.base_reduction), precision)
+
+ if tax_brw.base_code_id.tax_discount:
+ totaldc += tax['amount']
if tax_brw.amount <> 0:
- tax_icms['total_base'] = round(tax_base * (1 - tax_brw_icms.base_reduction), prec)
+ tax['total_base'] = round(tax_base * (1 - tax_brw.base_reduction), precision)
else:
- tax_icms['total_base'] = 0
-
- icms_base = tax_icms['total_base']
- icms_value = tax_icms['amount']
- icms_percent = tax_brw_icms.amount
-
- for tax_sub in result['taxes']:
- tax_brw_sub = tax_obj.browse(cr, uid, tax_sub['id'])
- if tax_brw_sub.domain == 'icmsst':
- tax_sub['total_base'] = (result['total'] + ipi_value) * (1 + tax_brw_sub.amount_mva)
- tax_sub['amount'] += (((result['total'] + ipi_value) * (1 + tax_brw_sub.amount_mva)) * icms_percent) - icms_value
+ tax['total_base'] = 0
+
+ icms_value = tax['amount']
+ icms_percent = tax_brw.amount
+
+ for tax in res_taxes:
+ tax_brw = tax_obj.browse(cr, uid, tax['id'])
+ if tax_brw.domain == 'icmsst':
+ tax['total_base'] += (totalex + ipi_value) * (1 + tax_brw.amount_mva)
+ tax['amount'] += (((totalex + ipi_value) * (1 + tax_brw.amount_mva)) * icms_percent) - icms_value
return {
- 'total': result['total'],
- 'total_included': result['total_included'],
+ 'total': totalex,
+ 'total_included': totalin,
'total_tax_discount': totaldc,
- 'taxes': result['taxes'],
- }
-
+ 'taxes': res_taxes,
+ }
+
+ def l10n_br_compute_inv(self, cr, uid, taxes, price_unit, quantity, address_id=None, product=None, partner=None):
+ """
+ Compute tax values for given PRICE_UNIT, QUANTITY and a buyer/seller ADDRESS_ID.
+ Price Unit is a VAT included price
+
+ RETURN:
+ [ tax ]
+ tax = {'name': '', 'amount': 0.0, 'account_collected_id': 1, 'account_paid_id': 2}
+ one tax for each tax id in IDS and their children
+ """
+
+ res = self._l10n_br_unit_compute_inv(cr, uid, taxes, price_unit, address_id, product, partner=None)
+ total = 0.0
+ obj_precision = self.pool.get('decimal.precision')
+ for r in res:
+ prec = obj_precision.precision_get(cr, uid, 'Account')
+ if r.get('balance', False):
+ r['amount'] = round(r['balance'] * quantity, prec) - total
+ else:
+ r['amount'] = round(r['amount'] * quantity, prec)
+ total += r['amount']
+ return res
+
+ def _l10n_br_unit_compute_inv(self, cr, uid, taxes, price_unit, address_id=None, product=None, partner=None):
+ taxes = self._applicable(cr, uid, taxes, price_unit, address_id, product, partner)
+ obj_partener_address = self.pool.get('res.partner.address')
+ res = []
+ taxes.reverse()
+ cur_price_unit = price_unit
+
+ tax_parent_tot = 0.0
+ for tax in taxes:
+ if tax.type == 'percent' and not tax.include_base_amount:
+ tax_parent_tot += tax.amount
+
+ for tax in taxes:
+ if tax.type == 'fixed' and not tax.include_base_amount:
+ cur_price_unit -= tax.amount
+
+ for tax in taxes:
+ if tax.type == 'percent':
+ amount = cur_price_unit * tax.amount
+ # when tax_include application method change the percent calc method.
+ #if tax.include_base_amount:
+ #amount = cur_price_unit * tax.amount
+ #amount = cur_price_unit - (cur_price_unit / (1 + tax.amount))
+ #else:
+ #amount = cur_price_unit * tax_parent_tot
+ #amount = (cur_price_unit / (1 + tax_parent_tot)) * tax.amount
+
+ elif tax.type == 'fixed':
+ amount = tax.amount
+
+ elif tax.type == 'code':
+ address = address_id and obj_partener_address.browse(cr, uid, address_id) or None
+ localdict = {'price_unit': cur_price_unit, 'address': address, 'product': product, 'partner': partner}
+ exec tax.python_compute_inv in localdict
+ amount = localdict['result']
+ elif tax.type == 'balance':
+ amount = cur_price_unit - reduce(lambda x, y: y.get('amount', 0.0) + x, res, 0.0)
+
+ final_price_unit = cur_price_unit
+ if tax.include_base_amount:
+ cur_price_unit += amount
+ #todo = 1
+ #else:
+ #final_price_unit = cur_price_unit
+ #todo = 0
+ todo = 0
+
+ res.append({
+ 'id': tax.id,
+ 'todo': todo,
+ 'name': tax.name,
+ 'amount': amount,
+ 'account_collected_id': tax.account_collected_id.id,
+ 'account_paid_id': tax.account_paid_id.id,
+ 'base_code_id': tax.base_code_id.id,
+ 'ref_base_code_id': tax.ref_base_code_id.id,
+ 'sequence': tax.sequence,
+ 'base_sign': tax.base_sign,
+ 'tax_sign': tax.tax_sign,
+ 'ref_base_sign': tax.ref_base_sign,
+ 'ref_tax_sign': tax.ref_tax_sign,
+ 'price_unit': final_price_unit,
+ 'tax_code_id': tax.tax_code_id.id,
+ 'ref_tax_code_id': tax.ref_tax_code_id.id,
+ })
+ if tax.child_ids:
+ if tax.child_depend:
+ del res[-1]
+ amount = price_unit
+
+ parent_tax = self._unit_compute_inv(cr, uid, tax.child_ids, amount, address_id, product, partner)
+ res.extend(parent_tax)
+ #total = 0.0
+ #for r in res:
+ # if r['todo']:
+ # total += r['amount']
+ #for r in res:
+ # r['price_unit'] -= total
+ # r['todo'] = 0
+ return res
+
account_tax()
=== modified file 'l10n_br_account/account_invoice.py'
--- l10n_br_account/account_invoice.py 2012-05-03 22:09:49 +0000
+++ l10n_br_account/account_invoice.py 2012-05-03 23:39:20 +0000
@@ -67,7 +67,7 @@
res[invoice.id]['cofins_value'] += line.cofins_value
for invoice_tax in invoice.tax_line:
- if not invoice_tax.tax_code_id.tax_discount:
+ if not invoice_tax.tax_code_id.tax_include:
res[invoice.id]['amount_tax'] += invoice_tax.amount
res[invoice.id]['amount_total'] = res[invoice.id]['amount_tax'] + res[invoice.id]['amount_untaxed']
@@ -419,6 +419,70 @@
i -= 1
return result
+ def finalize_invoice_move_lines(self, cr, uid, invoice_browse, move_lines):
+ """finalize_invoice_move_lines(cr, uid, invoice, move_lines) -> move_lines
+ Hook method to be overridden in additional modules to verify and possibly alter the
+ move lines to be created by an invoice, for special cases.
+
+ * remove move lines without credit and debit, we have to see where l10n_br modules are creating these error entries;
+ * fix move entreis when we have tax_retain
+
+ :param invoice_browse: browsable record of the invoice that is generating the move lines
+ :param move_lines: list of dictionaries with the account.move.lines (as for create())
+ :return: the (possibly updated) final move_lines to create for this invoice
+ """
+ total_taxes_credit = 0
+ move_lines_tmp = []
+ remove_itens = []
+ tax_retained_itens = []
+ mv_tmp_tuple = []
+ final_credit_ind = -1
+
+ for ind, move_line in enumerate(move_lines):
+ move_line_item = move_line[2]
+
+ # get itens without credit and debit line - brazilian localization bug
+ if not move_line_item['credit'] and not move_line_item['debit']:
+ remove_itens.append(ind)
+
+ # fix final debit line
+ elif move_line_item['account_id'] == invoice_browse.account_id.id and not move_line_item['credit']:
+ move_line_item['debit'] = invoice_browse.amount_total
+
+ # get tax_retain values and fix the entry sign
+ elif move_line_item['tax_amount'] < 0:
+ move_line_item['tax_amount'] = - move_line_item['tax_amount']
+ tax_retained_itens.append(ind)
+
+ # sum tax credit lines
+ elif move_line_item['credit'] > 0 and move_line_item['credit'] != invoice_browse.amount_untaxed:
+ total_taxes_credit += move_line_item['credit']
+
+ # get final invoice credit line
+ elif move_line_item['credit'] == invoice_browse.amount_untaxed:
+ final_credit_ind = ind
+
+ if final_credit_ind > -1:
+ move_lines[final_credit_ind][2]['credit'] = invoice_browse.amount_total - total_taxes_credit
+
+ # create a credit entry for each debit entry for tax_retain
+ for mv_ind in tax_retained_itens:
+ mv_tmp = move_lines[mv_ind][2].copy()
+ mv_tmp['credit'] = mv_tmp['debit']
+ mv_tmp['debit'] = False
+ mv_tmp_tuple = 0, 0, mv_tmp
+ move_lines_tmp.append(mv_tmp_tuple)
+
+ # remove itens without credit and debit line - brazilian localization bug
+ while remove_itens:
+ move_lines.pop(remove_itens.pop())
+
+ # add new credit entries for tax_retain
+ while move_lines_tmp:
+ move_lines.append(move_lines_tmp.pop())
+
+ return move_lines
+
def nfe_dv(self, key):
#Testing
return '2'
@@ -1985,7 +2049,7 @@
icms_st_base_other += 0
res[line.id] = {
- 'price_subtotal': taxes['total'] - taxes['total_tax_discount'],
+ 'price_subtotal': taxes['total'],
'price_total': taxes['total'],
'icms_base': icms_base,
'icms_base_other': icms_base_other,
=== modified file 'l10n_br_sale/sale.py'
--- l10n_br_sale/sale.py 2012-04-25 22:30:37 +0000
+++ l10n_br_sale/sale.py 2012-05-03 23:39:20 +0000
@@ -263,7 +263,7 @@
val = 0.0
for c in self.pool.get('account.tax').compute_all(cr, uid, line.tax_id, line.price_unit * (1 - (line.discount or 0.0) / 100.0), line.product_uom_qty, line.order_id.partner_invoice_id.id, line.product_id, line.order_id.partner_id, fiscal_operation=line.fiscal_operation_id)['taxes']:
tax_brw = self.pool.get('account.tax').browse(cr, uid, c['id'])
- if not tax_brw.tax_code_id.tax_discount:
+ if tax_brw.tax_add:
val += c.get('amount', 0.0)
return val
Follow ups
