Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005024
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2008-09-11 18:182008-12-03 14:20
ReportervillindView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7442
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6
OS VersionRedhatDatabase version8.3Ant version
Product Version2.40SCM revision7193 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005024: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0005060 closedshuehner Purchase invoice - Copy lines does not work 

-  Notes
(0009066)
svnbot (viewer)
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 [^]

- Issue History
Date Modified Username Field Change
2008-09-11 18:18 villind New Issue
2008-09-11 18:18 villind Assigned To => cromero
2008-09-11 18:18 villind sf_bug_id 0 => 2105943
2008-09-11 18:18 villind OBNetwork customer => No
2008-09-11 18:18 villind Regression testing => No
2008-09-16 11:34 cromero Status new => scheduled
2008-09-16 11:34 cromero Assigned To cromero => shuehner
2008-09-16 11:34 cromero fix_in_branch => trunk
2008-09-18 10:33 svnbot Checkin
2008-09-18 10:33 svnbot Note Added: 0009066
2008-09-18 10:33 svnbot Status scheduled => resolved
2008-09-18 10:33 svnbot Resolution open => fixed
2008-09-18 10:33 svnbot svn_revision => 7442
2008-12-03 14:20 krishna Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker