Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039588ModulesDistribution Orderspublic2018-11-06 09:352018-11-23 13:05
ReporterLeyre 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039588: Distribution Order Issue - The "warehouse Issue" is not refreshed when updating the "Organization".
DescriptionDistribution Order Issue - The "warehouse Issue" is not refreshed when updating the "Organization".
Steps To Reproduce1. Open the "Distribution Order Issue" window.

2. Create a new record.

3. Select an "Organization" -> Generic type without warehouses defined, for example "F&B España - Región Norte".

4. Change the "Organization" -> Legal Entity type, for example "F&B España, S.A" and select a warehouse Issue.

6. Change the Organization to the first Generic, in this example "F&B España - Región Norte".

Verify that it is possible to save the record.

This is another example:

https://drive.google.com/file/d/1YM2WyEnG1gOMLKBTNB19r764ufNAvALC/view [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-11-06 09:35LeyreNew Issue
2018-11-06 09:35LeyreAssigned To => Triage Finance
2018-11-06 09:35LeyreResolution time => 1574809200
2018-11-06 13:36SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-11-09 08:07PracticsIssue Monitored: Practics
2018-11-12 09:49SandrahuguetResolution time1574809200 => 1543273200
2018-11-21 06:30AtulOpenbravoStatusnew => scheduled
2018-11-21 09:12AtulOpenbravoNote Added: 0108025
2018-11-22 08:01AtulOpenbravoNote Added: 0108044
2018-11-23 13:03hgbotCheckin
2018-11-23 13:03hgbotNote Added: 0108077
2018-11-23 13:03hgbotStatusscheduled => resolved
2018-11-23 13:03hgbotResolutionopen => fixed
2018-11-23 13:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/77bc1041334a93809e5601708d0d881a1962f03c [^]
2018-11-23 13:04hgbotCheckin
2018-11-23 13:04hgbotNote Added: 0108078
2018-11-23 13:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/77bc1041334a93809e5601708d0d881a1962f03c [^] => http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.distributionorder/rev/9a91738d3e65fd000b1e252e629cd6326ac2cbac [^]
2018-11-23 13:05SandrahuguetReview Assigned To => Sandrahuguet
2018-11-23 13:05SandrahuguetNote Added: 0108079
2018-11-23 13:05SandrahuguetStatusresolved => closed
2018-11-23 17:55AtulOpenbravoNote Edited: 0108044bug_revision_view_page.php?bugnote_id=0108044#r17962

Notes
(0108025)
AtulOpenbravo   
2018-11-21 09:12   
Steps to Reproduce

- Login as F&B International Group Admin
- Navigate to Distribution Order Issue or Receipt window.
- Create a new record in Distribution Order Issue window
  Org: F&B España S.A
  Warehouse Issue: España Región Norte
  Warehouse Receipt: España Región Sur
- Before saving record modify organization to F&B España - Región Sur
- Realize that Warehouse Issue is with value "España Región Norte"
- Save record, create one line and book the order.
- Realize that message is shown as below:
Error:
The Warehouses defined in the header are not valid. Both Warehouses can not be the same and the Warehouse Receipt must belong to the selected Organization and the Warehouse Issue must belong to the Legal Entity of the selected Organization.
(0108044)
AtulOpenbravo   
2018-11-22 08:01   
(edited on: 2018-11-23 17:55)
Test Plan

- Login as F&B International Group Admin
- Navigate to Distribution Order Issue window.
- Create a new record
  Org: F&B España S.A
  Warehouse Issue: España Región Norte
  Warehouse Receipt: España Región Sur
- Before saving record modify organization to F&B España - Región Sur
- Realize that Warehouse Issue & Warehouse Receipt is cleared.
- Modify organization to F&B España - Región Norte
- Set Warehouse Receipt as "España Región Sur:
- Set Warehouse Issue as "España Región Sur"
- Change Organization to "F&B Us Inc"
- Realize that Warehouse Issue & Warehouse Receipt is cleared.


Similar tests could be performed for Distribution Receipt window.
(0108077)
hgbot   
2018-11-23 13:03   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: 77bc1041334a93809e5601708d0d881a1962f03c
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Nov 23 12:41:39 2018 +0530
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/77bc1041334a93809e5601708d0d881a1962f03c [^]

Fixes Issue 0039588: Distribution Order Issue - The "warehouse Issue"
is not refreshed when updating the "Organization".

** Implement a callout on organization field to clear warehouse issue
and warehouse receipt in Distribution Order Issue & Distribution Order
Receipt Window.

** Update where clause in DistributioOrderUtils to use warehouse id
which was wrongly using organization id.

---
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src/org/openbravo/distributionorder/erpCommon/utility/DistributioOrderUtils.java
A src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Organization.java
---
(0108078)
hgbot   
2018-11-23 13:04   
Repository: retail/backports/AWO/3.0RR18Q3/org.openbravo.distributionorder
Changeset: 9a91738d3e65fd000b1e252e629cd6326ac2cbac
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Nov 23 12:41:39 2018 +0530
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.distributionorder/rev/9a91738d3e65fd000b1e252e629cd6326ac2cbac [^]

Fixes Issue 0039588: Distribution Order Issue - The "warehouse Issue"
is not refreshed when updating the "Organization".

** Implement a callout on organization field to clear warehouse issue
and warehouse receipt in Distribution Order Issue & Distribution Order
Receipt Window.

** Update where clause in DistributioOrderUtils to use warehouse id
which was wrongly using organization id.

---
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src/org/openbravo/distributionorder/erpCommon/utility/DistributioOrderUtils.java
A src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Organization.java
---
(0108079)
Sandrahuguet   
2018-11-23 13:05   
Code review + testing OK