Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0038958 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 07. Sales management | major | always | 2018-06-21 10:11 | 2018-07-19 10:47 | |||
| Reporter | gorkaion | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR18Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 5851f06c26be | ||||
| Projection | none | ETA | none | Target Version | 3.0PR18Q3 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | dmiguelez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | Production - Confirmed Stable | |||||||
| Regression date | 2017-05-23 | |||||||
| Regression introduced in release | 3.0PR17Q3 | |||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/0e29b93a2d41205b1309cd6fde9f86cabbb47e91 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0038958: More quantity reserved than available after booking a reopened sales order with more ordered quantity | |||||||
| Description | In case a reserved sales order is reopened to increase the ordered quantity. When it is booked again the reservation is updated to reserve the new quantity not checking if there is enough available. | |||||||
| Steps To Reproduce | - Ensure the reservations are enabled with "enable stock reservations" preference. - Create a new product and set a sales price. - Create and process a physical inventory to initialize 20 units. - Create a sales order for the product of 10 units and reserve it. - Create a new sales order for the product of 10 units and reserve it. - Check the stock tab in the product screen that there are 20 units available and all of them reserved. - Reactivate and book the second sales order increasing the ordered quantity to 20. - Check again the stock tab, there are 30 units reserved although only 20 are available. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0105791) hgbot (developer) 2018-07-19 10:46 |
Repository: erp/backports/3.0PR18Q3 Changeset: 5851f06c26bee00242d007d67de63aad81790248 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Fri Jul 13 11:57:27 2018 +0530 URL: http://code.openbravo.com/erp/backports/3.0PR18Q3/rev/5851f06c26bee00242d007d67de63aad81790248 [^] Fixes Issue 38958:More quantity reserved than available after booking a reopened sales order with more ordered quantity ** When ordered qty is greater than already reserved quantity then v_pendingtounreserve needs to be considered as ZERO instead of negative value as it exceeds the reserved qty than the available qty. --- M src-db/database/model/functions/C_ORDER_POST1.xml --- |
|
(0105794) dmiguelez (developer) 2018-07-19 10:47 |
Code Review + Testing Ok |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-07-13 14:14 | Sandrahuguet | Type | defect => backport |
| 2018-07-13 14:14 | Sandrahuguet | Target Version | => 3.0PR18Q3 |
| 2018-07-19 10:46 | hgbot | Checkin | |
| 2018-07-19 10:46 | hgbot | Note Added: 0105791 | |
| 2018-07-19 10:46 | hgbot | Status | scheduled => resolved |
| 2018-07-19 10:46 | hgbot | Resolution | open => fixed |
| 2018-07-19 10:46 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/backports/3.0PR18Q3/rev/5851f06c26bee00242d007d67de63aad81790248 [^] |
| 2018-07-19 10:47 | dmiguelez | Review Assigned To | => dmiguelez |
| 2018-07-19 10:47 | dmiguelez | Note Added: 0105794 | |
| 2018-07-19 10:47 | dmiguelez | Status | resolved => closed |
| 2018-07-19 10:47 | dmiguelez | Fixed in Version | => 3.0PR18Q3 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |