Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0057317ModulesDistribution Order for Advanced Warehouse Operationspublic2024-11-28 10:282024-12-10 10:06
Reportercaristu 
Assigned ToTriage Omni WMS 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0057317: Pending To Generate Picking field does not take into account Pick and Pack tasks
DescriptionThe Pending To Generate Picking field does not take into account Pick and Pack tasks

Note that this field is a computed column making use of the OBDOA_DOLINE_PENDINGPICKING function
Steps To Reproduce1) Login as AWO-QA Admin role
2) Open the Distribution Order Issue window
3) Select the DO with document number 1000127 and Order Date 18-11-2024
4) Switch to the lines tab and check the value of the Pending To Generate Picking field. Note that value is wrong because is not zero. It should be zero because all the line quantity is already picked but with a Pick DO on the Fly task (Pick and Pack)
Proposed SolutionTake into account the Pick and Pack task in the OBDOA_DOLINE_PENDINGPICKING function
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0055194 closed vmromanos DO OTF with Picking instead of Issue 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-11-28 10:28caristuNew Issue
2024-11-28 10:28caristuAssigned To => Triage Omni WMS
2024-11-28 10:31caristuRelationship addedrelated to 0055194
2024-11-28 10:35hgbotNote Added: 0172693
2024-11-28 10:37caristuDescription Updatedbug_revision_view_page.php?rev_id=28835#r28835
2024-11-28 10:38caristuProposed Solution updated
2024-11-28 10:41caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=28837#r28837
2024-12-09 07:50hgbotResolutionopen => fixed
2024-12-09 07:50hgbotStatusnew => closed
2024-12-09 07:50hgbotNote Added: 0173049
2024-12-09 07:50hgbotNote Added: 0173050
2024-12-09 07:50hgbotNote Added: 0173051
2024-12-10 10:06hgbotNote Added: 0173124

Notes
(0172693)
hgbot   
2024-11-28 10:35   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/200 [^]
(0173049)
hgbot   
2024-12-09 07:50   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: 5ac5d97d7b17696dcce5373a2ed72473070668f1
Author: Carlos Aristu <c.aristu@orisha.com>
Date: 09-12-2024 06:50:10
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/5ac5d97d7b17696dcce5373a2ed72473070668f1 [^]

fixes BUG-57317: Pending To Generate Picking is not considering Pick and Pack tasks

---
M src-db/database/model/functions/OBDOA_DOLINE_PENDINGPICKING.xml
---
(0173050)
hgbot   
2024-12-09 07:50   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: ad634ffb521195b5a77dc3d633ecb6fe79e5bb82
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 09-12-2024 06:50:10
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/ad634ffb521195b5a77dc3d633ecb6fe79e5bb82 [^]

Related to BUG-57317: Consider PPI in PL functions related to picking information.

For these PL functions, it is the same a normal Picking (PIK) and a Pick+Pack (PP).

Besides, the Pick+Pack+Issue action (PPI) is the same as a normal Issue for DOi (ISSI).

Finally, the query to calculate the issue tasks without a previous picking now considers
the right issue action for DOi (ISSI) instead of the issue action for SO (ISS).

---
M src-db/database/model/functions/OBDOA_DISTORDER_PENDINGPICKING.xml
M src-db/database/model/functions/OBDOA_DOLINE_PENDINGPICKING.xml
---
(0173051)
hgbot   
2024-12-09 07:50   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/200 [^]
(0173124)
hgbot   
2024-12-10 10:06   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: af4ac0fca6528288c60830123d8c64ba907ef164
Author: Carlos Aristu <c.aristu@orisha.com>
Date: 10-12-2024 10:06:30
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/af4ac0fca6528288c60830123d8c64ba907ef164 [^]

related to BUG-57317: fix expected property value

---
M src-test/data/export/filter/distributionorder/DOIssueWithHU.json
---