Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028459 | Openbravo ERP | 04. Warehouse management | public | 2014-12-19 12:49 | 2016-05-11 17:22 |
|
| Reporter | VictorVillar | |
| Assigned To | eduardo_Argal | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | invalid | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028459: It is necessary a modulescript to solve stock inconsistencies |
| Description | It is necessary a modulescript to solve stock inconsistencies |
| Steps To Reproduce | It is necessary a modulescript to solve stock inconsistencies |
| Proposed Solution | We are using the attached script. But is necessary to update it for quotations and for the new columns added in the m_storage_detail table in PR14Q4.
It would be nice to have a preference to either execute it or not. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0024620 | 3.0MP28 | closed | pramakrishnan | Sales quotation is modifying qty reserved in m_storage_pending table and it shouldn't | | related to | defect | 0028618 | | closed | Sandrahuguet | It is possible to reserve more qty than the qty of the order | | related to | defect | 0029571 | | closed | jorge-garcia | In Physical Inventory Lines, Book Quantity is not updated to 0 by Update Quantity process if product has a mandatory attribute | | related to | defect | 0030463 | | closed | AtulOpenbravo | Move a Storage Bin process of Goods Movement window allows to choose any locator without taking into account the organization | | blocks | defect | 0032934 | | closed | markmm82 | Wrong definition of convertUOM function in RestoreStockValue_data.xsql | | blocks | defect | 0032951 | | closed | alostale | Fix Stock process rounds the quantities to 6 decimals and it should not |
|
| Attached Files |  M_RECALCULATE_STOCK_postgres.txt (10,769) 2014-12-19 12:50
https://issues.openbravo.com/file_download.php?file_id=7623&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-12-19 12:49 | VictorVillar | New Issue | |
| 2014-12-19 12:49 | VictorVillar | Assigned To | => dmiguelez |
| 2014-12-19 12:49 | VictorVillar | Modules | => Core |
| 2014-12-19 12:49 | VictorVillar | Resolution time | => 1419721200 |
| 2014-12-19 12:49 | VictorVillar | Triggers an Emergency Pack | => No |
| 2014-12-19 12:50 | VictorVillar | File Added: M_RECALCULATE_STOCK_postgres.txt | |
| 2014-12-19 12:56 | VictorVillar | Proposed Solution updated | |
| 2014-12-19 12:56 | VictorVillar | Assigned To | dmiguelez => AtulOpenbravo |
| 2014-12-19 12:56 | VictorVillar | Issue Monitored: networkb | |
| 2014-12-19 12:57 | VictorVillar | Relationship added | related to 0024620 |
| 2014-12-19 14:59 | ngarcia | Issue Monitored: ngarcia | |
| 2015-01-15 12:46 | VictorVillar | Relationship added | related to 0028618 |
| 2015-01-21 16:35 | Sandrahuguet | Note Added: 0073691 | |
| 2015-01-21 16:35 | Sandrahuguet | Assigned To | AtulOpenbravo => VictorVillar |
| 2015-01-21 16:35 | Sandrahuguet | Status | new => feedback |
| 2015-01-26 17:07 | VictorVillar | Assigned To | VictorVillar => Sandrahuguet |
| 2015-01-26 17:08 | VictorVillar | Status | feedback => new |
| 2015-02-17 16:24 | Sandrahuguet | Note Added: 0074561 | |
| 2015-02-17 16:24 | Sandrahuguet | Status | new => feedback |
| 2015-02-17 16:24 | Sandrahuguet | Note Edited: 0074561 | bug_revision_view_page.php?bugnote_id=0074561#r7696 |
| 2015-02-17 19:05 | VictorVillar | Note Added: 0074570 | |
| 2015-02-17 19:06 | VictorVillar | Status | feedback => new |
| 2015-04-07 18:44 | VictorVillar | Note Added: 0076374 | |
| 2015-04-14 12:48 | Triage Finance | Assigned To | Sandrahuguet => Triage Finance |
| 2015-04-23 13:04 | eduardo_Argal | Note Added: 0076719 | |
| 2015-04-23 13:04 | eduardo_Argal | Status | new => closed |
| 2015-04-23 13:04 | eduardo_Argal | Resolution | open => invalid |
| 2015-04-23 13:16 | eduardo_Argal | Assigned To | Triage Finance => eduardo_Argal |
| 2015-04-23 13:16 | eduardo_Argal | Note Edited: 0076719 | bug_revision_view_page.php?bugnote_id=0076719#r8340 |
| 2015-07-02 11:51 | ngarcia | Relationship added | related to 0029571 |
| 2015-08-03 14:42 | ngarcia | Relationship added | related to 0030463 |
| 2016-05-11 17:22 | ngarcia | Summary | It is necessary a module script to solve stock inconsistencies => It is necessary a modulescript to solve stock inconsistencies |
| 2016-05-11 17:22 | ngarcia | Description Updated | bug_revision_view_page.php?rev_id=12054#r12054 |
| 2016-05-11 17:22 | ngarcia | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=12056#r12056 |
| 2016-05-11 17:32 | ngarcia | Relationship added | blocks 0032934 |
| 2016-05-13 11:22 | ngarcia | Relationship added | blocks 0032951 |
|
Notes |
|
|
|
In feedback, steps to reproduce are necessary
|
|
|
|
|
an environment for testing the process is necessary
|
|
|
|
|
|
No, it is not necessary a real environment with a wrong data for testing because it is possible to test in a good one. Note: if you have consistent data, you launch the script, and you have the same data, it means that the script is fine. |
|
|
|
|
|
|
|
(0076719)
|
|
eduardo_Argal
|
2015-04-23 13:04
(edited on: 2015-04-23 13:16) |
|
There is no issue related. This is a tool to restore something but we need to understand how it was broken. Please log another issue with the details on how you get wrong data in stock. We will first address the issue and plan how to restore data if required.
Script has no need to be updated for quotations, anyway, it should not be used as information related to reservations is not being updated.
|
|