Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031833Openbravo ERP04. Warehouse managementpublic2016-01-07 18:152016-01-13 11:19
Reporterngarcia 
Assigned Toaferraz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q2 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031833: Inconsistent data in M_STORAGE_PENDING table if the product is changed from Not Stocked to Stocked having pending orders
DescriptionInconsistent data in M_STORAGE_PENDING table if the product is changed from Not Stocked to Stocked having pending orders
Steps To ReproduceAs group admin role:
   Create a non stocked product
   Add a purchase and a sales price list to it
   Create a purchase and a sales order for that product
   Check no records have been created in the m_storage_pending table
   Set it as Stocked
   Create a goods receipt and goods shipment from the orders
   Check a new entry has been created in the m_storage_pending table with:
      qtyordered - quantity in the sales order but negative
      qtyreserved - quantity in the purchase order but negative
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0025930 closed aferraz It should not be possible to change the product definition 
related to defect 00318353.0PR16Q2 closed aferraz Not possible to change the product definition to Stocked under some circumstancies 
related to defect 0032392 closed markmm82 Wrong value in qtyreserved column of m_storage_pending when creating an order from a sales quotation 
related to defect 0035831 closed collazoandy4 Cannot deactivate a product if it was included in a Return To Vendor Shipment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-07 18:15ngarciaNew Issue
2016-01-07 18:15ngarciaAssigned To => Triage Finance
2016-01-07 18:15ngarciaModules => Core
2016-01-07 18:15ngarciaResolution time => 1455404400
2016-01-07 18:15ngarciaTriggers an Emergency Pack => No
2016-01-07 18:18ngarciaIssue Monitored: networkb
2016-01-07 18:24ngarciaRelationship addedrelated to 0025930
2016-01-08 09:05aferrazAssigned ToTriage Finance => aferraz
2016-01-08 15:03aferrazStatusnew => scheduled
2016-01-11 13:39aferrazRelationship addedrelated to 0031835
2016-01-13 11:19aferrazReview Assigned To => aferraz
2016-01-13 11:19aferrazNote Added: 0083226
2016-01-13 11:19aferrazStatusscheduled => closed
2016-01-13 11:19aferrazResolutionopen => no change required
2016-01-13 11:19aferrazFixed in Version => 3.0PR16Q2
2016-03-03 09:49ngarciaRelationship addedrelated to 0032392
2017-04-25 13:24ngarciaRelationship addedrelated to 0035831

Notes
(0083226)
aferraz   
2016-01-13 11:19   
Issue will not be reproducible once 0031835 is fixed.
Wrong data can be fixed using this module: https://code.openbravo.com/erp/pmods/org.openbravo.module.fixstock [^]