Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0023427 | Openbravo ERP | 04. Warehouse management | public | 2013-03-27 23:05 | 2013-04-04 13:03 |
| Reporter | jonalegriaesarte | ||||
| Assigned To | jonalegriaesarte | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 3.0MP22 | Fixed in Version | 3.0MP22 | ||
| Merge Request Status | |||||
| Review Assigned To | egoitz | ||||
| OBNetwork customer | OBPS | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | 20307 | ||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0023427: Error when deactivating a locator | ||||
| Description | Error when deactivating a locator. The trigger is not properly set. | ||||
| Steps To Reproduce | - Deactivate a locator | ||||
| Proposed Solution | Change the trigger M_LOCATOR_TRG: 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'; 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-03-27 23:05 | jonalegriaesarte | New Issue | |||
| 2013-03-27 23:05 | jonalegriaesarte | Assigned To | => jonalegriaesarte | ||
| 2013-03-27 23:05 | jonalegriaesarte | Modules | => Core | ||
| 2013-03-27 23:05 | jonalegriaesarte | OBNetwork customer | => Yes | ||
| 2013-03-27 23:05 | jonalegriaesarte | Support ticket | => 20307 | ||
| 2013-03-27 23:05 | jonalegriaesarte | Triggers an Emergency Pack | => No | ||
| 2013-03-27 23:11 | hgbot | Checkin | |||
| 2013-03-27 23:11 | hgbot | Note Added: 0057516 | |||
| 2013-03-27 23:11 | hgbot | Status | new => resolved | ||
| 2013-03-27 23:11 | hgbot | Resolution | open => fixed | ||
| 2013-03-27 23:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5c1ad90975cfc21ec2418ed1682e492ef118cff7 [^] | ||
| 2013-04-01 18:58 | hudsonbot | Checkin | |||
| 2013-04-01 18:58 | hudsonbot | Note Added: 0057552 | |||
| 2013-04-04 13:03 | egoitz | Review Assigned To | => egoitz | ||
| 2013-04-04 13:03 | egoitz | Status | resolved => closed | ||
| 2013-04-04 13:03 | egoitz | Fixed in Version | => 3.0MP22 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||