Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005024Openbravo ERP03. Procurement managementpublic2008-09-11 18:182008-12-03 14:20
Reportervillind 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionRedhat
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005024: Purchase invoice - Copy lines does not work
DescriptionSQL 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
TagsNo tags attached.
Relationships
depends on backport 0005060 closed shuehner Purchase invoice - Copy lines does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-11 18:18villindNew Issue
2008-09-11 18:18villindAssigned To => cromero
2008-09-11 18:18villindsf_bug_id0 => 2105943
2008-09-11 18:18villindRegression testing => No
2008-09-16 11:34cromeroStatusnew => scheduled
2008-09-16 11:34cromeroAssigned Tocromero => shuehner
2008-09-16 11:34cromerofix_in_branch => trunk
2008-09-18 10:33svnbotCheckin
2008-09-18 10:33svnbotNote Added: 0009066
2008-09-18 10:33svnbotStatusscheduled => resolved
2008-09-18 10:33svnbotResolutionopen => fixed
2008-09-18 10:33svnbotsvn_revision => 7442
2008-12-03 14:20krishnaStatusresolved => closed

Notes
(0009066)
svnbot   
2008-09-18 10:33   
Repository: openbravo
Revision: 7442
Author: huehner
Date: 2008-09-18 10:33:44 +0200 (Thu, 18 Sep 2008)

Fixed 5024
Remove two non-mandatory fk-fields which where filled with '' from insert statement
in addition remove some TO_NUMBER calls with are unneeded for (now uuid) id-fields

---
U trunk/src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7442&sc=1 [^]