details: https://code.openbravo.com/erp/devel/main/rev/ab32911f0963
changeset: 19013:ab32911f0963
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Fri Dec 14 09:58:45 2012 +0100
summary: Fixes Issue 22577. Does not exclude Orders with related Goods Receipt
in Draft Status.
diffstat:
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
diffs (20 lines):
diff -r efb5378d6fb6 -r ab32911f0963
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Thu Dec 13 12:00:22 2012 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Fri Dec 14 09:58:45 2012 +0100
@@ -63,7 +63,7 @@
SELECT C_ORDERLINE.C_ORDERLINE_ID AS ID, C_ORDER.C_ORDER_ID AS
C_ORDER_ID, C_ORDER.DOCUMENTNO AS DOCUMENTNO, C_ORDER.DATEORDERED AS
DATEORDERED,
C_BPARTNER.C_BPARTNER_ID AS C_BPARTNER_ID, C_BPARTNER.NAME AS
PARTNER_NAME,
AD_COLUMN_IDENTIFIER(TO_CHAR('M_Product'),
TO_CHAR(C_ORDERLINE.M_PRODUCT_ID), TO_CHAR(?)) AS PRODUCT_NAME,
M_ATTRIBUTESETINSTANCE.DESCRIPTION AS DESCRIPTION, C_ORDERLINE.QTYORDERED AS
TOTAL_QTY,
- C_ORDERLINE.QTYORDERED-SUM(COALESCE(M_MATCHPO.QTY,0)) AS QTYORDERED,
'-1' AS ISACTIVE, C_ORDERLINE.LINE
+ C_ORDERLINE.QTYORDERED-SUM((CASE WHEN (COALESCE(m_inout.docstatus, 'DR')
= 'DR') THEN 0 ELSE (COALESCE(M_MATCHPO.QTY,0)) END)) AS QTYORDERED, '-1' AS
ISACTIVE, C_ORDERLINE.LINE
FROM C_ORDERLINE left join M_MATCHPO on C_ORDERLINE.C_ORDERLINE_ID =
M_MATCHPO.C_ORDERLINE_ID
and M_MATCHPO.M_INOUTLINE_ID IS NOT
NULL
left join M_ATTRIBUTESETINSTANCE on
C_ORDERLINE.M_ATTRIBUTESETINSTANCE_ID =
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID
@@ -78,7 +78,6 @@
AND C_ORDER.DOCSTATUS = 'CO'
AND C_ORDER.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
AND C_DOCTYPE.ISRETURN = 'N'
- AND COALESCE(m_inout.docstatus, '--') <> 'DR'
GROUP BY C_ORDERLINE.C_ORDERLINE_ID, C_ORDER.C_ORDER_ID,
C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED, C_BPARTNER.C_BPARTNER_ID,
C_BPARTNER.NAME, C_ORDERLINE.M_PRODUCT_ID,
M_ATTRIBUTESETINSTANCE.DESCRIPTION, C_ORDERLINE.QTYORDERED, C_ORDERLINE.LINE
) A
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
