src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
changeset 2585 eec65c012021
parent 2526 3b09206e90cf
child 5068 ff6ccc39f03c
--- a/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -65,8 +65,7 @@
       AND AD_REF_LIST.AD_REFERENCE_ID = '150'
       AND C_ORDER.PROCESSED = 'Y'
       AND C_ORDER.ISSOTRX = 'Y'
-      AND C_ORDERLINE.QTYORDERED<>C_ORDERLINE.QTYINVOICED
-      AND C_BPARTNER.ISACTIVE = 'Y' 
+      AND C_ORDERLINE.QTYORDERED<>C_ORDERLINE.QTYINVOICED 
       AND C_ORDER.AD_Client_ID IN ('1')
       AND C_ORDER.AD_ORG_ID IN ('1')
       AND 1=1
@@ -106,7 +105,6 @@
                  WHERE C2.c_order_id = C.c_order_id
                  and c2.c_order_id=cl.c_order_id
                  and cl.QTYORDERED<>cl.QTYINVOICED)
-      AND C_BPARTNER.ISACTIVE = 'Y' 
       AND C.AD_Client_ID IN ('2')
       AND C.AD_ORG_ID IN ('2')
       AND 2=2