Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045668Localization Pack: SpainTaxespublic2020-12-30 16:592020-12-31 14:08
Reporterpsanjuan 
Assigned Tojuabaez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0045668: Brexit - configuración de las regiones de Irlanda del Norte como parte de la UE para ops. de intercambio de bienes.
DescriptionBrexit - configuración de las regiones de Irlanda del Norte como parte de la UE para ops. de interambio de bienes.
Steps To ReproduceN/A
Proposed SolutionSe requiere modificar la localización de los siguientes impuestos, para considerar Reino Unido - Irlanda del Norte como parte de la UE para las operaciones de entregas de bienes:

1. Añadir el pais Reino Unido + las 27 Regiones de Irlanda del Norte (NI) (Ver nota), en los impuestos que se listan a continuación:

- Impuestos de Ventas: como pais+region de destino (ie. United Kingdom + Antrim (NI), etc). Pais de origen = España.

Entregas intracomunitarias Bienes Inversión (%N=>0%)
Entregas intracomunitarias (%N=>0%)
Entregas intracomunitarias (%N=>0%) ISP
Entregas intracomunitarias (%R=>0%)
Entregas intracomunitarias (%SR=>0%)

- Impuestos de Compras: como pais+region de origen (ie. United Kingdom + Antrim (NI), etc). Pais Destino = España.

Adquisiciones intracomunitarias 10%
Adquisiciones intracomunitarias 10% (-10%)
Adquisiciones intracomunitarias 10% (+10%)

Adquisiciones intracomunitarias 21%
Adquisiciones intracomunitarias 21% (-21%)
Adquisiciones intracomunitarias 21% (+21%)

Adquisiciones intracomunitarias 21% (-21%) ISP
Adquisiciones intracomunitarias 21% (+21%) ISP
Adquisiciones Intracomunitarias 21% ISP

Adquisiciones intracomunitarias 4%
Adquisiciones intracomunitarias 4% (-4%)
Adquisiciones intracomunitarias 4% (+4%)

Adquisiciones intracomunitarias Bienes Inversión 21%
Adquisiciones intracomunitarias Bienes Inversión 21% (-21%)
Adquisiciones intracomunitarias Bienes Inversión 21% (+21%)

Adquisiciones intracomunitarias exentas
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0039951 closed Mery Anelo Brexit - Consider the United Kingdom as a third country in the "Tax zone" tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-12-30 16:59psanjuanNew Issue
2020-12-30 16:59psanjuanAssigned To => Jorge Bravo
2020-12-30 16:59psanjuanOBNetwork customer => No
2020-12-30 16:59psanjuanProposed Solution updated
2020-12-30 17:01psanjuanProposed Solution updated
2020-12-30 17:04psanjuanProposed Solution updated
2020-12-30 17:05psanjuanNote Added: 0125181
2020-12-30 17:07psanjuanProposed Solution updated
2020-12-30 17:07psanjuanProposed Solution updated
2020-12-30 17:09psanjuanProposed Solution updated
2020-12-30 17:18Jorge BravoAssigned ToJorge Bravo => juabaez
2020-12-30 17:24psanjuanNote Added: 0125182
2020-12-30 17:29psanjuanNote Edited: 0125182bug_revision_view_page.php?bugnote_id=0125182#r22004
2020-12-30 17:29psanjuanNote Edited: 0125182bug_revision_view_page.php?bugnote_id=0125182#r22005
2020-12-30 17:30psanjuanNote Edited: 0125182bug_revision_view_page.php?bugnote_id=0125182#r22006
2020-12-30 17:35psanjuanNote Edited: 0125182bug_revision_view_page.php?bugnote_id=0125182#r22007
2020-12-30 17:50psanjuanSummaryBrexit - configuración de las regiones de Irlanda del Norte como parte de la UE para ops. de entregas de bienes. => Brexit - configuración de las regiones de Irlanda del Norte como parte de la UE para ops. de intercambio de bienes.
2020-12-30 17:50psanjuanDescription Updatedbug_revision_view_page.php?rev_id=22009#r22009
2020-12-31 00:42juabaezStatusnew => scheduled
2020-12-31 00:50hgbotMerge Request Status => open
2020-12-31 00:50hgbotNote Added: 0125194
2020-12-31 11:30vmromanosRelationship addedrelated to 0039951
2020-12-31 12:38juabaezNote Added: 0125221
2020-12-31 12:44hgbotMerge Request Statusopen => approved
2020-12-31 12:44hgbotResolutionopen => fixed
2020-12-31 12:44hgbotStatusscheduled => closed
2020-12-31 12:44hgbotNote Added: 0125222
2020-12-31 12:44hgbotNote Added: 0125223
2020-12-31 12:44hgbotNote Added: 0125224
2020-12-31 12:44hgbotNote Added: 0125225
2020-12-31 12:44hgbotNote Added: 0125226
2020-12-31 12:44hgbotNote Added: 0125227

Notes
(0125181)
psanjuan   
2020-12-30 17:05   
Las regiones de Irlanda del Norte (NI) se encuentran en la ventana Country and Region, país = United Kingdom, tab Region. Son 26 y se listan a continuación:

Antrim (NI)
Ards (NI)
Armagh (NI)
Ballymena (NI)
Ballymoney (NI)
Banbridge (NI)
Belfast (NI)
Carrickfergus (NI)
Castlereagh (NI)
Coleraine (NI)
Cookstown (NI)
Craigavon (NI)
Down (NI)
Dungannon (NI)
Fermanagh (NI)
Larne (NI)
Limavady (NI)
Lisburn (NI)
Londonderry (NI)
Magherafelt (NI)
Moyle (NI)
Newry and Mourne (NI)
Newtonabbey (NI)
North Down (NI)
Omagh (NI)
Strabane (NI)
(0125182)
psanjuan   
2020-12-30 17:24   
(edited on: 2020-12-30 17:35)
Comprobar e indicar con Test Cases los siguientes escenarios:

