Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0057398ModulesAdvanced Warehouse Operationspublic2024-12-10 05:582025-01-10 11:11
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date2023-09-08
Regression introduced by commithttps://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/171/diffs?commit_id=d11398082bbf5b75fc50bae8e17ecfd7ee181e33 [^]
Regression levelProduction - Confirmed Stable
Review Assigned Tovmromanos
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0057398: Incorrect Organization set in Storage Detail
DescriptionWhen 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.
Steps To ReproduceIn backoffice, Login with AWO-QAAdmin Role, Organization: US, Warehouse: US East Coast.


1. Create a Purchase Order
  - Organization: US
  - Business Partner: Be Soft Drinker, Inc.
  - Warehouse: US East Coast
  - Product: Ale Beer, Quantity 250
  - Book PO.


2-In AWO Front, Login with AWO-QAAdmin Role, Organization: US, Warehouse: US East Coast.
3. Receive the PO created in Storage Bin: Food002
4. Navigate to Back Office
5. Go to Product : Ale Beer, Stock Tab: Select the ID from record with Storage Bin: Food002.
6. Using PgAdmin Tool, in DB check that AD_Org_ID for this record is of US Org i.e F477B20FCDEB46D897DC5B361B92D95F

7. Navigate to Warehouse Operations, select the line with Product : Ale Beer, Storage Bin: Food002, Quantity: 250.
8. Move it to Storage Bin: Food 003.
9. Process the Task create for above operations.
10. Navigate to Back Office
11. Go to Product : Ale Beer, Stock Tab: Select the ID from record with Storage Bin: Food003.
12. Using PgAdmin Tool, in DB check that AD_Org_ID for this record is of US East Coast Org i.e 3FF21930C89F4A8FAC60E7264BF96568

Proposed Solution-
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0055504 closed mtaal Error - Organization change in warehouse operations 
caused by defect 0053420 closed AtulOpenbravo IC > EWPT when moving stock with organization different than warehouse org in Warehouse Operations 
related to backport 0057558 closed AtulOpenbravo Incorrect Organization set in Storage Detail 
related to backport 0057559 closed AtulOpenbravo Incorrect Organization set in Storage Detail 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-12-10 05:58AtulOpenbravoNew Issue
2024-12-10 05:58AtulOpenbravoAssigned To => Triage Omni WMS
2024-12-10 05:58AtulOpenbravoOBNetwork customer => No
2024-12-10 05:58AtulOpenbravoStatusnew => scheduled
2024-12-10 05:58AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo
2024-12-10 05:59AtulOpenbravoRelationship addedrelated to 0055504
2024-12-10 05:59AtulOpenbravoRelationship addedcaused by 0053420
2024-12-10 06:01AtulOpenbravoRegression date => 2023-09-08
2024-12-10 06:01AtulOpenbravoRegression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/171/diffs?commit_id=d11398082bbf5b75fc50bae8e17ecfd7ee181e33 [^]
2024-12-10 06:01AtulOpenbravoRegression level => Production - Confirmed Stable
2024-12-10 06:01AtulOpenbravoReview Assigned To => vmromanos
2024-12-10 06:39AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=28889#r28889
2024-12-10 06:56hgbotMerge Request Status => open
2024-12-10 06:56hgbotNote Added: 0173101
2024-12-11 06:59AtulOpenbravoNote Added: 0173153
2024-12-11 07:00AtulOpenbravoNote Edited: 0173153bug_revision_view_page.php?bugnote_id=0173153#r28897
2024-12-11 07:01AtulOpenbravoNote Edited: 0173153bug_revision_view_page.php?bugnote_id=0173153#r28898
2024-12-11 07:01AtulOpenbravoNote Edited: 0173153bug_revision_view_page.php?bugnote_id=0173153#r28899
2024-12-11 07:15AtulOpenbravoNote Added: 0173154
2024-12-11 07:15AtulOpenbravoNote Edited: 0173154bug_revision_view_page.php?bugnote_id=0173154#r28901
2024-12-22 19:21AtulOpenbravoNote Edited: 0173154bug_revision_view_page.php?bugnote_id=0173154#r28956
2024-12-24 16:39axelmercadoIssue Monitored: axelmercado
2025-01-03 05:31AtulOpenbravoRelationship addedrelated to 0057558
2025-01-03 05:32AtulOpenbravoRelationship addedrelated to 0057559
2025-01-10 10:32hgbotMerge Request Statusopen => approved
2025-01-10 11:11hgbotResolutionopen => fixed
2025-01-10 11:11hgbotStatusscheduled => closed
2025-01-10 11:11hgbotNote Added: 0173988
2025-01-10 11:11hgbotNote Added: 0173989
2025-01-10 11:11hgbotNote Added: 0173990

Notes
(0173101)
hgbot   
2024-12-10 06:56   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/340 [^]
(0173153)
AtulOpenbravo   
2024-12-11 06:59   
(edited on: 2024-12-11 07:01)
Test Plan

In backoffice, Login with AWO-QAAdmin Role, Organization: US, Warehouse: US East Coast.

1. Create a Purchase Order
  - Organization: US
  - Business Partner: Be Soft Drinker, Inc.
  - Warehouse: US East Coast
  - Product: Ale Beer, Quantity 250
  - Book PO.

2-In AWO Front, Login with AWO-QAAdmin Role, Organization: US, Warehouse: US East Coast.
3. Receive the PO created in Storage Bin: Food002
4. Navigate to Back Office
5. Go to Product : Ale Beer, Stock Tab: Select the ID from record with Storage Bin: Food002.
6. Using PgAdmin Tool, in DB check that AD_Org_ID for this record is of US Org i.e F477B20FCDEB46D897DC5B361B92D95F

7. In Back Office, navigate to Warehouse Operations, select the line with Product : Ale Beer, Storage Bin: Food002, Quantity: 250.
8. Move it to Storage Bin: Food 003.
9. Confirm the Task created for above operations.
10. Navigate to Back Office
11. Go to Product : Ale Beer, Stock Tab: Select the ID from record with Storage Bin: Food003.
12. Check the Movement's Organization in the related Goods Movement. It should be US Org.
13. Using PgAdmin Tool, in DB check that AD_Org_ID for Stock record for Food003 Storage Bin is US Org i.e F477B20FCDEB46D897DC5B361B92D95F
(0173154)
AtulOpenbravo   
2024-12-11 07:15   
(edited on: 2024-12-22 19:21)
Test Plan

- In AWO Front End, Login with User AWO_US_E, Organization: US East Coast, Warehouse: US East Coast.
- Navigate to Menu Count. Keep selected user as AWO_US_E, Click on start count
- Keep the Storage Bin as Beverage101. Click on Add
- Select Line for Stocked Product Ale Beer, Click on OK.
- Set the Quantity as 35.
- Confirm the Inventory Count.
- Realize that task is confirmed Ok.
- Login to Back Office.
- Check Product Stock tab and select record id for the Beverage101 Stock Line.
- Check In DB, Organization Id from it is of US Org i.e "F477B20FCDEB46D897DC5B361B92D95F"
- Navigate to Physical Inventory record from the Product | Transaction tab record linked with above operation.
- Organization of the Physical Inventory header is US East Coast Org.

- Navigate to Front End again with User AWO_US_E, Organization: US East Coast, Warehouse: US East Coast
- Choose Put Away Menu
- Search for Ale Beer Product and select line with Stock in Beverage101, Set Qty as 5.
- Click on Green Ok Check button.
- Click on the Put Away task added in users task list
- Select To Bin as Food001
- Confirm the Task.
- Realize that Task is confirmed successfully.

- In Back Office, navigate to Product | Transaction Tab and click on related to Movement Line record.
- Realize that header of the Movement is US Org.
- In DB check Organization ID for Stock Line with Food001 Storage Bin with Qty 5, it should be US Org.
- header of the Movement is US Org.
- In DB check Organization ID for Stock Line with Beverage101 Storage Bin with Qty 30, it should be US Org.
(0173988)
hgbot   
2025-01-10 11:11   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 63ad787bf53131fe2675adef0a2f438c8b082b9b
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 08-01-2025 22:10:38
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/63ad787bf53131fe2675adef0a2f438c8b082b9b [^]

Fixes BUG-0057398: Revert commit

**Revert the change to set Organization of Storage bin from
Storage Details in Task Requirement.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/StorageDetailUtils.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/TaskRequirement.java
---
(0173989)
hgbot   
2025-01-10 11:11   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: b95c9287546a22b497ea6add3544984d82fd42b3
Author: Víctor Martínez Romanos <v.martinez@orisha.com>
Date: 10-01-2025 13:46:07
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/b95c9287546a22b497ea6add3544984d82fd42b3 [^]

Fixes BUG-0057398: Admin mode false when generating and confirming Counts

The storage detail might belong to an organization without write access.
In this case DAL, exceptionally, must not check the organization to allow
saving the task in the storage detail organization.

This organization is used later on to create the Inventory Count and, when
processing it, to update the storage detail accordingly.

With this changeset we ensure the task and inventory count are properly saved,
and that the storage detail keeps its original organization.

This is how it works the Put-Away like tasks, which are also based on a
storage detail.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/InventoryCountGenerator.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/processors/InventoryCountConfirmProcessor.java
---
(0173990)
hgbot   
2025-01-10 11:11   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/340 [^]