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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0040402
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Intrastat for Spainmajorhave not tried2019-03-18 10:272019-03-19 11:56
ReporterOpentix-TestView Statuspublic 
Assigned ToOpentix-Test 
PriorityhighResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version1.1.2SCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0040402: 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).
TagsNo tags attached.
Attached Filespng file icon error intrastat LE.PNG [^] (162,219 bytes) 2019-03-18 10:27

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of design defect 0034537 closedOpentix-Test Not possible to apply Intrastat for Spain dataset in more than one Organization (Legal) at the same level. 

-  Notes
(0110481)
psanjuan (manager)
2019-03-18 15:39

 Closed as this issue is a duplicate of issue 34537

- Issue History
Date Modified Username Field Change
2019-03-18 10:27 Opentix-Test New Issue
2019-03-18 10:27 Opentix-Test Assigned To => Opentix-Test
2019-03-18 10:27 Opentix-Test File Added: error intrastat LE.PNG
2019-03-18 15:39 psanjuan Relationship added duplicate of 0034537
2019-03-18 15:39 psanjuan Note Added: 0110481
2019-03-18 15:39 psanjuan Status new => closed
2019-03-18 15:39 psanjuan Resolution open => duplicate
2019-03-19 11:56 ivancace Issue Monitored: ivancace

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker