Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040402ModulesIntrastat for Spainpublic2019-03-18 10:272019-03-19 11:56
ReporterOpentix-Test 
Assigned ToOpentix-Test 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version1.1.2 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0040402: Permitir aplicar el dataset a mas de una entidad legal
DescriptionModificar la actual implementación del módelo de intrastat para permitir aplicar el dataset a mas de una entidad legal.
Steps To Reproduce1º Crear la entidad Legal LE1
2º Aplicar el dataset de Intrastat para LE1
3º Crear la entidad legal LE2
4º Aplicar el dataset de Intrastat LE2
5º Verificar que se se obtiene el error:
isBatchUpdateException:duplicate key value violates unique constraint "intr_java_client_countr_un"\n Detail: Key (ad_client_id, c_country_id)=(3470CC97950A48A59942B3D0DC1ED1FA, 106) already exists.
Proposed SolutionModificar el módulo de intrastat org.openbravo.module.intrastat) que incluye la siguiente constraint en la tabla INTR_JAVACLASS:


<unique name="INTR_JAVA_CLIENT_COUNTR_UN">

  <unique-column name="AD_CLIENT_ID"/>

  <unique-column name="C_COUNTRY_ID"/>

</unique>

para que pueda existir mas de un registro en dicha tabla para cada entidad y país al ser aplicado por el dataset del módulo Intrastat For Spain (org.openbravo.module.intrastat.spain).
Additional Information
TagsNo tags attached.
Relationships
duplicate of design defect 0034537 closed Opentix-Test Not possible to apply Intrastat for Spain dataset in more than one Organization (Legal) at the same level. 
Attached Filespng error intrastat LE.PNG (162,219) 2019-03-18 10:27
https://issues.openbravo.com/file_download.php?file_id=12757&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-03-18 10:27Opentix-TestNew Issue
2019-03-18 10:27Opentix-TestAssigned To => Opentix-Test
2019-03-18 10:27Opentix-TestFile Added: error intrastat LE.PNG
2019-03-18 15:39psanjuanRelationship addedduplicate of 0034537
2019-03-18 15:39psanjuanNote Added: 0110481
2019-03-18 15:39psanjuanStatusnew => closed
2019-03-18 15:39psanjuanResolutionopen => duplicate
2019-03-19 11:56ivancaceIssue Monitored: ivancace

Notes
(0110481)
psanjuan   
2019-03-18 15:39   
Closed as this issue is a duplicate of issue 34537