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 25641 f15df074a510
parent 25640 4358cc01e873
child 25642 5f2410ceb9ad
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:54:02 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"/>