Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0030278 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 03. Procurement management | minor | always | 2015-06-29 13:37 | 2020-01-03 13:37 | |||||||
| Reporter | gorkaion | View Status | public | |||||||||
| Assigned To | inigo_lerga | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 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 ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0116629) inigo_lerga (reporter) 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# |
|
Notes |
|
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 | 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 | |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |