details: https://code.openbravo.com/erp/devel/pi/rev/21ed594bb3ce changeset: 18531:21ed594bb3ce user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Mon Nov 12 09:42:30 2012 +0100 summary: Fixes Issue 21968: Create lines from shows draft invoice in good shipment window
details: https://code.openbravo.com/erp/devel/pi/rev/dd819f51b6ba changeset: 18532:dd819f51b6ba user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Fri Nov 09 14:55:59 2012 +0100 summary: Fixes Issue 21971: Purchase invoice appears in create lines from popup in goods shipment diffstat: src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diffs (32 lines): diff -r 5df4320d0a69 -r dd819f51b6ba src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql --- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql Fri Nov 09 12:48:06 2012 +0100 +++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql Fri Nov 09 14:55:59 2012 +0100 @@ -12,7 +12,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU - * All portions are Copyright (C) 2001-2011 Openbravo SLU + * All portions are Copyright (C) 2001-2012 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ @@ -316,6 +316,7 @@ FROM C_INVOICELINE l left join M_INOUTLINE mi on l.M_INOUTLINE_ID = mi.M_INOUTLINE_ID, C_INVOICE i, C_UOM uom, M_PRODUCT p WHERE i.C_INVOICE_ID = l.C_INVOICE_ID + AND i.DocStatus IN ('CL','CO') AND i.AD_Client_ID IN ('1') AND i.AD_Org_ID IN ('1') AND l.C_UOM_ID=uom.C_UOM_ID @@ -365,8 +366,10 @@ <![CDATA[ SELECT i.C_Invoice_ID AS ID, Ad_Column_Identifier(TO_CHAR('C_Invoice'), TO_CHAR(i.C_Invoice_ID), TO_CHAR(?)) AS NAME FROM C_INVOICE i JOIN C_DOCTYPE dt ON i.c_doctype_id = dt.c_doctype_id AND dt.isreturn='N' - WHERE i.AD_Client_ID IN ('1') + WHERE i.DocStatus IN ('CL','CO') + AND i.AD_Client_ID IN ('1') AND i.AD_Org_ID IN ('1') + AND i.IsSOTrx='Y' AND i.C_BPartner_ID = ? AND EXISTS (SELECT 1 FROM C_INVOICELINE l LEFT JOIN M_INOUTLINE MI ON l.M_INOUTLINE_ID = MI.M_INOUTLINE_ID ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