TEST 1
Intercambio de mercancías (Compra/Venta) con Reino Unido + cualquier región de Irlanda del Norte = OPERACIONES INTRACOMUNITARIAS (impuestos del tipo : Adquisición intracomunitaria de bienes o Entrega Intracomunitaria de bienes exenta)

TEST 2
Intercambio de mercancías (Compra/Venta) con Reino Unido + cualquier región diferente de Irlanda del Norte = EXPORTACIONES/IMPORTACIONES de bienes (impuestos del tipo Exportaciones (Venta) o Importaciones (Compra).

TEST 3
Prestación de servicios desde/hasta Reino Unido (independientemente de la Región ) = EXPORTACIONES/IMPORTACIONES de Servicios, en estos casos Openbravo debería mostrar impuestos del tipo : Servicios prestados internacional (Venta) o Inversión Sujeto Pasivo no UE (Compra)

Para realizar las pruebas anteriores la clave está en:
1 - la dirección (País / Región) de la organización que vende/compra a un tercero
2 - la dirección (País / Región) de dicho tercero (cliente o proveedor)
3 - el grupo de impuestos (IVA Normal, IVA Normal Servicios) al que pertenece un producto que puede ser un bien o un servicio.
(0125194)
hgbot   
2020-12-31 00:50   
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/merge_requests/6 [^]
(0125221)
juabaez   
2020-12-31 12:38   
First import the dataset with new tax zones
Create a business partner with address in United Kingdom and region North Ireland.
Create a business partner with address in United Kingdom and any region or without region or a region distinct North Ireland


TEST 1

Case 1 (Sales invoice):
1- Create a sales invoice with Business partner with address in United Kingdom and region North Ireland.
2- Add a product and the tax selected is "Entregas intracomunitarias (%N=>0%)"

Case 2 (Purchase Invoice):
1- Create a purchase invoice with Business partner with address in United Kingdom and region North Ireland.
2- Add a product and the tax selected is "Adquisiciones intracomunitarias 21%"


TEST 2

Case 1 (Sales invoice):
1- Create a sales invoice with Business partner with address in United Kingdom any region or without region or a region distinct North Ireland.
2- Add a product and the tax selected is "Exportaciones (%N=>0%)".

Case 2 (Purchase Invoice):
1- Create a purchase invoice with Business partner with address in United Kingdom any region or without region or a region distinct North Ireland.
2- Add a product and the tax selected is "Importaciones 21%=0%"


TEST 3

Case 1 (Sales invoice):
1- Create a sales invoice with Business partner with address in United Kingdom regardless of Region.
2- Add a service and the tax selected is "Servicios prestados internacional (%N=>0%)".

Case 2 (Purchase Invoice):
1- Create a purchase invoice with Business partner with address in United Kingdom regardless of Region.
2- Add a product and the tax selected is "Inversión Sujeto Pasivo no UE 21%"
(0125222)
hgbot   
2020-12-31 12:44   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes [^]
Changeset: 93b9c71bd63b9bbd176d214604f45d23a8935ea8
Author: Juan Baez <juabaez@gmail.com>
Date: 2020-12-30T18:07:28-03:00
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/commit/93b9c71bd63b9bbd176d214604f45d23a8935ea8 [^]

Fixed ISSUE-45668 add new tax zone for brexit

---
M referencedata/standard/Impuestos_ES.xml
M src-db/database/sourcedata/AD_DATASET.xml
---
(0125223)
hgbot   
2020-12-31 12:44   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes [^]
Changeset: 221c09cd07c5c14dfa8727bef17dadb960cef70e
Author: Juan Baez <juabaez@gmail.com>
Date: 2020-12-30T20:49:03-03:00
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/commit/221c09cd07c5c14dfa8727bef17dadb960cef70e [^]

Fixed ISSUE-45668 change update info from module

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0125224)
hgbot   
2020-12-31 12:44   
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes [^]
Changeset: b1ede7cbb3b7ef5380389fb49c409d2f11e16717
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 2020-12-31T12:08:12+01:00
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/commit/b1ede7cbb3b7ef5380389fb49c409d2f11e16717 [^]

Related to ISSUE-45668: Update module version and fix updateinfo

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0125225)
hgbot   
2020-12-31 12:44   
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes [^]
Changeset: ea26735ed207bec7f964075805cadc5181876978
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 2020-12-31T12:09:24+01:00
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/commit/ea26735ed207bec7f964075805cadc5181876978 [^]

Related to ISSUE-45668: Exported dataset again

The dataset has been exported after importing it without any functional change.

---
M referencedata/standard/Impuestos_ES.xml
---
(0125226)
hgbot   
2020-12-31 12:44   
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes [^]
Changeset: 6536389e3ec65ae88a52480234d1fae14598ac29
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 2020-12-31T12:17:25+01:00
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/commit/6536389e3ec65ae88a52480234d1fae14598ac29 [^]

Related to ISSUE-45668: Set C_Tax table as isBusinessObject=N

This avoids to export into the dataset the following records:
* Translations, which we don't maintain
* Tax zones as List. This was not necessary since the tax zones are already
exported into a separate entity.

This has reduced the dataset size (21MB -> 11MB) but keeping the same functionality.

---
M referencedata/standard/Impuestos_ES.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0125227)
hgbot   
2020-12-31 12:44   
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/merge_requests/6 [^]