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