From 3936d655c4bfd845b6ead724cecdc8e7c62816eb Mon Sep 17 00:00:00 2001 From: Olivier Colson Date: Fri, 19 Apr 2019 10:06:07 +0000 Subject: [IMP] account, l10n_*: v13 taxes - Add repartition lines on taxes - Link account tags directly to account.move.line; remove the tag_ids field from account.tag - Add a new report engine dedicated to tax reports, directly generating account tags. It is called as an alternate mode of generic tax report, with a dedicated "Use tax grids" toggle. >> The biggest change lies in the way the new tax report computes its values. Everything is now aggregated directly using the tags set on the account move lines. Thanks to that, modifying the configuration of a tax today will not impact the report for the previous periods anymore. This is a big improvement, as it means the report will keep on reflecting the values that were submitted to the state before, whatever the configuration change. - Add an audit char field to account.move.line telling with tax grids are impacted by the line, with the corresponding amount - Modify the behavior of cash basis taxes: the cash basis account is now used as the transition account, while the regular account given in tax declaration is used to store the final entry (it was the opposite before) - Modify every l10n_* module in order to keep them consistent with these changes closes odoo/odoo#32833 Signed-off-by: Quentin De Paoli (qdp) --- addons/l10n_do/__manifest__.py | 1 + addons/l10n_do/data/account.tax.template.xml | 934 ++++++++++++++++++++--- addons/l10n_do/data/account_account_tag_data.xml | 94 +-- addons/l10n_do/data/account_data.xml | 2 +- addons/l10n_do/data/account_tax_report_data.xml | 143 ++++ addons/l10n_do/data/fiscal_position_template.xml | 2 +- addons/l10n_do/data/l10n_do_chart_data.xml | 20 +- addons/l10n_do/data/l10n_do_state_data.xml | 2 +- 8 files changed, 1000 insertions(+), 198 deletions(-) create mode 100644 addons/l10n_do/data/account_tax_report_data.xml (limited to 'addons/l10n_do') diff --git a/addons/l10n_do/__manifest__.py b/addons/l10n_do/__manifest__.py index 596c03d9221..d07f64c808f 100644 --- a/addons/l10n_do/__manifest__.py +++ b/addons/l10n_do/__manifest__.py @@ -95,6 +95,7 @@ en Odoo): 'data/account.account.template.csv', 'data/account_chart_template_data.xml', 'data/account_data.xml', + 'data/account_tax_report_data.xml', 'data/account.tax.template.xml', # Country States 'data/l10n_do_state_data.xml', diff --git a/addons/l10n_do/data/account.tax.template.xml b/addons/l10n_do/data/account.tax.template.xml index 6e49d7244dc..7d970672e91 100644 --- a/addons/l10n_do/data/account.tax.template.xml +++ b/addons/l10n_do/data/account.tax.template.xml @@ -1,6 +1,7 @@ - + + @@ -11,9 +12,31 @@ percent sale - + + + 10 @@ -23,9 +46,29 @@ percent purchase - + + + 1 @@ -34,12 +77,36 @@ 18 percent sale - - - + + + 2 @@ -48,12 +115,36 @@ 18 percent sale - - - + + + 3 @@ -62,11 +153,32 @@ 10 percent sale - - + + + 18% ITBIS Compras @@ -75,12 +187,34 @@ 18 percent purchase - - - + + + 12 @@ -89,12 +223,34 @@ 18 percent purchase - - - + + + 16% ITBIS Compras @@ -103,11 +259,32 @@ 16 percent purchase - - + + + 16% ITBIS Incl. Compras @@ -116,11 +293,32 @@ 16 percent purchase - - + + + 9% ITBIS Compras @@ -129,11 +327,32 @@ 9 percent purchase - - + + + 9% ITBIS Incl. Compras @@ -142,11 +361,32 @@ 9 percent purchase - - + + + 8% ITBIS Compras @@ -155,11 +395,32 @@ 8 percent purchase - - + + + 8% ITBIS Incl. Compras @@ -168,11 +429,32 @@ 8 percent purchase - - + + + 19 @@ -181,11 +463,32 @@ 10 percent purchase - - + + + 20 @@ -194,12 +497,34 @@ 18 percent purchase - - - + + + 20 @@ -208,12 +533,34 @@ 18 percent purchase - - - + + + 20 @@ -222,12 +569,34 @@ 18 percent purchase - - - + + + 20 @@ -236,11 +605,32 @@ 1.8 percent sale - - + + + 30 @@ -249,11 +639,32 @@ 0.0015 percent none - - + + + 30 @@ -262,12 +673,32 @@ 10 percent purchase - - - + + + 30 @@ -276,22 +707,43 @@ 2 percent purchase - - - + + + 30 Impuestos a las Telecomunicaciones - + group purchase + 40 @@ -300,11 +752,32 @@ -18 percent purchase - - + + + 41 @@ -313,12 +786,36 @@ -18 percent purchase - - - + + + 42 @@ -327,12 +824,36 @@ -18 percent purchase - - - + + + 43 @@ -341,11 +862,32 @@ -5.4 percent purchase - - + + + False @@ -355,11 +897,32 @@ -5.4 percent none - - + + + 44 @@ -368,11 +931,32 @@ -13.5 percent purchase - - + + + 40 @@ -381,12 +965,32 @@ -10 percent purchase - - - + + + 50 @@ -395,12 +999,32 @@ -10 percent purchase - - - + + + 51 @@ -409,12 +1033,32 @@ -10 percent purchase - - - + + + 52 @@ -423,12 +1067,32 @@ -2 percent purchase - - - + + + 53 @@ -437,12 +1101,32 @@ -2 percent purchase - - - + + + 49 @@ -451,11 +1135,32 @@ -27 percent purchase - - + + + 50 @@ -464,31 +1169,54 @@ -5 percent sale - - + + + 60 Retención a Proveedores Informales de Bienes (75%) group - + purchase - + + 61 Retención a Físicas por Servicios con Materiales (2%) group - + purchase + 62 @@ -497,43 +1225,67 @@ none + + + 58 Retención a Físicas por Honorarios por Servicios (10%) group - + purchase + 58 Retención a Jurídicas por Servicios Profesionales (30%) group - + purchase + 64 Ventas del Restaurante group - + sale + 65 Compras a Restaurantes group - + purchase diff --git a/addons/l10n_do/data/account_account_tag_data.xml b/addons/l10n_do/data/account_account_tag_data.xml index 70826b6bbf5..7097e3a0197 100644 --- a/addons/l10n_do/data/account_account_tag_data.xml +++ b/addons/l10n_do/data/account_account_tag_data.xml @@ -1,6 +1,6 @@ - + @@ -562,97 +562,5 @@ accounts - - - - R-ISR 10% - taxes - - - - C-EXENTA - taxes - - - - V-ITBIS 8% - taxes - - - - C-ITBIS 8% - taxes - - - - V-ITBIS 11% - taxes - - - - C-ITBIS 11% - taxes - - - - V-EXENTA - taxes - - - - V-ITBIS 18% - taxes - - - - C-ITBIS 18% Incluido - taxes - - - - C-ITBIS 18% - taxes - - - - CS-ITBIS 18% Incluido - taxes - - - - CS-ITBIS 18% - taxes - - - - IMP-ITBIS 18% - taxes - - - - R-ITBIS 18% - taxes - - - - R-ISR 2% - taxes - - - - TELE-ISC - taxes - - - - TELE-CDT - taxes - - - - R-Alquileres 10% - taxes - - diff --git a/addons/l10n_do/data/account_data.xml b/addons/l10n_do/data/account_data.xml index 462fb38760d..fe655ba0da2 100644 --- a/addons/l10n_do/data/account_data.xml +++ b/addons/l10n_do/data/account_data.xml @@ -1,6 +1,6 @@ - + diff --git a/addons/l10n_do/data/account_tax_report_data.xml b/addons/l10n_do/data/account_tax_report_data.xml new file mode 100644 index 00000000000..c19f354a183 --- /dev/null +++ b/addons/l10n_do/data/account_tax_report_data.xml @@ -0,0 +1,143 @@ + + + + + II-1 Total de Operaciones + + + + + + II.A INGRESOS POR EXPORTACIONES DE BIENES O SERVICIOS EXENTOS + + + + + + + II.A.2 INGRESOS POR EXPORTACIONES DE BIENES O SERVICIOS EXENTOS + + + + + + + II.A.3 INGRESOS POR VENTAS LOCALES DE BIENES O SERVICIOS EXENTOS + II.A.3 + DOTAX010102 + + + + + + + II.B GRAVADAS + + + + + + + II.B.6 OPERACIONES GRAVADAS AL 18% + II.B.6 + DOTAX010201 + + + + + + + II.B.7 OPERACIONES GRAVADAS AL 11% + + + + + + + III LIQUIDACION + + + + + + III.10 TOTAL ITBIS COBRADO (Sumar casillas 8+9) + + + + + + + III.8 ITBIS COBRADO (18% de la casilla 6) + III.8 + DOTAX020101 + + + + + + + III.9 TBIS COBRADO (11% de la casilla 7) + + + + + + + III.14 TOTAL ITBIS PAGADO (Sumar casillas 11+12+13) + + + + + + + III.11 ITBIS PAGADO EN COMPRAS LOCALES + III.11 + DOTAX020201 + + + + + + + III.12 ITBIS PAGADO POR SERVICIOS DEDUCIBLES + III.12 + DOTAX020202 + + + + + + + III.13 ITBIS PAGADO EN IMPORTACIONES + III.13 + DOTAX020203 + + + + + + + A,1 ITBIS RETENIDO + + + + + + A.25 Servicios Sujetos a Retención Personas = Físicas y Entidad + A.25 + DOTAX0301 + + + + + + + A.30 Itbis Por Servicios Sujetos A Retencion Personas Físicas + A.30 + DOTAX0302 + + + + + + \ No newline at end of file diff --git a/addons/l10n_do/data/fiscal_position_template.xml b/addons/l10n_do/data/fiscal_position_template.xml index 03900817ec6..bafe680b853 100644 --- a/addons/l10n_do/data/fiscal_position_template.xml +++ b/addons/l10n_do/data/fiscal_position_template.xml @@ -1,6 +1,6 @@ - + diff --git a/addons/l10n_do/data/l10n_do_chart_data.xml b/addons/l10n_do/data/l10n_do_chart_data.xml index b8d5a68ff64..13e4cdf8969 100644 --- a/addons/l10n_do/data/l10n_do_chart_data.xml +++ b/addons/l10n_do/data/l10n_do_chart_data.xml @@ -2,15 +2,13 @@ - - - - Catálogo de Cuentas Dominicano (NIIF) - 8 - 110101 - 110102 - 11010100 - - - + + + Catálogo de Cuentas Dominicano (NIIF) + 8 + 110101 + 110102 + 11010100 + + diff --git a/addons/l10n_do/data/l10n_do_state_data.xml b/addons/l10n_do/data/l10n_do_state_data.xml index 8191da21cd9..c1707544a7a 100644 --- a/addons/l10n_do/data/l10n_do_state_data.xml +++ b/addons/l10n_do/data/l10n_do_state_data.xml @@ -1,6 +1,6 @@ - +