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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035281
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Warehouse Pickingmajoralways2017-02-15 20:042017-03-24 14:17
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision4b3fce984919
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Regression introduced in release
Summary

0035281: Picking list is created with stock of a on hand warehouse if there exists some stock in the warehouse of the sales order header

DescriptionPicking list is created with stock of a on hand warehouse if there exists some stock in the warehouse of the sales order header
Steps To ReproduceAs group admin role:
   Set the Enable Stock Reservations preference to Y
   Log out and log in
   Create a new product in F&B España, S.A.
   Add Region Norte and Region Sur warehouses as on hand warehouses to F&B España, S.A. organization
   Create a goods receipt in Region Sur warehouse, add 10 units of the previously created product and complete it
   Create a Sales Order for F&B España S.A. and Region Norte warehouse
   Add 5 units of the previously created product to it
   Complete it
   Try to Generate Picking List and check an error message is shown:
      "There is not enough available stock"
   The log shows:
      ERROR org.openbravo.base.exception.OBException - There is not enough available stock
org.openbravo.base.exception.OBException: There is not enough available stock
    at org.openbravo.warehouse.pickinglist.Utilities.processOrder(Utilities.java:180)
    at org.openbravo.warehouse.pickinglist.CreateActionHandler.doCreate(CreateActionHandler.java:265)
    at org.openbravo.warehouse.pickinglist.CreateActionHandler.execute(CreateActionHandler.java:84)


   Create a goods receipt in Region Norte warehouse, add 2 units of the previously created product and complete it
   Go to the previously created sales order and Generate Picking List
   Check 2 units have been taken from Region Norte and 3 for Region Sur warehouse
   Process it
   Check a goods shipment for Region Norte warehouse has been created with a storage bin of Region Norte and another storage bin for Region Sur. This is also wrong
Proposed SolutionAnalyze which of the following three options is the suitable one:

1. Get the stock only from the sales order header warehouse

2. Get the stock from all the on hand warehouses of the sales order header organization, prioritizing the one defined in the sales order header, but getting it from a different warehouse in case there is not stock in the header organization. Bug reported in this ticket. In this case, one goods shipment and one picking list should be created for each warehouse.

3. Make the process configurable by a preference in order to work as in 1 or in 2
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035647 scheduledAtulOpenbravo Picking list is created with stock of a on hand warehouse other than Warehouse in Sales Order Header 
related to defect 0039820 closedAtulOpenbravo Picking list is created with stock from a warehouse different than the order's warehouse if reservation without warehouse exists 

-  Notes
(0095435)
dmitry_mezentsev (developer)
2017-03-20 18:25

 Ping.
1 month without any progress.
Thanks.
(0095464)
aferraz (manager)
2017-03-21 12:22

 Proposed solution: Get the stock only from the sales order header warehouse.
(0095558)
hgbot (developer)
2017-03-24 14:14

 Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 4b3fce984919dd9dfb4b620a1eac2120c1ee0c75
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Mar 23 23:51:18 2017 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/4b3fce984919dd9dfb4b620a1eac2120c1ee0c75 [^]

Fixes issue 35281: Get stock only from order warehouse when creating a picking

Set warehouse to created reservation from order line before calling to M_Reservation_Post.
M_Reservation_Post process will call to M_Rerserve_Stock_Auto, which will reserve stock in every on hand warehouse of reservation organization (order organization) in case reservation warehouse is null.

---
M src/org/openbravo/warehouse/pickinglist/Utilities.java
---
(0095559)
hgbot (developer)
2017-03-24 14:14

 Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 58ef2ce5bc4e3cb62bd780b3fb151a7da6324819
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Mar 24 14:12:52 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/58ef2ce5bc4e3cb62bd780b3fb151a7da6324819 [^]

Related to issue 35281: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0095560)
aferraz (manager)
2017-03-24 14:17

 Code review + Testing OK

- Issue History
Date Modified Username Field Change
2017-02-15 20:04 ngarcia New Issue
2017-02-15 20:04 ngarcia Assigned To => Triage Finance
2017-02-15 20:04 ngarcia Resolution time => 1488927600
2017-02-15 20:04 ngarcia Issue Monitored: networkb
2017-02-16 14:00 ngarcia Steps to Reproduce Updated View Revisions
2017-02-16 14:00 ngarcia Proposed Solution updated
2017-02-16 15:04 markmm82 Assigned To Triage Finance => AtulOpenbravo
2017-02-20 05:38 AtulOpenbravo Status new => scheduled
2017-03-20 18:25 dmitry_mezentsev Note Added: 0095435
2017-03-21 12:22 aferraz Note Added: 0095464
2017-03-24 14:14 hgbot Checkin
2017-03-24 14:14 hgbot Note Added: 0095558
2017-03-24 14:14 hgbot Status scheduled => resolved
2017-03-24 14:14 hgbot Resolution open => fixed
2017-03-24 14:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/4b3fce984919dd9dfb4b620a1eac2120c1ee0c75 [^]
2017-03-24 14:14 hgbot Checkin
2017-03-24 14:14 hgbot Note Added: 0095559
2017-03-24 14:17 aferraz Review Assigned To => aferraz
2017-03-24 14:17 aferraz Note Added: 0095560
2017-03-24 14:17 aferraz Status resolved => closed
2017-03-30 11:42 AtulOpenbravo Relationship added related to 0035647
2018-12-17 13:51 ngarcia Relationship added related to 0039820

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker