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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038958
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2018-06-21 10:112018-07-19 10:47
ReportergorkaionView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR18Q3
StatusclosedFix in branchFixed in SCM revision5851f06c26be
ProjectionnoneETAnoneTarget Version3.0PR18Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression levelProduction - Confirmed Stable
Regression date2017-05-23
Regression introduced in release3.0PR17Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/0e29b93a2d41205b1309cd6fde9f86cabbb47e91 [^]
Triggers an Emergency PackNo
Summary

0038958: More quantity reserved than available after booking a reopened sales order with more ordered quantity

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

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0038799 closedAtulOpenbravo More quantity reserved than available after booking a reopened sales order with more ordered quantity 

-  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

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker