Fixed bug 0004842: An incoming shipment shouldn't appear in the create lines from process executed from an invoice
authorDavid Abragimov <david.abragimov@opensuite.com>
Fri, 19 Sep 2008 14:29:22 +0000
changeset 1686 e5a629fb644c
parent 1685 71c1b26d487b
child 1687 725248a7aa33
Fixed bug 0004842: An incoming shipment shouldn't appear in the create lines from process executed from an invoice
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- 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')