Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0001724 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 02. Master data management | minor | always | 2007-08-05 22:29 | 2008-06-12 09:43 | |||
Reporter | user71 | View Status | public | |||||
Assigned To | iperdomo | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
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 | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0001724: RptC_Invoice_Lines sql error when printing invoice | |||||||
Description | When attempting to print an invoice I receive the following error: et.sf.jasperreports.engine.JRException: Error executing SQL statement for : RptC_Invoice_Lines The postgresql.log entry associate with this request is : 2007-08-05 15:14:51 ERROR: column reference "line" is ambiguous at character 1048 2007-08-05 15:14:51 STATEMENT: SELECT C_INVOICE.C_INVOICE_ID, COALESCE(M_PRODUCT.NAME, C_INVOICELINE.DESCRIPTION) AS NAME_PRODUCT, C_INVOICELINE.QTYINVOICED, C_UOM.NAME AS UOMNAME, C_INVOICELINE.DESCRIPTION, C_INVOICELINE.LINENETAMT, C_INVOICELINE.PRICEACTUAL, M_INOUT.DOCUMENTNO AS INOUTNO, C_ORDER.DOCUMENTNO AS ORDERNO FROM C_INVOICELINE left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID left join M_INOUTLINE on M_INOUTLINE.M_INOUTLINE_ID = C_INVOICELINE.M_INOUTLINE_ID left join M_INOUT on M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID left join C_ORDERLINE on C_ORDERLINE.C_ORDERLINE_ID = C_INVOICELINE.C_ORDERLINE_ID left join C_ORDER on C_ORDERLINE.C_ORDER_ID = C_ORDER.C_ORDER_ID, C_INVOICE WHERE C_INVOICELINE.C_INVOICE_ID = C_INVOICE.C_INVOICE_ID AND C_INVOICE.C_INVOICE_ID = $1 ORDER BY LINE My session info is: User: Openbravo Role: Big Bazaar Admin Client: Big Bazaar Org: California Web: ../web DB: null Record range: 20 Search's record range: 500 Source version: 2.33 VerticalSourceVersion: 2.33 Vertical's database version: 2.33 Java VM: Java HotSpot(TM) Server VM Java VM Version: 1.5.0_09-b03 System language: en_US Java TMP's folder: C:\Program Files\apache-tomcat-5.5.23\temp User's folder: C:\Documents and Settings\Default User\TAD.properties O.S.: Windows 2003 5.2 Service Pack 2 | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0001698) iperdomo (reporter) 2007-08-09 12:02 edited on: 2008-06-12 09:20 |
Logged In: YES user_id=1820699 Originator: NO We modified the query by adding the the table of the ordering field: ORDER BY C_INVOICELINE.LINE |
(0005313) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1768021 [^] |
Copyright © 2000 - 2009 MantisBT Group |