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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038959
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2018-06-21 10:112018-07-19 10:47
ReportergorkaionView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR18Q2.2
StatusclosedFix in branchFixed in SCM revisione2cc115e5456
ProjectionnoneETAnoneTarget Version3.0PR18Q2.2
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

0038959: 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
(0105792)
hgbot (developer)
2018-07-19 10:46

Repository: erp/backports/3.0PR18Q2.2
Changeset: e2cc115e54565e26aeb9b6c91d521ab50d332c5f
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.0PR18Q2.2/rev/e2cc115e54565e26aeb9b6c91d521ab50d332c5f [^]

Fixes Issue 38959: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
---
(0105793)
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.0PR18Q2.2
2018-07-19 10:46 hgbot Checkin
2018-07-19 10:46 hgbot Note Added: 0105792
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.0PR18Q2.2/rev/e2cc115e54565e26aeb9b6c91d521ab50d332c5f [^]
2018-07-19 10:47 dmiguelez Review Assigned To => dmiguelez
2018-07-19 10:47 dmiguelez Note Added: 0105793
2018-07-19 10:47 dmiguelez Status resolved => closed
2018-07-19 10:47 dmiguelez Fixed in Version => 3.0PR18Q2.2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker