Fixes Issue 12197: Pending Goods Receipts window doesn't order properly.
authorHarikrishnan Raja <harikrishnan.raja@openbravo.com>
Mon, 22 Feb 2010 12:02:37 +0530
changeset 6502 ac78d8c03d14
parent 6501 c2f5064a60dc
child 6503 46957ab44fec
Fixes Issue 12197: Pending Goods Receipts window doesn't order properly.
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql	Fri Feb 19 17:35:58 2010 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql	Mon Feb 22 12:02:37 2010 +0530
@@ -65,7 +65,7 @@
       C_BPARTNER.NAME, C_ORDERLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE.DESCRIPTION, C_ORDERLINE.QTYORDERED
       ORDER BY PARTNER_NAME, DOCUMENTNO, DATEORDERED) A
       WHERE QTYORDERED <>0
-      ORDER BY C_BPARTNER_ID, ID
+      ORDER BY C_BPARTNER_ID
       ]]></Sql>
 	<Field name="rownum" value="count"/>
     <Parameter name="dateFormat"/>