Fixes bug 28308 LandedCost Accounting should always be created in the same order
authorAlvaro Ferraz <alvaro.ferraz@openbravo.com>
Mon, 01 Dec 2014 16:50:51 +0100
changeset 25494 4ae6c365fd3e
parent 25493 1f26de8763c0
child 25495 51adc29c2514
Fixes bug 28308 LandedCost Accounting should always be created in the same order

In order to help JUnit tests assert landed cost accounting, an orderBy clause has been added when creating Landed Cost Accounting lines, to be created always in the same order
src/org/openbravo/erpCommon/ad_forms/DocLineLandedCost_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocLineLandedCost_data.xsql	Mon Dec 01 16:49:43 2014 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLineLandedCost_data.xsql	Mon Dec 01 16:50:51 2014 +0100
@@ -45,7 +45,7 @@
         AND IOL.M_LOCATOR_ID = L.M_LOCATOR_ID
         AND LCR.ISMATCHADJUSTMENT = 'N'
         AND LCC.M_LANDEDCOST_ID = ?
-        ORDER BY IO.DOCUMENTNO, IO.M_INOUT_ID, IOL.LINE
+        ORDER BY LCC.LINE, IO.DOCUMENTNO, IO.M_INOUT_ID, IOL.LINE
      ]]>
      </Sql>
      <Parameter name="LC_Receiptline_Amt"/>