Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038955ModulesWarehouse Pickingpublic2018-07-13 13:372018-07-31 12:44
ReporterLeyre 
Assigned Tocollazoandy4 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket3037
OBNetwork customerOBPS
Regression introduced in release
Summary0038955: Error in picking list
DescriptionError in picking list when you reserve a quantity of a product, distributed in two attributes and the same bin, and you delete a good shipment.
Steps To ReproduceBackend:
1. Create a sales order (with a quantity of a product distributed in two attributes)
2. Picking list.
3. In warehouse picking list window delete a line and process.
4. Return to the sales order and picking list again.
5. In warehouse picking list, refresh and process the draft document.
6. Delete one of the Good Shipments generated.
7. In sales order, generate picking list and verify that you obtain an error: "Could not execute JDBC batch update"

The complete process:
https://www.youtube.com/watch?v=nQwUMCgdlMg&feature=youtu.be [^]

The error could be generated in the trigger M_INOUTLINE_TRG.xml - line 100
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0039151 closed AtulOpenbravo When Is Quantity Variable is selected and reserved quantity is higher then order quantity picking list should take this quantity 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-07-13 13:37LeyreNew Issue
2018-07-13 13:37LeyreAssigned To => Triage Finance
2018-07-13 13:37LeyreRegression date => 2018-03-08
2018-07-13 13:37LeyreSupport ticket => 3037
2018-07-13 13:37LeyreOBNetwork customer => Yes
2018-07-13 13:42PracticsIssue Monitored: Practics
2018-07-16 09:25LeyreRegression date2018-03-08 =>
2018-07-16 09:25LeyreResolution time => 1520463600
2018-07-16 10:51aferrazResolution time1520463600 => 1533247200
2018-07-19 12:03dmiguelezAssigned ToTriage Finance => collazoandy4
2018-07-19 16:22collazoandy4Statusnew => scheduled
2018-07-23 17:30collazoandy4Note Added: 0105842
2018-07-31 12:24hgbotCheckin
2018-07-31 12:24hgbotNote Added: 0106035
2018-07-31 12:24hgbotStatusscheduled => resolved
2018-07-31 12:24hgbotResolutionopen => fixed
2018-07-31 12:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/6d2e0e14094ad2a2bf1b21e22211a6d814ce041b [^]
2018-07-31 12:24hgbotCheckin
2018-07-31 12:24hgbotNote Added: 0106036
2018-07-31 12:43SandrahuguetNote Added: 0106054
2018-07-31 12:43SandrahuguetNote Edited: 0106054bug_revision_view_page.php?bugnote_id=0106054#r17476
2018-07-31 12:44SandrahuguetNote Edited: 0106054bug_revision_view_page.php?bugnote_id=0106054#r17477
2018-07-31 12:44SandrahuguetReview Assigned To => Sandrahuguet
2018-07-31 12:44SandrahuguetNote Added: 0106055
2018-07-31 12:44SandrahuguetStatusresolved => closed
2018-08-17 12:57ngarciaRelationship addedcauses 0039151

Notes
(0105842)
collazoandy4   
2018-07-23 17:30   
Test Plan
  Create a new Sales Order with ordered qty = 10
  Generate a Picking list from the previous order
  Go to the Picking List created and edit the line with qty = 7, Process it and Check:
    Order Partially Reserved
    Order Delivery Status: 70%
    Reservation Quantity: 10, Reserved qty = 7, Released: 7, Status Completed
  Generate a Picking list from the previous order
  Go to the Picking List created and check:
    PL Movement qty: 3
    Order Completely Reserved
    Order Delivery Status: 100%
    Reservation Quantity: 10, Reserved qty = 10, Released: 10, Status Closed
  Navigate to the shipment created and Void it and check:
    Order Partially Reserved
    Order Delivery Status: 70%
    A new reservation is created with Reservation Quantity: 10, Reserved qty = 3, Released: 0, Status Completed
  Generate a Picking list from the previous order
  Go to the Picking List created and check:
    PL Movement qty: 3
    Order Completely Reserved
    Order Delivery Status: 100%
    Reservation Quantity: 10, Reserved qty = 3, Released: 3, Status Closed

Test Plan II
  Create a new Product with Lote as Attribute set, added a sales price list
  Receipts 10 units of the previous product with lote: 123 and 15 units with lote: 456
  Create a new Sales Order for the previous product created with qty 12
  Generate a Picking List from the previous order, remove the line with qty 2, process it and check
    Order Partially Reserved
    Order Delivery Status: 73%
    Reservation Quantity: 12, Reserved qty = 10, Released: 10, Status Completed
  Generate a Picking list from the previous order
  Go to the Picking List created and check:
    PL Movement qty: 2
    Order Completely Reserved
    Order Delivery Status: 100%
    Reservation Quantity: 12, Reserved qty = 12, Released: 12, Status Closed
  Navigate to the shipment created and Void it and check:
    Order Partially Reserved
    Order Delivery Status: 83%
    A new reservation is created with Reservation Quantity: 12, Reserved qty = 2, Released: 0, Status Completed
  Generate a Picking list from the previous order
  Go to the Picking List created and check:
    PL Movement qty: 2
    Order Completely Reserved
    Order Delivery Status: 100%
    Reservation Quantity: 12, Reserved qty = 2, Released: 2, Status Closed
(0106035)
hgbot   
2018-07-31 12:24   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 6d2e0e14094ad2a2bf1b21e22211a6d814ce041b
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Thu Jul 19 22:37:17 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/6d2e0e14094ad2a2bf1b21e22211a6d814ce041b [^]

Fixes issue 38955:Error in picking list when you reserve a quantity of a product
distributed in two attributes and the same bin, and you delete a good shipment.

When a sales order is partially picked and the shipment is partially voided the
Picking List process fail because a reserved quantity greater than order line
pending qty was used to create a shipment line as movement qty

Now if the reserved quantity is greater than order line pending qty the pending
qty is used to create the shipment line as movement qty

---
M src/org/openbravo/warehouse/pickinglist/Utilities.java
---
(0106036)
hgbot   
2018-07-31 12:24   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 34959914d79496b9474b98b8f8e3fe3c7afa576f
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Thu Jul 19 23:01:44 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/34959914d79496b9474b98b8f8e3fe3c7afa576f [^]

Related to Issue 38955. Updated Module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0106054)
Sandrahuguet   
2018-07-31 12:43   
(edited on: 2018-07-31 12:44)
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: e56965d179f9
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: Tue, 31 Jul 2018 12:35:55 +0200
URL:https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/e56965d179f9 [^]

Related to Issue 38955. Updated Module version
(0106055)
Sandrahuguet   
2018-07-31 12:44   
Code review + testing OK