src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
changeset 5068 ff6ccc39f03c
parent 2585 eec65c012021
child 6701 690d2af86089
--- a/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Tue Sep 22 18:39:13 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Wed Sep 23 11:03:25 2009 +0530
@@ -59,6 +59,7 @@
       WHERE C_ORDER.C_ORDER_ID=C_ORDERLINE.C_ORDER_ID
       AND C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
       AND C_ORDER.INVOICERULE = AD_REF_LIST.VALUE
+      AND C_ORDER.INVOICERULE <> 'N'
       AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
       AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID
       AND C_ORDER.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
@@ -96,6 +97,7 @@
       AND C.C_BPARTNER_ID=C_BPARTNER.C_BPARTNER_ID
       AND C.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
       AND C.INVOICERULE = AD_REF_LIST.VALUE
+      AND C.INVOICERULE <> 'N'
       AND AD_REF_LIST.AD_REFERENCE_ID = '150'
       AND C_ORDERTAX.C_TAX_ID = C_TAX.C_TAX_ID
       AND C.AD_ORG_ID = AD_ORG.AD_ORG_ID