diff options
| author | Hetashree Chauhan <hch@odoo.com> | 2018-11-20 11:04:25 +0000 |
|---|---|---|
| committer | Yannick Tivisse <yti@odoo.com> | 2019-02-08 06:33:50 +0000 |
| commit | 579bd8c6e767ee3f55dc3017ce4dc4ecb515a615 (patch) | |
| tree | 6763560bd3141b0bb51274a5fff1f01a6a3e9ed7 /addons | |
| parent | 53b85dbb8762330283a59b9087cc012caeed0fc1 (diff) | |
[IMP] l10n_mx: switch account.account.template creation in csv
data creation is faster when done through a CSV file than an XML file, hence doing it through a CSV
was task# 1909961
closes odoo/odoo#28885
Diffstat (limited to 'addons')
| -rw-r--r-- | addons/l10n_mx/__manifest__.py | 2 | ||||
| -rw-r--r-- | addons/l10n_mx/data/account.account.template.csv | 36 | ||||
| -rw-r--r-- | addons/l10n_mx/data/l10n_mx_chart_data.xml | 274 | ||||
| -rw-r--r-- | addons/l10n_mx/data/l10n_mx_chart_post_data.xml | 17 |
4 files changed, 55 insertions, 274 deletions
diff --git a/addons/l10n_mx/__manifest__.py b/addons/l10n_mx/__manifest__.py index cfe6dbecae2..9162a6944d1 100644 --- a/addons/l10n_mx/__manifest__.py +++ b/addons/l10n_mx/__manifest__.py @@ -36,6 +36,8 @@ With this module you will have: "data": [ "data/account_tag_data.xml", "data/l10n_mx_chart_data.xml", + "data/account.account.template.csv", + "data/l10n_mx_chart_post_data.xml", "data/account_data.xml", "data/account_tax_data.xml", "data/fiscal_position_data.xml", diff --git a/addons/l10n_mx/data/account.account.template.csv b/addons/l10n_mx/data/account.account.template.csv new file mode 100644 index 00000000000..b9cd4a41d36 --- /dev/null +++ b/addons/l10n_mx/data/account.account.template.csv @@ -0,0 +1,36 @@ +"id","name","code","user_type_id/id","chart_template_id/id","tag_ids/id","reconcile" +"cuenta102_02","Transferencias bancarias moneda extranjera","102.02.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_102_02","True" +"cuenta105_01","Clientes nacionales","105.01.01","account.data_account_type_receivable","l10n_mx.mx_coa","l10n_mx.account_tag_105_01","True" +"cuenta107_05_01","Mercancías Enviadas - No Facturas","107.05.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_107_05","True" +"cuenta108_01","Estimación de cuentas incobrables nacional","108.01.01","account.data_account_type_receivable","l10n_mx.mx_coa","l10n_mx.account_tag_108_01","True" +"cuenta108_02","Estimación de cuentas incobrables extranjero","108.02.01","account.data_account_type_receivable","l10n_mx.mx_coa","l10n_mx.account_tag_108_02","True" +"cuenta115_01","Inventario","115.01.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_01","False" +"cuenta115_02","Materia prima y materiales","115.02.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_02","False" +"cuenta115_03","Producción en proceso","115.03.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_03","False" +"cuenta115_04","Productos terminados","115.04.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_04","False" +"cuenta115_05","Mercancías en tránsito","115.05.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_05","False" +"cuenta115_06","Mercancías en poder de terceros","115.06.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_115_06","False" +"cuenta118_01","IVA acreditable pagado","118.01.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_118_01","False" +"cuenta119_01","IVA pendiente de pago","119.01.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_119_01","False" +"cuenta120_01","Anticipo a proveedores nacional","120.01.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_120_01","True" +"cuenta120_02","Anticipo a proveedores extranjero","120.02.01","account.data_account_type_current_assets","l10n_mx.mx_coa","l10n_mx.account_tag_120_02","True" +"cuenta201_01","Proveedores nacionales","201.01.01","account.data_account_type_payable","l10n_mx.mx_coa","l10n_mx.account_tag_201_01","True" +"cuenta205_06_01","Mercancías Recibidas - No Facturas","205.06.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_205_01","True" +"cuenta206_01","Anticipo de cliente nacional","206.01.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_206_01","True" +"cuenta206_02","Anticipo de cliente extranjero","206.02.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_206_02","True" +"cuenta206_05_01","Otros anticipos de clientes","206.05.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_206_05","True" +"cuenta208_01","IVA trasladado cobrado","208.01.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_208_01","False" +"cuenta209_01","IVA trasladado no cobrado","209.01.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_209_01","False" +"cuenta216_03","Impuestos retenidos de ISR por arrendamiento","216.03.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_216_03","False" +"cuenta216_04","Impuestos retenidos de ISR por servicios profesionales","216.04.01","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_216_04","False" +"cuenta216_10","Impuestos retenidos de IVA","216.10.10","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_216_10","False" +"cuenta216_10_20","Impuestos retenidos de iva efectivamente pagados","216.10.20","account.data_account_type_current_liabilities","l10n_mx.mx_coa","l10n_mx.account_tag_216_10","False" +"cuenta302_01","Patrimonio","302.01.01","account.data_account_type_equity","l10n_mx.mx_coa","l10n_mx.account_tag_302_01","False" +"cuenta304_01","Utilidad de ejercicios anteriores","304.01.01","account.data_account_type_equity","l10n_mx.mx_coa","l10n_mx.account_tag_304_01","False" +"cuenta401_01","Ventas y/o servicios gravados a la tasa general","401.01.01","account.data_account_type_revenue","l10n_mx.mx_coa","l10n_mx.account_tag_401_01","False" +"cuenta501_01","Costo de venta","501.01.01","account.data_account_type_direct_costs","l10n_mx.mx_coa","l10n_mx.account_tag_501_01","False" +"cuenta601_84","Otros gastos generales","601.84.01","account.data_account_type_expenses","l10n_mx.mx_coa","l10n_mx.account_tag_601_84","False" +"cuenta701_01","Pérdida cambiaria","701.01.01","account.data_account_type_expenses","l10n_mx.mx_coa","l10n_mx.account_tag_701_01","False" +"cuenta702_01","Utilidad cambiaria","702.01.01","account.data_account_type_revenue","l10n_mx.mx_coa","l10n_mx.account_tag_702_01","False" +"cuenta801_01","Utilidad o pérdida fiscal en venta y/o baja de activo fijo","811.01.01","account.data_unaffected_earnings","l10n_mx.mx_coa","l10n_mx.account_tag_801_01","False" +"cuenta801_01_99","Base Imponible de Impuestos en Base a Flujo de Efectivo","899.01.99","account.data_account_type_expenses","l10n_mx.mx_coa","l10n_mx.account_tag_801_01","False" diff --git a/addons/l10n_mx/data/l10n_mx_chart_data.xml b/addons/l10n_mx/data/l10n_mx_chart_data.xml index 428a846c6cb..f24ab04764a 100644 --- a/addons/l10n_mx/data/l10n_mx_chart_data.xml +++ b/addons/l10n_mx/data/l10n_mx_chart_data.xml @@ -13,279 +13,5 @@ <field name="currency_id" ref="base.MXN"/> <field name="use_anglo_saxon" eval="True"/> </record> - <!-- - Accounts - --> - <record id='cuenta102_02' model='account.account.template'> - <field name='name'>Transferencias bancarias moneda extranjera</field> - <field name='code'>102.02.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_102_02')])]"/> - </record> - <record id='cuenta105_01' model='account.account.template'> - <field name='name'>Clientes nacionales</field> - <field name='code'>105.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_receivable"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_105_01')])]"/> - </record> - <record id='cuenta107_05_01' model='account.account.template'> - <field name='name'>Mercancías Enviadas - No Facturas</field> - <field name='code'>107.05.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_107_05')])]"/> - </record> - <record id='cuenta108_01' model='account.account.template'> - <field name='name'>Estimación de cuentas incobrables nacional</field> - <field name='code'>108.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_receivable"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_108_01')])]"/> - </record> - <record id='cuenta108_02' model='account.account.template'> - <field name='name'>Estimación de cuentas incobrables extranjero</field> - <field name='code'>108.02.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_receivable"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_108_02')])]"/> - </record> - <record id='cuenta115_01' model='account.account.template'> - <field name='name'>Inventario</field> - <field name='code'>115.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_01')])]"/> - </record> - <record id='cuenta115_02' model='account.account.template'> - <field name='name'>Materia prima y materiales</field> - <field name='code'>115.02.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_02')])]"/> - </record> - <record id='cuenta115_03' model='account.account.template'> - <field name='name'>Producción en proceso</field> - <field name='code'>115.03.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_03')])]"/> - </record> - <record id='cuenta115_04' model='account.account.template'> - <field name='name'>Productos terminados</field> - <field name='code'>115.04.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_04')])]"/> - </record> - <record id='cuenta115_05' model='account.account.template'> - <field name='name'>Mercancías en tránsito</field> - <field name='code'>115.05.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_05')])]"/> - </record> - <record id='cuenta115_06' model='account.account.template'> - <field name='name'>Mercancías en poder de terceros</field> - <field name='code'>115.06.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_115_06')])]"/> - </record> - <record id='cuenta118_01' model='account.account.template'> - <field name='name'>IVA acreditable pagado</field> - <field name='code'>118.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_118_01')])]"/> - </record> - <record id='cuenta119_01' model='account.account.template'> - <field name='name'>IVA pendiente de pago</field> - <field name='code'>119.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_119_01')])]"/> - </record> - <record id='cuenta120_01' model='account.account.template'> - <field name='name'>Anticipo a proveedores nacional</field> - <field name='code'>120.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_120_01')])]"/> - </record> - <record id='cuenta120_02' model='account.account.template'> - <field name='name'>Anticipo a proveedores extranjero</field> - <field name='code'>120.02.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_assets"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_120_02')])]"/> - </record> - <record id='cuenta201_01' model='account.account.template'> - <field name='name'>Proveedores nacionales</field> - <field name='code'>201.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_payable"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_201_01')])]"/> - </record> - <record id='cuenta205_06_01' model='account.account.template'> - <field name='name'>Mercancías Recibidas - No Facturas</field> - <field name='code'>205.06.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_205_01')])]"/> - </record> - <record id='cuenta206_01' model='account.account.template'> - <field name='name'>Anticipo de cliente nacional</field> - <field name='code'>206.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_206_01')])]"/> - </record> - <record id='cuenta206_02' model='account.account.template'> - <field name='name'>Anticipo de cliente extranjero</field> - <field name='code'>206.02.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_206_02')])]"/> - </record> - <record id='cuenta206_05_01' model='account.account.template'> - <field name='name'>Otros anticipos de clientes</field> - <field name='code'>206.05.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="reconcile" eval="True"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_206_05')])]"/> - </record> - <record id='cuenta208_01' model='account.account.template'> - <field name='name'>IVA trasladado cobrado</field> - <field name='code'>208.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_208_01')])]"/> - </record> - <record id='cuenta209_01' model='account.account.template'> - <field name='name'>IVA trasladado no cobrado</field> - <field name='code'>209.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_209_01')])]"/> - </record> - <record id='cuenta216_03' model='account.account.template'> - <field name='name'>Impuestos retenidos de ISR por arrendamiento</field> - <field name='code'>216.03.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_216_03')])]"/> - </record> - <record id='cuenta216_04' model='account.account.template'> - <field name='name'>Impuestos retenidos de ISR por servicios profesionales</field> - <field name='code'>216.04.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_216_04')])]"/> - </record> - <record id='cuenta216_10' model='account.account.template'> - <field name='name'>Impuestos retenidos de IVA</field> - <field name='code'>216.10.10</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_216_10')])]"/> - </record> - <record id='cuenta216_10_20' model='account.account.template'> - <field name='name'>Impuestos retenidos de iva efectivamente pagados</field> - <field name='code'>216.10.20</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_current_liabilities"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_216_10')])]"/> - </record> - <record id='cuenta302_01' model='account.account.template'> - <field name='name'>Patrimonio</field> - <field name='code'>302.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_equity"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_302_01')])]"/> - </record> - <record id='cuenta304_01' model='account.account.template'> - <field name='name'>Utilidad de ejercicios anteriores</field> - <field name='code'>304.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_equity"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_304_01')])]"/> - </record> - <record id='cuenta401_01' model='account.account.template'> - <field name='name'>Ventas y/o servicios gravados a la tasa general</field> - <field name='code'>401.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_revenue"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_401_01')])]"/> - </record> - <record id='cuenta501_01' model='account.account.template'> - <field name='name'>Costo de venta</field> - <field name='code'>501.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_direct_costs"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_501_01')])]"/> - </record> - <record id='cuenta601_84' model='account.account.template'> - <field name='name'>Otros gastos generales</field> - <field name='code'>601.84.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_expenses"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_601_84')])]"/> - </record> - <record id='cuenta701_01' model='account.account.template'> - <field name='name'>Pérdida cambiaria</field> - <field name='code'>701.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_expenses"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_701_01')])]"/> - </record> - <record id='cuenta702_01' model='account.account.template'> - <field name='name'>Utilidad cambiaria</field> - <field name='code'>702.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_revenue"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_702_01')])]"/> - </record> - <record id='cuenta801_01' model='account.account.template'> - <field name='name'>Utilidad o pérdida fiscal en venta y/o baja de activo fijo</field> - <field name='code'>811.01.01</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_unaffected_earnings"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_801_01')])]"/> - </record> - <record id='cuenta801_01_99' model='account.account.template'> - <field name='name'>Base Imponible de Impuestos en Base a Flujo de Efectivo</field> - <field name='code'>899.01.99</field> - <field name="chart_template_id" ref="mx_coa"/> - <field name="user_type_id" ref="account.data_account_type_expenses"/> - <field name="tag_ids" eval="[(6,0,[ref('account_tag_801_01')])]"/> - </record> - <!-- - CoA setting accounts - --> - <record id="mx_coa" model="account.chart.template"> - <field name="property_account_receivable_id" ref="cuenta105_01"/> - <field name="property_account_payable_id" ref="cuenta201_01"/> - <field name="property_account_expense_categ_id" ref="cuenta601_84"/> - <field name="property_account_income_categ_id" ref="cuenta401_01"/> - <field name="property_stock_account_input_categ_id" ref="cuenta205_06_01"/> - <field name="property_stock_account_output_categ_id" ref="cuenta107_05_01"/> - <field name="property_stock_valuation_account_id" ref="cuenta115_01"/> - <field name="income_currency_exchange_account_id" ref="cuenta702_01"/> - <field name="expense_currency_exchange_account_id" ref="cuenta701_01"/> - </record> </data> </odoo> diff --git a/addons/l10n_mx/data/l10n_mx_chart_post_data.xml b/addons/l10n_mx/data/l10n_mx_chart_post_data.xml new file mode 100644 index 00000000000..ab4056adcf3 --- /dev/null +++ b/addons/l10n_mx/data/l10n_mx_chart_post_data.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="utf-8"?> +<odoo noupdate="1"> + <!-- + CoA setting accounts + --> + <record id="mx_coa" model="account.chart.template"> + <field name="property_account_receivable_id" ref="cuenta105_01"/> + <field name="property_account_payable_id" ref="cuenta201_01"/> + <field name="property_account_expense_categ_id" ref="cuenta601_84"/> + <field name="property_account_income_categ_id" ref="cuenta401_01"/> + <field name="property_stock_account_input_categ_id" ref="cuenta205_06_01"/> + <field name="property_stock_account_output_categ_id" ref="cuenta107_05_01"/> + <field name="property_stock_valuation_account_id" ref="cuenta115_01"/> + <field name="income_currency_exchange_account_id" ref="cuenta702_01"/> + <field name="expense_currency_exchange_account_id" ref="cuenta701_01"/> + </record> +</odoo> |
