Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051202Openbravo ERP04. Warehouse managementpublic2022-12-20 12:032023-07-19 08:58
ReporterXABIER_AGUADO 
Assigned Toagusti_gallego 
PrioritylowSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051202: Cant remove a DO Line after doing a Put Away
DescriptionIf while we have a DO ond raft, we do a Put Away for the products involved in the DO, altough the bin is updated correctly, the lines cant be deleted anymore.
Steps To ReproduceConnect to AWO with SANDRO store user

Create a new distribution order

Select a quantity of a product.

Do not confirm the DO, keep it in draft mode and Click on back.

On the menu, do a PUT AWAY on the product selected in the DO and confirm the PUT AWAY.

Go back to the DO

Try deleting the Line

We get an error: org.hibernate.exception.ConstraintViolationException: could not execute statement

Proposed Solution
Additional Information
TagsFASH
Relationships
Attached Filespng Captura de pantalla 2022-12-20 120320.png (363,734) 2022-12-20 12:03
https://issues.openbravo.com/file_download.php?file_id=17961&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-12-20 12:03XABIER_AGUADONew Issue
2022-12-20 12:03XABIER_AGUADOAssigned To => Triage Omni WMS
2022-12-20 12:03XABIER_AGUADOFile Added: Captura de pantalla 2022-12-20 120320.png
2022-12-20 12:03XABIER_AGUADOModules => Core
2022-12-20 12:03XABIER_AGUADOTriggers an Emergency Pack => No
2022-12-20 12:03XABIER_AGUADOTag Attached: FASH
2023-01-31 14:30vmromanosNote Added: 0146083
2023-01-31 14:30vmromanosAssigned ToTriage Omni WMS => Sandrahuguet
2023-01-31 14:30vmromanosStatusnew => acknowledged
2023-02-03 10:27hgbotNote Added: 0146240
2023-02-13 08:50hgbotNote Added: 0146424
2023-02-13 08:52SandrahuguetRelationship addedcaused by 0051571
2023-02-13 08:53SandrahuguetRelationship deletedcaused by 0051571
2023-02-20 11:42SandrahuguetNote Added: 0146769
2023-03-15 12:27mtaalNote Added: 0147538
2023-03-15 12:28mtaalPrioritynormal => low
2023-03-16 15:03hgbotNote Added: 0147614
2023-04-27 11:40mtaalNote Added: 0148987
2023-06-08 08:51mtaalNote Edited: 0148987bug_revision_view_page.php?bugnote_id=0148987#r26233
2023-07-06 15:00hgbotNote Added: 0152164
2023-07-07 12:21hgbotResolutionopen => fixed
2023-07-07 12:21hgbotStatusacknowledged => closed
2023-07-07 12:21hgbotNote Added: 0152191
2023-07-07 12:21hgbotNote Added: 0152192
2023-07-14 10:30mtaalAssigned ToSandrahuguet => agusti_gallego
2023-07-14 10:30mtaalNote Added: 0152491
2023-07-14 10:30mtaalStatusclosed => new
2023-07-14 10:30mtaalResolutionfixed => open
2023-07-17 11:09hgbotNote Added: 0152547
2023-07-17 11:13hgbotNote Added: 0152548
2023-07-18 01:13hgbotNote Added: 0152574
2023-07-18 01:13hgbotNote Added: 0152575
2023-07-18 01:13hgbotNote Added: 0152576
2023-07-18 01:13hgbotNote Added: 0152577
2023-07-19 08:57mtaalStatusnew => scheduled
2023-07-19 08:58mtaalStatusscheduled => resolved
2023-07-19 08:58mtaalFixed in SCM revision => .
2023-07-19 08:58mtaalResolutionopen => fixed
2023-07-19 08:58mtaalStatusresolved => closed

Notes
(0146083)
vmromanos   
2023-01-31 14:30   
To be reviewed as part of the DO OTF without reservation project (Sandra). Note that, regardless the issue is not reproducible when working without reservations, we should fix it when working with reservations.
(0146240)
hgbot   
2023-02-03 10:27   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/105 [^]
(0146424)
hgbot   
2023-02-13 08:50   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/105 [^]
(0146769)
Sandrahuguet   
2023-02-20 11:42   
In DO OTF without reservation the issue is not reproducible
(0147538)
mtaal   
2023-03-15 12:27   
Only reproducable with reservations
(0147614)
hgbot   
2023-03-16 15:03   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/105 [^]
(0148987)
mtaal   
2023-04-27 11:40   
(edited on: 2023-06-08 08:51)
lower priority for customer involved as it is not reproducable/occur in their environment without reservations
(0152164)
hgbot   
2023-07-06 15:00   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/148 [^]
(0152191)
hgbot   
2023-07-07 12:21   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 3ce69e5eef1e0df3ca271e2a787275b2edaca73d
Author: Agustí Gállego <agusti.gallego@openbravo.com>
Date: 07-07-2023 10:21:09
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/3ce69e5eef1e0df3ca271e2a787275b2edaca73d [^]

Fixed ISSUE-51202: Removed reference to obdo_distorderline from m_reservation to prevent db constraint error

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/utils/AWOReservationDeleteManager.java
---
(0152192)
hgbot   
2023-07-07 12:21   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/148 [^]
(0152491)
mtaal   
2023-07-14 10:30   
We need to change the way it was implemented. We can not do a dependency from warehouse to distribution order module. So we need to add a hook type of approach to allow other modules to hook in this.
(0152547)
hgbot   
2023-07-17 11:09   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/81 [^]
(0152548)
hgbot   
2023-07-17 11:13   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/153 [^]
(0152574)
hgbot   
2023-07-18 01:13   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/153 [^]
(0152575)
hgbot   
2023-07-18 01:13   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: f1cba8b1c732d98ea168427eb1c9080267a79cf4
Author: Agustí Gállego <agusti.gallego@openbravo.com>
Date: 17-07-2023 10:48:19
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/f1cba8b1c732d98ea168427eb1c9080267a79cf4 [^]

Related to ISSUE-51202: Added structure to allow for reservation deletion hooks.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/utils/AWOReservationDeleteManager.java
---
(0152576)
hgbot   
2023-07-18 01:13   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: 9dcfd54f0cbd560c69ff5911ecc05210d8d59505
Author: Agustí Gállego <agusti.gallego@openbravo.com>
Date: 17-07-2023 22:52:17
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/9dcfd54f0cbd560c69ff5911ecc05210d8d59505 [^]

Related to ISSUE-51202: Added hook for reservation deletion

---
A src/org/openbravo/warehouse/advancedwarehouseoperations/distributionorders/hook/DOOTFDeleteReservationHook.java
---
(0152577)
hgbot   
2023-07-18 01:13   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/81 [^]