Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000173 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2008-04-29 17:18 | 2009-03-18 11:01 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | psarobe | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000173: QA-CLEANUP Copy invoice does not work | |||||||
| Description | The button copy lines does not work 17:11:09 [http-8880-1] ERROR org.openbravo.erpCommon.ad_actionButton.CopyFromInvoiceData - SQL error in query: INSERT INTO C_INVOICELINE (C_InvoiceLine_ID, C_Invoice_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDERLINE_ID, M_INOUTLINE_ID, LINE, DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, A_ASSET_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, PRICESTD) SELECT TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), 'Y', now(), TO_NUMBER(?), now(), TO_NUMBER(?),'', '', (SELECT COALESCE(MAX(LINE),0)+10 FROM C_InvoiceLine WHERE C_InvoiceLine_ID = to_number(?)), DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, A_ASSET_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, PRICESTD FROM C_INVOICELINE WHERE C_INVOICELINE_ID = to_number(?) Exception:java.sql.SQLException: ORA-00904: "A_ASSET_ID": identificador no válido 17:11:09 [http-8880-1] WARN org.openbravo.erpCommon.ad_actionButton.CopyFromInvoice - Rollback in transaction 17:11:15 [http-8880-1] ERROR org.openbravo.erpCommon.utility.TableSQLData - Parsing failed on orderby clause: C_InvoiceLine.M_Product_Uom_Id ASC, C_InvoiceLine.QuantityOrder ASC, C_InvoiceLine.Line ASC - pos: 34 | |||||||
| Steps To Reproduce | 1. Go to Sales management->Transaction->Sales invoice 2. Click new and save 3. Click button Copy lines 4. Select one invoice and press OK No message shows up but in the log you can see the error | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-04-29 17:18 | psarobe | New Issue | |
| 2008-04-29 17:18 | psarobe | Assigned To | => psarobe |
| 2008-04-29 17:19 | psarobe | Status | new => @40@ |
| 2008-04-29 17:20 | psarobe | Status | @40@ => scheduled |
| 2008-04-29 17:20 | psarobe | Status | scheduled => resolved |
| 2008-04-29 17:20 | psarobe | Fixed in Version | => 2.40 |
| 2008-04-29 17:20 | psarobe | Resolution | open => fixed |
| 2008-04-29 17:21 | psarobe | Status | resolved => closed |
| 2008-04-29 17:21 | psarobe | Note Added: 0000038 | |
| 2009-03-18 11:01 | anonymous | sf_bug_id | 0 => 2691221 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |