Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011916Openbravo ERP04. Warehouse managementpublic2010-01-08 12:432010-06-14 14:09
Reporternetworkb 
Assigned Toshuehner 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP14Fixed in Version2.50MP14 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011916: You can select a Warehouse that does not belong to your organization
DescriptionIf you have an organization B with Secondary Warehouse and an organization A with Main Warehouse. When you create a Physical Inventory with the organization B you can select the Main Warehouse.
Steps To Reproduce-As Openbravo Admin go to Warehouse Management || Setup || Warehouse and Storage Bins
-Select Main Warehouse, Organization: A
-Save and select Secondary Warehouse, Organization: B
-Save and go to Warehouse Management || Transactions || Physical Inventory
-Create a new record with the organization B
-Realize that you can select the Main Warehouse.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00119172.50MP12 closed rafaroda You can select a Storage Bin that does not belong to the header's Warehouse 
related to defect 00114132.50MP11 closed rafaroda On the Physical Inventory It's possible choice a Storage bin from another Warehouse 
related to defect 0011867 closed alostale Data Access Level = Organization does not work properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-08 12:43networkbNew Issue
2010-01-08 12:43networkbAssigned To => rafaroda
2010-01-08 13:21rafarodaRelationship addedrelated to 0011917
2010-01-08 13:21rafarodaRelationship addedrelated to 0011413
2010-01-13 11:16rafarodaPriorityimmediate => high
2010-01-13 11:16rafarodaStatusnew => scheduled
2010-01-13 11:16rafarodaNote Added: 0023382
2010-02-11 11:07rafarodaAssigned Torafaroda => adrianromero
2010-02-22 10:50psarobeAssigned Toadrianromero => alostale
2010-02-22 10:50psarobePriorityhigh => urgent
2010-02-22 10:50psarobeTarget Version2.50MP12 => 2.50MP13
2010-03-02 15:12alostaleNote Added: 0024952
2010-03-02 16:29alostaleRelationship addedhas duplicate 0011867
2010-03-02 16:43alostaleNote Added: 0024957
2010-03-02 16:51alostaleNote Added: 0024958
2010-03-02 17:01hgbotCheckin
2010-03-02 17:01hgbotNote Added: 0024959
2010-03-02 17:01hgbotStatusscheduled => resolved
2010-03-02 17:01hgbotResolutionopen => fixed
2010-03-02 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ba4cbeb3d8a70b616076073020948725bdccdfcf [^]
2010-03-03 07:15sureshbabuNote Added: 0024974
2010-03-03 07:15sureshbabuStatusresolved => closed
2010-03-03 07:15sureshbabuFixed in Version => 2.50MP13
2010-03-08 16:04jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-10 17:21anonymoussf_bug_id0 =>
2010-03-10 18:28anonymoussf_bug_id => 2967972
2010-03-12 22:40hudsonbotCheckin
2010-03-12 22:40hudsonbotNote Added: 0025376
2010-06-10 15:35roklenardicNote Added: 0028268
2010-06-10 15:35roklenardicStatusclosed => new
2010-06-10 15:35roklenardicResolutionfixed => open
2010-06-10 15:35roklenardicFixed in Version2.50MP14 =>
2010-06-14 13:05iciordiaAssigned Toalostale => shuehner
2010-06-14 13:06iciordiaStatusnew => scheduled
2010-06-14 13:06iciordiafix_in_branch => pi
2010-06-14 14:05shuehnerRelationship replacedrelated to 0011867
2010-06-14 14:08shuehnerNote Added: 0028368
2010-06-14 14:08shuehnerStatusscheduled => resolved
2010-06-14 14:08shuehnerFixed in Version => 2.50MP14
2010-06-14 14:08shuehnerResolutionopen => fixed
2010-06-14 14:09shuehnerNote Added: 0028369
2010-06-14 14:09shuehnerStatusresolved => closed

Notes
(0023382)
rafaroda   
2010-01-13 11:16   
Check whether solution applied for 0011413 also fixes this issue.
(0024952)
alostale   
2010-03-02 15:12   
The problem is that the warehouse combo is not refreshed when organization changes. You can select the incorrect warehouse in new record before saving, but it is not present anymore after saving.
(0024957)
alostale   
2010-03-02 16:43   
This issue affects to all combo reload for validation rule and table reference with validation rule not null.

In these cases combo reload is not executed when organization changes as it should be done.
(0024958)
alostale   
2010-03-02 16:51   
These are the cases that might be affected:

            select w.name, t.name, f.name, r.whereclause
            from ad_ref_table r, aD_column c, ad_field f, ad_tab t, ad_window w, aD_menu m
            where r.whereclause is not null
            and c.ad_reference_id = '18'
            and c.ad_reference_value_id = r.ad_reference_id
            and f.ad_column_id =c.ad_column_id
            and f.isdisplayed ='Y'
            and f.isactive='Y'
            and c.isactive='Y'
            and t.ad_tab_id = f.ad_tab_id
            and t.isactive='Y'
            and w.ad_window_id = t.aD_window_id
            and w.isactive='Y'
            and m.ad_window_id = w.ad_window_id
            and m.isactive='Y';
(0024959)
hgbot   
2010-03-02 17:01   
Repository: erp/devel/pi
Changeset: ba4cbeb3d8a70b616076073020948725bdccdfcf
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Mar 02 17:01:15 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ba4cbeb3d8a70b616076073020948725bdccdfcf [^]

fixed bug 11916: You can select a Warehouse that does not belong to your organization

---
M src-wad/src/org/openbravo/wad/Wad.java
---
(0024974)
sureshbabu   
2010-03-03 07:15   
Tested working fine
(0025376)
hudsonbot   
2010-03-12 22:40   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/ba4cbeb3d8a7 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0028268)
roklenardic   
2010-06-10 15:35   
This problem still persists in MP18.

I have reproduced it according to the duplicate issue:
https://issues.openbravo.com/view.php?id=11867 [^]
(0028368)
shuehner   
2010-06-14 14:08   
Marking as resolved/closed again as the fix for the 11916 issue is correct and working properly.
Instead the 11867 issue which was marked as duplicate of this one has been changed to be 'related' and has been reopened.
(0028369)
shuehner   
2010-06-14 14:09   
Marking as closed again as was reopened wrongly. Instead the now related issue 11867 has been reopened.