Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0055771Openbravo ERP04. Warehouse managementpublic2024-06-14 10:582024-06-16 23:36
vmromanos 
AtulOpenbravo 
normalcriticalalways
closedfixed 
5
 
PR24Q3 
approved
No
Core
Pre packaging ( pi )
2025-04-08
pi
https://gitlab.com/openbravo/product/openbravo/-/commit/e736cae99bf301d8722f501c693907fb7378300a [^]
No
0055771: Bins defined with Included Handling Unit Types = "Only those defined" block any transaction of individual items
It 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.
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. 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.


See 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.
No tags attached.
caused by feature request 0054885 closed AtulOpenbravo Modules Storage Type for Goods Transaction - Data Model 
diff 55771-proposed-solution.diff (2,201) 2024-06-14 11:00
https://issues.openbravo.com/file_download.php?file_id=19915&type=bug
Issue History
2024-06-14 10:58vmromanosNew Issue
2024-06-14 10:58vmromanosAssigned To => Triage Omni WMS
2024-06-14 10:58vmromanosOBNetwork customer => No
2024-06-14 10:58vmromanosModules => Core
2024-06-14 10:58vmromanosTriggers an Emergency Pack => No
2024-06-14 11:00vmromanosFile Added: 55771-proposed-solution.diff
2024-06-14 11:08vmromanosRelationship addedcaused by 0054885
2024-06-14 11:13vmromanosRegression level => Pre packaging ( pi )
2024-06-14 11:13vmromanosRegression date => 2025-04-08
2024-06-14 11:13vmromanosRegression introduced in release => pi
2024-06-14 11:13vmromanosRegression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/e736cae99bf301d8722f501c693907fb7378300a [^]
2024-06-14 21:08hgbotMerge Request Status => open
2024-06-14 21:08hgbotNote Added: 0165971
2024-06-14 21:15AtulOpenbravoStatusnew => scheduled
2024-06-14 21:15AtulOpenbravoNote Added: 0165972
2024-06-14 21:15AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo
2024-06-16 23:36hgbotMerge Request Statusopen => approved
2024-06-16 23:36hgbotResolutionopen => fixed
2024-06-16 23:36hgbotStatusscheduled => closed
2024-06-16 23:36hgbotFixed in Version => PR24Q3
2024-06-16 23:36hgbotNote Added: 0165977
2024-06-16 23:36hgbotNote Added: 0165978

Notes
(0165971)
hgbot   
2024-06-14 21:08   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1279 [^]
(0165972)
AtulOpenbravo   
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   
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   
2024-06-16 23:36   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1279 [^]