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

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 [^]

Issue History
Date Modified	Username	Field	Change

Relationships [ Relation Graph ] [ Dependency Graph ]