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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0055771
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementcriticalalways2024-06-14 10:582024-06-16 23:36
ReportervmromanosView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in VersionPR24Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2025-04-08
Regression introduced in releasepi
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/e736cae99bf301d8722f501c693907fb7378300a [^]
Triggers an Emergency PackNo
Summary

0055771: Bins defined with Included Handling Unit Types = "Only those defined" block any transaction of individual items

DescriptionIt is not possible to perform any warehouse transaction involving individual items (i.e. not included in a handling unit) when the Storage Bin is defined as Included Handling Unit Types = "Only those defined"

This is a critical bug as it totally blocks any warehouse transaction when this configuration is enabled.
Steps To ReproduceIn backoffice with F&B Admin role.
Go to Warehouse and Storage Bin and select "España Región Norte".
Create a new Storage Bin. Make sure you select Included Handling Unit Types = "Only those defined".
Enter any record in Handling Unit Type subtab (or it can be left empty to reproduce the bug too).

Go to goods movement.
Create a new record for "España Región Norte".
Go to lines and select Cerveza Ale 0,5L (not included in a Handling Unit).
In New Storage Bin field select the new one.
Process Movement. An error is thrown: "Handling Unit Type is not valid for this storage bin <the new bin>"

This is wrong. The transaction doesn't have any handling unit so the validation shouldn't be performed.


Proposed SolutionSee attached file.

The validation related to Included Handling Unit Types is only performed when there is a handling unit involved in the transaction.
This also helps to improve performance a little bit of this central trigger.
TagsNo tags attached.
Attached Filesdiff file icon 55771-proposed-solution.diff [^] (2,201 bytes) 2024-06-14 11:00 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
caused by feature request 0054885 closedAtulOpenbravo Modules Storage Type for Goods Transaction - Data Model 

-  Notes
(0165971)
hgbot (developer)
2024-06-14 21:08

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1279 [^]
(0165972)
AtulOpenbravo (viewer)
2024-06-14 21:15

- In backoffice with F&B Admin role.
- Go to Warehouse and Storage Bin and select "España Región Norte".
- Create a new Storage Bin. Make sure you select Included Handling Unit Types = "Only those defined".
- Enter any record in Handling Unit Type subtab (or it can be left empty to reproduce the bug too).

- Go to goods movement.
- Create a new record for "España Región Norte".
- Go to lines and select Cerveza Ale 0,5L (not included in a Handling Unit).
- In New Storage Bin field select the new one.
- Process Movement.
- Realize that Goods Movement is processed successfully.
(0165977)
hgbot (developer)
2024-06-16 23:36

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 51748bd61c733abeb946df00cd61c146c580bc78
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 16-06-2024 21:36:24
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/51748bd61c733abeb946df00cd61c146c580bc78 [^]

Fixes ISSUE-55771: Bins defined with Included Handling Unit Types="Only those defined" block any transaction of individual items

---
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-test/src/org/openbravo/test/storageBin/StorageBinTest.java
---
(0165978)
hgbot (developer)
2024-06-16 23:36

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1279 [^]

- Issue History
Date Modified Username Field Change
2024-06-14 10:58 vmromanos New Issue
2024-06-14 10:58 vmromanos Assigned To => Triage Omni WMS
2024-06-14 10:58 vmromanos OBNetwork customer => No
2024-06-14 10:58 vmromanos Modules => Core
2024-06-14 10:58 vmromanos Triggers an Emergency Pack => No
2024-06-14 11:00 vmromanos File Added: 55771-proposed-solution.diff
2024-06-14 11:08 vmromanos Relationship added caused by 0054885
2024-06-14 11:13 vmromanos Regression level => Pre packaging ( pi )
2024-06-14 11:13 vmromanos Regression date => 2025-04-08
2024-06-14 11:13 vmromanos Regression introduced in release => pi
2024-06-14 11:13 vmromanos Regression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/e736cae99bf301d8722f501c693907fb7378300a [^]
2024-06-14 21:08 hgbot Merge Request Status => open
2024-06-14 21:08 hgbot Note Added: 0165971
2024-06-14 21:15 AtulOpenbravo Status new => scheduled
2024-06-14 21:15 AtulOpenbravo Note Added: 0165972
2024-06-14 21:15 AtulOpenbravo Assigned To Triage Omni WMS => AtulOpenbravo
2024-06-16 23:36 hgbot Merge Request Status open => approved
2024-06-16 23:36 hgbot Resolution open => fixed
2024-06-16 23:36 hgbot Status scheduled => closed
2024-06-16 23:36 hgbot Fixed in Version => PR24Q3
2024-06-16 23:36 hgbot Note Added: 0165977
2024-06-16 23:36 hgbot Note Added: 0165978


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker