Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0024275 | Openbravo ERP | 04. Warehouse management | public | 2013-07-05 14:20 | 2013-09-27 03:11 |
| Reporter | jonalegriaesarte | ||||
| Assigned To | jonalegriaesarte | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | 3.0MP29 | Fixed in Version | 3.0MP28 | ||
| Merge Request Status | |||||
| Review Assigned To | egoitz | ||||
| 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 | 0024275: Some brackets are missing in m_locator_trg, and the sql is not correct | ||||
| Description | Some brackets are missing in m_locator_trg, and the sql is not correct | ||||
| Steps To Reproduce | - m_locator_trg - Some brackets are missing in select count(*) into v_count from m_storage_detail where m_locator_id = old.m_locator_id and COALESCE(qtyonhand,0) <> 0 or COALESCE(qtyorderonhand, 0) <> 0 or COALESCE(preqtyonhand, 0) <> 0 or COALESCE(preqtyorderonhand, 0) <> 0 | ||||
| Proposed Solution | Change: select count(*) into v_count from m_storage_detail where m_locator_id = old.m_locator_id and COALESCE(qtyonhand,0) <> 0 or COALESCE(qtyorderonhand, 0) <> 0 or COALESCE(preqtyonhand, 0) <> 0 or COALESCE(preqtyorderonhand, 0) <> 0 by select count(*) into v_count from m_storage_detail where m_locator_id = old.m_locator_id and (COALESCE(qtyonhand,0) <> 0 or COALESCE(qtyorderonhand, 0) <> 0 or COALESCE(preqtyonhand, 0) <> 0 or COALESCE(preqtyorderonhand, 0) <> 0); | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-07-05 14:20 | jonalegriaesarte | New Issue | |||
| 2013-07-05 14:20 | jonalegriaesarte | Assigned To | => jonalegriaesarte | ||
| 2013-07-05 14:20 | jonalegriaesarte | Modules | => Core | ||
| 2013-07-05 14:20 | jonalegriaesarte | Triggers an Emergency Pack | => No | ||
| 2013-08-19 16:47 | jonalegriaesarte | Target Version | 3.0MP27 => 3.0MP28 | ||
| 2013-09-16 13:18 | jonalegriaesarte | Target Version | 3.0MP28 => 3.0MP29 | ||
| 2013-09-26 17:51 | hgbot | Checkin | |||
| 2013-09-26 17:51 | hgbot | Note Added: 0061426 | |||
| 2013-09-26 17:51 | hgbot | Status | new => resolved | ||
| 2013-09-26 17:51 | hgbot | Resolution | open => fixed | ||
| 2013-09-26 17:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3e69b0ee867b68ed20ccbcd3991e9f6512060035 [^] | ||
| 2013-09-26 17:52 | jonalegriaesarte | Review Assigned To | => egoitz | ||
| 2013-09-26 17:57 | egoitz | Status | resolved => closed | ||
| 2013-09-26 17:57 | egoitz | Fixed in Version | => 3.0MP28 | ||
| 2013-09-27 03:11 | hudsonbot | Checkin | |||
| 2013-09-27 03:11 | hudsonbot | Note Added: 0061436 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||