details: https://code.openbravo.com/erp/devel/pi/rev/3bcb735ce063
changeset: 25745:3bcb735ce063
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Fri Jan 23 12:02:44 2015 +0100
summary: Fixed bug 28456 Return orders does not appear in Create Invoices
From Orders
It has been deleted return= 'N' filter in the query because the filter
it is not necessary.
diffstat:
src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql | 2 --
1 files changed, 0 insertions(+), 2 deletions(-)
diffs (19 lines):
diff -r 8e29e85a3ffd -r 3bcb735ce063
src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql
Thu Jan 22 17:34:24 2015 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql
Fri Jan 23 12:02:44 2015 +0100
@@ -36,7 +36,6 @@
WHERE ic.AD_Org_ID=o.AD_Org_ID
AND ic.C_BPartner_ID=bp.C_BPartner_ID
AND ic.C_DocType_ID=dt.C_DocType_ID
- 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 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')
AND (ic.qtyordered = ic.qtydelivered) )) OR (ic.term = 'S' AND exists (SELECT 1
FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID AND ol.QTYDELIVERED <>
0 AND ol.QTYDELIVERED <> ol.QTYINVOICED)))
@@ -69,7 +68,6 @@
WHERE ic.AD_Org_ID=o.AD_Org_ID
AND ic.C_BPartner_ID=bp.C_BPartner_ID
AND ic.C_DocType_ID=dt.C_DocType_ID
- 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 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')
AND (ic.qtyordered = ic.qtydelivered) )) OR (ic.term = 'S' AND exists (SELECT 1
FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = ord.C_ORDER_ID AND ol.QTYDELIVERED <>
0 AND ol.QTYDELIVERED <> ol.QTYINVOICED)))
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
