Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
View Issue Details | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
0005060 | Openbravo ERP | 03. Procurement management | public | 2008-09-16 11:34 | 2008-12-09 11:21 | |||||||
Reporter | villind | |||||||||||
Assigned To | shuehner | |||||||||||
Priority | normal | Severity | major | Reproducibility | always | |||||||
Status | closed | Resolution | fixed | |||||||||
Platform | OS | 30 | OS Version | Redhat | ||||||||
Product Version | 2.40 | |||||||||||
Target Version | Fixed in Version | |||||||||||
Merge Request Status | ||||||||||||
Review Assigned To | ||||||||||||
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 | 0005060: Purchase invoice - Copy lines does not work | |||||||||||
Description | SQL Error occurs when trying to copy lines from previous invoice: Log: 16:16:09 [http-8080-Processor22] 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, 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, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, PRICESTD FROM C_INVOICELINE WHERE C_INVOICELINE_ID = to_number(?) Exception:org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: "" 16:16:09 [http-8080-Processor22] WARN org.openbravo.erpCommon.ad_actionButton.CopyFromInvoice - Rollback in transaction | |||||||||||
Steps To Reproduce | ||||||||||||
Proposed Solution | ||||||||||||
Additional Information | ||||||||||||
Tags | 2.40 MP1 candidate | |||||||||||
Relationships |
| |||||||||||
Attached Files | ||||||||||||
Issue History | ||||||||||||
Date Modified | Username | Field | Change | |||||||||
2008-09-16 11:34 | cromero | New Issue | ||||||||||
2008-09-16 11:34 | cromero | Assigned To | => shuehner | |||||||||
2008-09-16 11:34 | cromero | Status | new => scheduled | |||||||||
2008-09-18 10:32 | svnbot | Checkin | ||||||||||
2008-09-18 10:32 | svnbot | Note Added: 0009065 | ||||||||||
2008-09-18 10:32 | svnbot | Status | scheduled => resolved | |||||||||
2008-09-18 10:32 | svnbot | Resolution | open => fixed | |||||||||
2008-09-18 10:32 | svnbot | svn_revision | => 7441 | |||||||||
2008-09-29 18:39 | cromero | Tag Attached: 2.40 MP1 candidate | ||||||||||
2008-12-09 11:21 | krishna | Regression testing | => No | |||||||||
2008-12-09 11:21 | krishna | Status | resolved => closed |
Notes | |||||
|
|||||
|
|