Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026293 | Openbravo ERP | 07. Sales management | public | 2014-04-16 01:19 | 2014-07-01 04:30 |
| Reporter | VictorVillar | ||||
| Assigned To | AtulOpenbravo | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | 3.0PR14Q3 | Fixed in Version | 3.0PR14Q3 | ||
| Merge Request Status | |||||
| Review Assigned To | daniOpenbravo | ||||
| 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 | 0026293: Unable to add exploded BOM to invoice from order when order has multiple shipments | ||||
| Description | The error is occurring because the when the order is shipped on multiple shipments, the invoice gets a line added for each shipment. The query to insert the invoice line bom componetns is doing a sub select to find the bom parent in the invoice. Because it has been added twice (due to 2 shipments) the sub select returns 2 values and insert fails. | ||||
| Steps To Reproduce | 1) Create a BOM product with 2 components and mark product as not stocked (so that it is exploded) 2) Create a sales order for 2 units of the BOM product (will end up with 3 lines on the order for 2 units each) 3) Create a shipment for one unit of the BOM from the order 4) Create a shipment for second unit of the BOM from the order 5) Create an invoice and try to create lines from the original sales order You will get the following error: Exception:org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-04-16 01:19 | VictorVillar | New Issue | |||
| 2014-04-16 01:19 | VictorVillar | Assigned To | => dmiguelez | ||
| 2014-04-16 01:19 | VictorVillar | Modules | => Core | ||
| 2014-04-16 01:19 | VictorVillar | Resolution time | => 1403733600 | ||
| 2014-04-16 01:19 | VictorVillar | Triggers an Emergency Pack | => No | ||
| 2014-04-16 01:20 | VictorVillar | Assigned To | dmiguelez => jonalegriaesarte | ||
| 2014-04-16 01:20 | VictorVillar | Issue Monitored: networkb | |||
| 2014-04-16 01:46 | eintelau | Issue Monitored: eintelau | |||
| 2014-04-28 16:57 | jonalegriaesarte | Assigned To | jonalegriaesarte => pramakrishnan | ||
| 2014-06-28 13:35 | AtulOpenbravo | Assigned To | pramakrishnan => AtulOpenbravo | ||
| 2014-06-28 13:35 | AtulOpenbravo | Status | new => scheduled | ||
| 2014-06-28 13:35 | AtulOpenbravo | fix_in_branch | => pi | ||
| 2014-06-30 16:12 | hgbot | Checkin | |||
| 2014-06-30 16:12 | hgbot | Note Added: 0068448 | |||
| 2014-06-30 16:12 | hgbot | Status | scheduled => resolved | ||
| 2014-06-30 16:12 | hgbot | Resolution | open => fixed | ||
| 2014-06-30 16:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/fe6da6cee966c36a5e2a7a05146a7e54242dfb12 [^] | ||
| 2014-06-30 16:32 | daniOpenbravo | Review Assigned To | => daniOpenbravo | ||
| 2014-06-30 16:32 | daniOpenbravo | Note Added: 0068449 | |||
| 2014-06-30 16:32 | daniOpenbravo | Status | resolved => closed | ||
| 2014-06-30 16:32 | daniOpenbravo | Fixed in Version | => PR14Q3 | ||
| 2014-07-01 04:30 | hudsonbot | Checkin | |||
| 2014-07-01 04:30 | hudsonbot | Note Added: 0068468 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||