Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0025317 | Openbravo ERP | 07. Sales management | public | 2013-12-12 11:11 | 2014-03-11 17:04 |
| Reporter | egoitz | ||||
| Assigned To | jonalegriaesarte | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 3.0PR14Q2 | Fixed in Version | 3.0PR14Q2 | ||
| 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 | 0025317: Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure | ||||
| Description | Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure | ||||
| Steps To Reproduce | Check the trigger: m_transaction_trg2 On the following line if the v_uom_value it does not show the error. RAISE EXCEPTION '%', '@CannotTakeOutReservedStock@' || ' @of@' || ' @Product@: ' || v_product_value || ', @AttributeSetInstance@: ' || COALESCE(v_attr_description, '-') || ', @UOM@: ' || v_uom_value || ' @And@'||' @StorageBin@: ' || COALESCE(v_locator_value, '-'); --OBTG:-20000-- The symbols is captured as following: SELECT uomsymbol INTO v_uom_value FROM C_Uom WHERE C_Uom_ID = NEW.c_uom_id; It can be null because it is not mandatory on the application. | ||||
| Proposed Solution | Add a coalesce on the raise. Previously when thaking the symbol take also the name and use the name when the symbol is null. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-12-12 11:11 | egoitz | New Issue | |||
| 2013-12-12 11:11 | egoitz | Assigned To | => dmiguelez | ||
| 2013-12-12 11:11 | egoitz | Modules | => Core | ||
| 2013-12-12 11:11 | egoitz | Resolution time | => 1389913200 | ||
| 2013-12-12 11:11 | egoitz | Triggers an Emergency Pack | => No | ||
| 2014-01-02 12:18 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte | ||
| 2014-03-10 18:03 | hgbot | Checkin | |||
| 2014-03-10 18:03 | hgbot | Note Added: 0064995 | |||
| 2014-03-10 18:03 | hgbot | Status | new => resolved | ||
| 2014-03-10 18:03 | hgbot | Resolution | open => fixed | ||
| 2014-03-10 18:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^] | ||
| 2014-03-10 18:05 | egoitz | Review Assigned To | => egoitz | ||
| 2014-03-10 18:05 | egoitz | Status | resolved => closed | ||
| 2014-03-10 18:05 | egoitz | Fixed in Version | => PR14Q2 | ||
| 2014-03-11 17:04 | hudsonbot | Checkin | |||
| 2014-03-11 17:04 | hudsonbot | Note Added: 0065052 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||