Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0032089 | Openbravo ERP | 04. Warehouse management | public | 2016-02-02 13:27 | 2016-03-17 10:56 |
|
| Reporter | ngarcia | |
| Assigned To | aferraz | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | vmromanos |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0032089: Product with stock in second UOM is automatically reserved but it is not possible to reserve it manually |
| Description | Product with stock in second UOM is automatically reserved but it is not possible to reserve it manually |
| Steps To Reproduce | As system admin role:
Set as displayed the 'Order UOM' and 'Order Quantity' fields of the Sales Order and Goods Receipt windows
Set as Active the 'Product - UOM' and 'Unit Of Measure - Conversion' tabs
As group admin role:
Enable the Stock Reservation preference
Create a new product and add a sales price to it
Add a Unit Of Measure to it in the UOM tab
Define a conversion between that UOM and the Unit of the Product tab
Create a goods receipt, add the already created product in the line and set the Order UOM and Order Quantity fields. Storage bin Rn-0-0-0
Complete it
Create another goods receipt, add the already created product in the line and set the Order UOM and Order Quantity fields. Make sure the storage bin selected is a different one. RN-1-0-0.
Create a Sales Order, add the already created product in the line and set the Order UOM and Order Quantity fields
Complete it
Click on the Manage Reservation button and check that only one line is shown in there, regardless there is available stock in two different storage bins.
Create a similar Sales Order but set the Stock Reservation = Automatic in the line
Complete it and check the stock has been reserved, 10 units from RN-0-0-0 and 10 units from Rn-1-0-0 |
| Proposed Solution | Reservations feature current design is not supposed to support reservations for item having a second UOM, therefore no reservation should be created. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | feature request | 0032090 | | new | Triage Omni WMS | Stock Reservations feature should support second UOM | | related to | design defect | 0028051 | 3.0PR15Q2 | closed | umartirena | Reserved quantity is not correct under certain circumstancies | | depends on | defect | 0032078 | 3.0PR16Q2 | closed | aferraz | Reserved quantity is not correct under certain circumstances |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2016-02-02 13:27 | ngarcia | New Issue | |
| 2016-02-02 13:27 | ngarcia | Assigned To | => Triage Finance |
| 2016-02-02 13:27 | ngarcia | Modules | => Core |
| 2016-02-02 13:27 | ngarcia | Resolution time | => 1457305200 |
| 2016-02-02 13:27 | ngarcia | Triggers an Emergency Pack | => No |
| 2016-02-02 13:27 | ngarcia | Issue Monitored: networkb | |
| 2016-02-02 13:31 | ngarcia | Relationship added | related to 0032090 |
| 2016-02-04 14:15 | aferraz | Status | new => scheduled |
| 2016-02-04 14:15 | aferraz | Assigned To | Triage Finance => aferraz |
| 2016-02-05 11:40 | aferraz | Note Added: 0083960 | |
| 2016-02-05 11:40 | aferraz | Relationship added | related to 0032078 |
| 2016-02-05 11:41 | aferraz | Relationship added | related to 0028051 |
| 2016-02-05 11:43 | aferraz | Note Edited: 0083960 | bug_revision_view_page.php?bugnote_id=0083960#r10960 |
| 2016-02-05 11:44 | aferraz | Note Added: 0083961 | |
| 2016-02-05 13:20 | aferraz | Relationship deleted | related to 0032078 |
| 2016-02-05 13:20 | aferraz | Relationship added | depends on 0032078 |
| 2016-02-05 15:03 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=10975#r10975 |
| 2016-02-05 15:05 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=10976#r10976 |
| 2016-02-05 15:09 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=10977#r10977 |
| 2016-02-05 15:09 | psanjuan | Proposed Solution updated | |
| 2016-02-05 15:11 | psanjuan | Note Added: 0083987 | |
| 2016-02-08 12:53 | psanjuan | Note Edited: 0083960 | bug_revision_view_page.php?bugnote_id=0083960#r10978 |
| 2016-02-08 13:01 | psanjuan | Note Edited: 0083960 | bug_revision_view_page.php?bugnote_id=0083960#r10979 |
| 2016-02-08 13:04 | psanjuan | Note Edited: 0083987 | bug_revision_view_page.php?bugnote_id=0083987#r10981 |
| 2016-02-08 13:07 | psanjuan | Note Edited: 0083961 | bug_revision_view_page.php?bugnote_id=0083961#r10983 |
| 2016-02-08 13:08 | psanjuan | Note Added: 0084001 | |
| 2016-02-10 17:25 | hgbot | Checkin | |
| 2016-02-10 17:25 | hgbot | Note Added: 0084089 | |
| 2016-02-10 17:25 | hgbot | Status | scheduled => resolved |
| 2016-02-10 17:25 | hgbot | Resolution | open => fixed |
| 2016-02-10 17:25 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9780a522268784f86d28accf478a6774dad6af3a [^] |
| 2016-02-10 17:25 | vmromanos | Review Assigned To | => vmromanos |
| 2016-02-10 17:25 | vmromanos | Note Added: 0084090 | |
| 2016-02-10 17:25 | vmromanos | Status | resolved => closed |
| 2016-03-17 10:56 | hudsonbot | Checkin | |
| 2016-03-17 10:56 | hudsonbot | Note Added: 0085127 | |
| 2018-07-19 11:55 | AtulOpenbravo | Note Edited: 0083960 | bug_revision_view_page.php?bugnote_id=0083960#r17435 |
| 2018-07-19 11:56 | AtulOpenbravo | Note Edited: 0083961 | bug_revision_view_page.php?bugnote_id=0083961#r17436 |
|
Notes |
|
|
(0083960)
|
|
aferraz
|
2016-02-05 11:40
(edited on: 2018-07-19 11:55) |
|
Test plan I:
As system admin role:
Set as displayed the 'Order UOM' and 'Order Quantity' fields of the Sales Order and Goods Receipt windows
Set as Active the 'Product - UOM' and 'Unit Of Measure - Conversion' tabs
As group admin role:
Enable the Stock Reservation preference
Create a new product and add a sales price to it
Add a Unit Of Measure to it in the UOM tab
Define a conversion between that UOM and the Unit of the Product tab
Create a goods receipt, add the already created product in the line and set the Order UOM and Order Quantity fields
Complete it
Create a Sales Order, add the already created product in the line and set the Order UOM and Order Quantity fields
Complete it
Check that Reservation Status column shows "Not Reserved".
Click on the Manage Reservation button and check no lines are shown.
Click Done.
Check in Stock Reservation, no record is created for Sales Order created above.
Create a similar Sales Order but set the Stock Reservation = Automatic in the line.
Click on the Manage Reservation button and check no lines are shown.
Click Done.
Complete it and check that a Stock Reservation has been created, with sales order line quantity, reserved qty = 0 in draft status. Once more this stock reservation has no lines.
|
|
|
|
(0083961)
|
|
aferraz
|
2016-02-05 11:44
(edited on: 2018-07-19 11:56) |
|
Test plan II:
As group admin role:
Enable the Stock Reservation preference
Create a new product and add a sales price to it
Create a Sales Order, add the already created product in the line and set any quantity.
Complete it
Click on the Manage Reservation button and check no lines are shown.
Click Done.
Check Stock Reservation and realize that no record is created for previous processed order.
Create a similar Sales Order but set the Stock Reservation = Automatic in the line
Complete it and realize a Stock Reservation has been created with sales order line quantity and draft status but with no lines, because there is no stock.
|
|
|
|
(0083987)
|
|
psanjuan
|
2016-02-05 15:11
(edited on: 2016-02-08 13:04) |
|
|
|
|
|
Test plan above verified.
Issue can be code reviewed and close. |
|
|
|
(0084089)
|
|
hgbot
|
|
2016-02-10 17:25
|
|
Repository: erp/devel/pi
Changeset: 9780a522268784f86d28accf478a6774dad6af3a
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Feb 05 12:02:24 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9780a522268784f86d28accf478a6774dad6af3a [^]
Fixes issue 32089: Reservations with stock in second UOM will not be created
M_RESERVE_STOCK_AUTO will exclude lines from m_storage_detail with second uom to avoid create stock reservation lines for products with stock in second UOM, as it is done in M_CREATE_RESERVE_FROM_SOL.
---
M src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
---
|
|
|
|
|
|
|
|
|
|