Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0057398
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2024-12-10 05:582025-01-10 11:11
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0057398: 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-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0055504 closedmtaal Error - Organization change in warehouse operations 
caused by defect 0053420 closedAtulOpenbravo IC > EWPT when moving stock with organization different than warehouse org in Warehouse Operations 
related to backport 0057558 closedAtulOpenbravo Incorrect Organization set in Storage Detail 
related to backport 0057559 closedAtulOpenbravo Incorrect Organization set in Storage Detail 

-  Notes
(0173101)
hgbot (developer)
2024-12-10 06:56

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/340 [^]
(0173153)
AtulOpenbravo (viewer)
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 (viewer)
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 (developer)
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 (developer)
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 (developer)
2025-01-10 11:11

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/340 [^]

- Issue History
Date Modified Username Field Change
2024-12-10 05:58 AtulOpenbravo New Issue
2024-12-10 05:58 AtulOpenbravo Assigned To => Triage Omni WMS
2024-12-10 05:58 AtulOpenbravo OBNetwork customer => No
2024-12-10 05:58 AtulOpenbravo Status new => scheduled
2024-12-10 05:58 AtulOpenbravo Assigned To Triage Omni WMS => AtulOpenbravo
2024-12-10 05:59 AtulOpenbravo Relationship added related to 0055504
2024-12-10 05:59 AtulOpenbravo Relationship added caused by 0053420
2024-12-10 06:01 AtulOpenbravo Regression date => 2023-09-08
2024-12-10 06:01 AtulOpenbravo Regression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/171/diffs?commit_id=d11398082bbf5b75fc50bae8e17ecfd7ee181e33 [^]
2024-12-10 06:01 AtulOpenbravo Regression level => Production - Confirmed Stable
2024-12-10 06:01 AtulOpenbravo Review Assigned To => vmromanos
2024-12-10 06:39 AtulOpenbravo Steps to Reproduce Updated View Revisions
2024-12-10 06:56 hgbot Merge Request Status => open
2024-12-10 06:56 hgbot Note Added: 0173101
2024-12-11 06:59 AtulOpenbravo Note Added: 0173153
2024-12-11 07:00 AtulOpenbravo Note Edited: 0173153 View Revisions
2024-12-11 07:01 AtulOpenbravo Note Edited: 0173153 View Revisions
2024-12-11 07:01 AtulOpenbravo Note Edited: 0173153 View Revisions
2024-12-11 07:15 AtulOpenbravo Note Added: 0173154
2024-12-11 07:15 AtulOpenbravo Note Edited: 0173154 View Revisions
2024-12-22 19:21 AtulOpenbravo Note Edited: 0173154 View Revisions
2024-12-24 16:39 axelmercado Issue Monitored: axelmercado
2025-01-03 05:31 AtulOpenbravo Relationship added related to 0057558
2025-01-03 05:32 AtulOpenbravo Relationship added related to 0057559
2025-01-10 10:32 hgbot Merge Request Status open => approved
2025-01-10 11:11 hgbot Resolution open => fixed
2025-01-10 11:11 hgbot Status scheduled => closed
2025-01-10 11:11 hgbot Note Added: 0173988
2025-01-10 11:11 hgbot Note Added: 0173989
2025-01-10 11:11 hgbot Note Added: 0173990


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker