Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045668
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Taxesmajoralways2020-12-30 16:592020-12-31 14:08
ReporterpsanjuanView Statuspublic 
Assigned Tojuabaez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0045668: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0039951 closedMery Anelo Brexit - Consider the United Kingdom as a third country in the "Tax zone" tab 

-  Notes
(0125181)
psanjuan (manager)
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 (manager)
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 (developer)
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 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2020-12-31 12:44

Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.localization.spain.referencedata.taxes/-/merge_requests/6 [^]

- Issue History
Date Modified Username Field Change
2020-12-30 16:59 psanjuan New Issue
2020-12-30 16:59 psanjuan Assigned To => Jorge Bravo
2020-12-30 16:59 psanjuan Proposed Solution updated
2020-12-30 17:01 psanjuan Proposed Solution updated
2020-12-30 17:04 psanjuan Proposed Solution updated
2020-12-30 17:05 psanjuan Note Added: 0125181
2020-12-30 17:07 psanjuan Proposed Solution updated
2020-12-30 17:07 psanjuan Proposed Solution updated
2020-12-30 17:09 psanjuan Proposed Solution updated
2020-12-30 17:18 Jorge Bravo Assigned To Jorge Bravo => juabaez
2020-12-30 17:24 psanjuan Note Added: 0125182
2020-12-30 17:29 psanjuan Note Edited: 0125182 View Revisions
2020-12-30 17:29 psanjuan Note Edited: 0125182 View Revisions
2020-12-30 17:30 psanjuan Note Edited: 0125182 View Revisions
2020-12-30 17:35 psanjuan Note Edited: 0125182 View Revisions
2020-12-30 17:50 psanjuan Summary Brexit - 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:50 psanjuan Description Updated View Revisions
2020-12-31 00:42 juabaez Status new => scheduled
2020-12-31 00:50 hgbot Note Added: 0125194
2020-12-31 11:30 vmromanos Relationship added related to 0039951
2020-12-31 12:38 juabaez Note Added: 0125221
2020-12-31 12:44 hgbot Resolution open => fixed
2020-12-31 12:44 hgbot Status scheduled => closed
2020-12-31 12:44 hgbot Note Added: 0125222
2020-12-31 12:44 hgbot Note Added: 0125223
2020-12-31 12:44 hgbot Note Added: 0125224
2020-12-31 12:44 hgbot Note Added: 0125225
2020-12-31 12:44 hgbot Note Added: 0125226
2020-12-31 12:44 hgbot Note Added: 0125227


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker