src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
changeset 1686 e5a629fb644c
parent 1605 8a0fe0193bef
child 1787 84217f37d788
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql	Fri Sep 19 13:38:14 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql	Fri Sep 19 14:29:22 2008 +0000
@@ -285,6 +285,7 @@
         FROM M_INOUT s 
         WHERE s.IsSOTrx='N' 
         AND s.DocStatus IN ('CL','CO') 
+        AND s.ISLOGISTIC <> 'Y'
         AND s.AD_Client_ID IN ('1') 
         AND s.AD_Org_ID IN ('1') 
         AND s.C_BPartner_ID = ? 
@@ -339,6 +340,7 @@
         SELECT s.M_InOut_ID AS ID, Ad_Column_Identifier(to_char('M_InOut'), to_char(s.M_InOut_ID), to_char(?)) AS NAME 
         FROM M_INOUT s 
         WHERE s.IsSOTrx='Y' 
+        AND s.ISLOGISTIC <> 'Y'
         AND s.DocStatus IN ('CL','CO') 
         AND s.AD_Client_ID IN ('1') 
         AND s.AD_Org_ID IN ('1')