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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038955
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Warehouse Pickingmajoralways2018-07-13 13:372018-07-31 12:44
ReporterLeyreView Statuspublic 
Assigned Tocollazoandy4 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6d2e0e14094a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0038955: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
causes defect 0039151 closedAtulOpenbravo When Is Quantity Variable is selected and reserved quantity is higher then order quantity picking list should take this quantity 

-  Notes
(0105842)
collazoandy4 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2018-07-31 12:44

 Code review + testing OK

- Issue History
Date Modified Username Field Change
2018-07-13 13:37 Leyre New Issue
2018-07-13 13:37 Leyre Assigned To => Triage Finance
2018-07-13 13:37 Leyre Regression date => 2018-03-08
2018-07-13 13:42 Practics Issue Monitored: Practics
2018-07-16 09:25 Leyre Regression date 2018-03-08 =>
2018-07-16 09:25 Leyre Resolution time => 1520463600
2018-07-16 10:51 aferraz Resolution time 1520463600 => 1533247200
2018-07-19 12:03 dmiguelez Assigned To Triage Finance => collazoandy4
2018-07-19 16:22 collazoandy4 Status new => scheduled
2018-07-23 17:30 collazoandy4 Note Added: 0105842
2018-07-31 12:24 hgbot Checkin
2018-07-31 12:24 hgbot Note Added: 0106035
2018-07-31 12:24 hgbot Status scheduled => resolved
2018-07-31 12:24 hgbot Resolution open => fixed
2018-07-31 12:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/6d2e0e14094ad2a2bf1b21e22211a6d814ce041b [^]
2018-07-31 12:24 hgbot Checkin
2018-07-31 12:24 hgbot Note Added: 0106036
2018-07-31 12:43 Sandrahuguet Note Added: 0106054
2018-07-31 12:43 Sandrahuguet Note Edited: 0106054 View Revisions
2018-07-31 12:44 Sandrahuguet Note Edited: 0106054 View Revisions
2018-07-31 12:44 Sandrahuguet Review Assigned To => Sandrahuguet
2018-07-31 12:44 Sandrahuguet Note Added: 0106055
2018-07-31 12:44 Sandrahuguet Status resolved => closed
2018-08-17 12:57 ngarcia Relationship added causes 0039151

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker