Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030278Openbravo ERP03. Procurement managementpublic2015-06-29 13:372020-01-03 13:37
Reportergorkaion 
Assigned Toinigo_lerga 
PrioritynormalSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket13397
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030278: Stock Proposed records not deleted on M_InOut_Create
DescriptionEach call to m_get_stock generates some records on the M_Stock_Proposed table. These records must be deleted once they are not needed anymore.

The M_InOut_Create procedure uses the m_get_stock procedure but never deletes the m_stock_proposed records.
Steps To Reproduce* Check the current number of stock proposed table.
* Create a sales order of type "POS Order" so the shipment is automatically generated using products that are stocked.
* Check that the stock proposed table has new records.
Proposed SolutionWhen the "Cur_Storage" cursor is closed the related m_stock_proposed records can be deleted.

That cursor is closed in 2 different parts of the procedure around lines 526 and 795
Additional Information
TagsNo tags attached.
Relationships
related to defect 00272103.0PR15Q2 closed AtulOpenbravo Records in m_stock_proposed table should be removed once they are used 
related to defect 0030281 closed Sanjota m_stock_proposed table should be added to log cleanup default configuration 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-29 13:37gorkaionNew Issue
2015-06-29 13:37gorkaionAssigned To => Triage Finance
2015-06-29 13:37gorkaionOBNetwork customer => No
2015-06-29 13:37gorkaionModules => Core
2015-06-29 13:37gorkaionTriggers an Emergency Pack => No
2015-06-29 13:37gorkaionRelationship addedrelated to 0027210
2015-06-29 14:03shuehnerRelationship addedrelated to 0030281
2015-06-29 14:03shuehnerIssue Monitored: shuehner
2015-07-27 14:24eintelauIssue Monitored: eintelau
2019-12-04 17:55ngarciaOBNetwork customerNo => OBPS
2019-12-04 17:55ngarciaSupport ticket => 13397
2020-01-02 09:55inigo_lergaAssigned ToTriage Finance => inigo_lerga
2020-01-02 09:55inigo_lergaStatusnew => scheduled
2020-01-03 13:37inigo_lergaNote Added: 0116629

Notes
(0116629)
inigo_lerga   
2020-01-03 13:37   
Test Plan Mantis:
BBDD:
    - Check the amount of rows in the Database
      inside the table named M_Stock_Proposed
      with the following sentence:
      SELECT COUNT(*) FROM M_Stock_Proposed;
As the F&B International Group Admin role:
    - Enter the Sales Order window.
    - Create a new record with "POS Order"
      in the Transaction Document field.
      Create a new line of Cerveza
      Ale 0.5L with 1 unit in the Ordered
      Quantity field.
    - Save the record and press Book button.
BBDD:
    - Check the amount of rows in the Database
      inside the table named M_Stock_Proposed
      with the following sentence:
      SELECT COUNT(*) FROM M_Stock_Proposed;
    #Apreciate that the number of entries is now
    the same as before with the fix applied.
    Without the fix this number would be increased
    by one#