Openbravo Issue Tracking System - Modules
View Issue Details
0055504ModulesAdvanced Warehouse Operationspublic2024-05-17 00:082024-06-13 19:48
axelmercado 
mtaal 
highmajoralways
closedfixed 
5
 
 
approved
97172
OBPS
0055504: Error - Organization change in warehouse operations
When we have a warehouse operation of a product belonging to the parent organization (for example US), if we make movements corresponding to a child organization (US East Coast or US West Coast, the operation should not change organization, it should continue to belong to the parent organization.
1- In backoffice, create a Purchase Order with a parent organization (For example US).
2-In AWO receive the PO created before.
3-Check the warehouse operations, a new one has been created for the received product and the parent organization.
4- Perform any movement, it can be a put-away to another slot, move to another child warehouse or a picking of a SO from a sale of a child organization. Any action causes the warehouse operation in question to change organization which we believe is incorrect.
No tags attached.
related to defect 0057398 closed AtulOpenbravo Incorrect Organization set in Storage Detail 
png 2024-06-04_19-51.png (160,535) 2024-06-04 19:51
https://issues.openbravo.com/file_download.php?file_id=19875&type=bug
png
Issue History
2024-05-17 00:08axelmercadoNew Issue
2024-05-17 00:08axelmercadoAssigned To => Triage Omni WMS
2024-05-17 00:08axelmercadoOBNetwork customer => No
2024-06-03 11:38mtaalNote Added: 0165461
2024-06-03 11:38mtaalTypedefect => design defect
2024-06-03 21:38axelmercadoSupport ticket => 97172
2024-06-03 21:38axelmercadoOBNetwork customerNo => OBPS
2024-06-04 19:50mtaalNote Added: 0165574
2024-06-04 19:51mtaalFile Added: 2024-06-04_19-51.png
2024-06-07 10:59mtaalStatusnew => feedback
2024-06-07 11:02mtaalStatusfeedback => new
2024-06-13 11:49mtaalAssigned ToTriage Omni WMS => mtaal
2024-06-13 11:51hgbotMerge Request Status => open
2024-06-13 11:51hgbotNote Added: 0165904
2024-06-13 11:53mtaalNote Added: 0165905
2024-06-13 19:48hgbotMerge Request Statusopen => approved
2024-06-13 19:48hgbotResolutionopen => fixed
2024-06-13 19:48hgbotStatusnew => closed
2024-06-13 19:48hgbotNote Added: 0165923
2024-06-13 19:48hgbotNote Added: 0165924
2024-12-10 05:59AtulOpenbravoRelationship addedrelated to 0057398

Notes
(0165461)
mtaal   
2024-06-03 11:38   
after discussing with Victor seems at most a design defect
(0165574)
mtaal   
2024-06-04 19:50   
After further discussion:
- the organization field in the warehouse operation is currently the same as the ad_org_id of the storage detail
- however the way the storage detail ad_org_id is computed is not well defined and it should not be used directly
- instead the organization of the warehouse (of the storage detail should be used)

as we can understand that it can give confusion we propose to make the following change to the warehouse operations window:
- make the organization field the same value as the warehouse organization
- the consequence is that the organization filter will automatically filter out unwanted warehouse operations in that window and therefore prevent confusion

See the screenshot attached to this jira for how this will look like.
(0165904)
hgbot   
2024-06-13 11:51   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/268 [^]
(0165905)
mtaal   
2024-06-13 11:53   
Test plan:

before the fix:
- login with Openbravo, goto warehouse operations window, show the warehouse-organization and organization columns in the grid --> check that they can have different values.

after the change:
- login with Openbravo, goto warehouse operations window, show the warehouse-organization and organization columns in the grid --> check that they have the same values.
- make the warehouse operations window available for AWO_US_W
- login as AWO_US_W, goto warehouse operations check that the window shows only records of the west organization
(0165923)
hgbot   
2024-06-13 19:48   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: aa2eeeea70cedb965354e96a4e1880f9937554b5
Author: Martin Taal <martin.taal@openbravo.com>
Date: 13-06-2024 11:51:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/aa2eeeea70cedb965354e96a4e1880f9937554b5 [^]

Fixes ISSUE-55504: In warehouse operations window the org field should be based on warehouse of the storage detail

---
M src-db/database/model/views/OBAWO_WAREHOUSEOPS_V.xml
---
(0165924)
hgbot   
2024-06-13 19:48   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/268 [^]