details: https://code.openbravo.com/erp/devel/pi/rev/3f2040469a54 changeset: 15872:3f2040469a54 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Thu Mar 22 11:55:06 2012 +0100 summary: fixes date in copyright
details: https://code.openbravo.com/erp/devel/pi/rev/2461ef609ca4 changeset: 15873:2461ef609ca4 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Thu Mar 22 12:08:08 2012 +0100 summary: Fixes bug 20090: Create invoices from orders is not displaying all not invoiced orders diffstat: src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 2 +- src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) diffs (42 lines): diff -r 5dd0f3afbe2a -r 2461ef609ca4 src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql --- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Thu Mar 22 11:20:46 2012 +0100 +++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Thu Mar 22 12:08:08 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-2010 Openbravo SLU + * All portions are Copyright (C) 2001-2012 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ diff -r 5dd0f3afbe2a -r 2461ef609ca4 src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql --- a/src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql Thu Mar 22 11:20:46 2012 +0100 +++ b/src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql Thu Mar 22 12:08:08 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): ______________________________________. ************************************************************************ @@ -39,7 +39,7 @@ AND dt.isreturn='N' AND l.value = ic.term AND ord.C_ORDER_ID=ic.C_ORDER_ID - AND ((ic.term = 'D' AND ic.qtydelivered <>0) OR (ic.term = 'I' AND (SELECT SUM(ol.QTYORDERED)-SUM(ol.QTYINVOICED) FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID) <> 0) OR (ic.term <> 'N' AND (ic.term IN ('O','S') AND (ic.qtyordered = ic.qtydelivered) )) ) + AND ((ic.term = 'D' AND ic.qtydelivered <>0) OR (ic.term = 'I' AND exists (SELECT 1 FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID AND ol.QTYORDERED-ol.QTYINVOICED <> 0)) OR (ic.term <> 'N' AND (ic.term IN ('O','S') AND (ic.qtyordered = ic.qtydelivered) )) ) AND AD_Reference_ID='150' AND ic.ad_client_id in ('1') AND ic.ad_org_id in ('1') @@ -72,7 +72,7 @@ AND dt.isReturn='N' AND l.value = ic.term AND ord.C_ORDER_ID=ic.C_ORDER_ID - AND ((ic.term = 'D' AND ic.qtydelivered <>0) OR (ic.term = 'I' AND (SELECT SUM(ol.QTYORDERED)-SUM(ol.QTYINVOICED) FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID) <> 0) OR (ic.term <> 'N' AND (ic.term IN ('O','S') AND (ic.qtyordered = ic.qtydelivered) )) ) + AND ((ic.term = 'D' AND ic.qtydelivered <>0) OR (ic.term = 'I' AND exists (SELECT 1 FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID AND ol.QTYORDERED-ol.QTYINVOICED <> 0)) OR (ic.term <> 'N' AND (ic.term IN ('O','S') AND (ic.qtyordered = ic.qtydelivered) )) ) AND AD_Reference_ID='150' AND ic.ad_client_id in ('1') AND ic.ad_org_id in ('1') ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits