details: https://code.openbravo.com/erp/devel/pi/rev/435936653f60
changeset: 17631:435936653f60
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Aug 08 14:05:56 2012 +0200
summary: issue 21258: If there are more quantity received than the quantity
ordered
diffstat:
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 618f0b1eb7e8 -r 435936653f60
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Wed Aug 08 13:37:30 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Wed Aug 08 14:05:56 2012 +0200
@@ -66,7 +66,7 @@
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
- WHERE (CASE wHEN TOTAL_QTY < 0 THEN (QTYORDERED < 0) ELSE (QTYORDERED >
0) END)
+ WHERE QTYORDERED <>0
ORDER BY C_BPARTNER_ID, DOCUMENTNO, LINE
]]></Sql>
<Field name="rownum" value="count"/>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
