Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027056Openbravo ERP04. Warehouse managementpublic2014-07-11 22:572014-08-08 18:54
Reporterjecharri 
Assigned TodaniOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tojecharri
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket29838
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027056: It is possible to assign more than once the same warehouse to one organization
DescriptionIt is possible to assign more than once the same warehouse to one organization
Steps To Reproduce-Go to window Organization
-Choose one and go to tab warehouse

Verify that you can insert more than once the same warehouse
Proposed SolutionCreate a unique contraint with ad_org_id and m_warehouse_id
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0027194 closed AtulOpenbravo API Change: Add unique constraint to AD_Org_Warehouse for Organization and Warehouse 
causes defect 0027273 closed AtulOpenbravo Upgrade from 2.50 to 3.0 fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-11 22:57jecharriNew Issue
2014-07-11 22:57jecharriAssigned To => dmiguelez
2014-07-11 22:57jecharriOBNetwork customer => Yes
2014-07-11 22:57jecharriWeb browser => Google Chrome
2014-07-11 22:57jecharriModules => Core
2014-07-11 22:57jecharriSupport ticket => 29838
2014-07-11 22:57jecharriResolution time => 1405461600
2014-07-11 22:57jecharriTriggers an Emergency Pack => No
2014-07-23 12:47daniOpenbravoWeb browserGoogle Chrome => Google Chrome
2014-07-23 12:47daniOpenbravoAssigned Todmiguelez => daniOpenbravo
2014-07-23 12:47daniOpenbravoStatusnew => scheduled
2014-07-30 04:50AtulOpenbravoRelationship addeddepends on 0027194
2014-07-30 04:54hgbotCheckin
2014-07-30 04:54hgbotNote Added: 0068968
2014-07-30 04:54hgbotStatusscheduled => resolved
2014-07-30 04:54hgbotResolutionopen => fixed
2014-07-30 04:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3d258163d8994d726a0042c4176b77e56c72474 [^]
2014-07-31 01:29jecharriReview Assigned To => jecharri
2014-07-31 01:29jecharriNote Added: 0068989
2014-07-31 01:29jecharriStatusresolved => closed
2014-08-04 15:21shuehnerRelationship addedcauses 0027273
2014-08-08 18:54hudsonbotCheckin
2014-08-08 18:54hudsonbotNote Added: 0069238

Notes
(0068968)
hgbot   
2014-07-30 04:54   
Repository: erp/devel/pi
Changeset: c3d258163d8994d726a0042c4176b77e56c72474
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Jul 25 16:26:07 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c3d258163d8994d726a0042c4176b77e56c72474 [^]

Fixes Issue 27056:It is possible to assign more than once same warehouse to one org

---
M src-db/database/model/tables/AD_ORG_WAREHOUSE.xml
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedOrgWarehouse.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedOrgWarehouseData.class
A src-util/buildvalidation/build/javasqlc/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouseData.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouse.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouse_data.xsql
---
(0068989)
jecharri   
2014-07-31 01:29   
Verified
(0069238)
hudsonbot   
2014-08-08 18:54   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4450016dee64 [^]
Maturity status: Test