0030278: Stock Proposed records not deleted on M_InOut_Create

Description

Each 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 Solution

When 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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0027210	3.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

Notes
(0116629) inigo_lerga (viewer) 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#

Issue History
Date Modified	Username	Field	Change
2015-06-29 13:37	gorkaion	New Issue
2015-06-29 13:37	gorkaion	Assigned To	=> Triage Finance
2015-06-29 13:37	gorkaion	OBNetwork customer	=> No
2015-06-29 13:37	gorkaion	Modules	=> Core
2015-06-29 13:37	gorkaion	Triggers an Emergency Pack	=> No
2015-06-29 13:37	gorkaion	Relationship added	related to 0027210
2015-06-29 14:03	shuehner	Relationship added	related to 0030281
2015-06-29 14:03	shuehner	Issue Monitored: shuehner
2015-07-27 14:24	eintelau	Issue Monitored: eintelau
2019-12-04 17:55	ngarcia	OBNetwork customer	No => OBPS
2019-12-04 17:55	ngarcia	Support ticket	=> 13397
2020-01-02 09:55	inigo_lerga	Assigned To	Triage Finance => inigo_lerga
2020-01-02 09:55	inigo_lerga	Status	new => scheduled
2020-01-03 13:37	inigo_lerga	Note Added: 0116629