Fixes bug 28387 BillofMaterialsAccounting should always be created in the same order
authorAlvaro Ferraz <alvaro.ferraz@openbravo.com>
Thu, 11 Dec 2014 14:13:06 +0100
changeset 25636 a502f548532a
parent 25635 6d8d7f9748b3
child 25637 7441045bf9fd
Fixes bug 28387 BillofMaterialsAccounting should always be created in the same order

In order to help JUnit tests assert Bill of Materials Production accounting, an orderBy clause has been added when creating Bill of Materials Production Accounting lines, to be created always in the same order
src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql	Thu Dec 18 14:33:34 2014 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql	Thu Dec 11 14:13:06 2014 +0100
@@ -35,6 +35,7 @@
          AND PL.MOVEMENTQTY <> 0
          AND L.M_WAREHOUSE_ID= W.M_WAREHOUSE_ID
          AND PP.M_PRODUCTION_ID = ?
+         ORDER BY PL.LINE, PL.M_PRODUCTIONLINE_ID
      ]]>
      </Sql>
      <Parameter name="mProductionId"/>