details: https://code.openbravo.com/erp/devel/pi/rev/2873be0d1b66
changeset: 32615:2873be0d1b66
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Mon Sep 04 14:03:39 2017 +0530
summary: Fixes issue 36757: Negative Stock Correction for remaining stock
valuation
not done in closing inventory lines (when validating a costing rule)
Add order by clause to sort movement qty desc, material transaction id
diffstat:
src/org/openbravo/costing/CostingRuleProcess.java | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diffs (12 lines):
diff -r f6988eb821e2 -r 2873be0d1b66
src/org/openbravo/costing/CostingRuleProcess.java
--- a/src/org/openbravo/costing/CostingRuleProcess.java Mon Sep 04 11:38:56
2017 +0530
+++ b/src/org/openbravo/costing/CostingRuleProcess.java Mon Sep 04 14:03:39
2017 +0530
@@ -709,6 +709,8 @@
where.append(MaterialTransaction.PROPERTY_PHYSICALINVENTORYLINE + "."
+ InventoryCountLine.PROPERTY_PHYSINVENTORY + "." +
InventoryCount.PROPERTY_ID
+ " = :inventory");
+ where.append(" order by " + MaterialTransaction.PROPERTY_MOVEMENTQUANTITY
+ " desc");
+ where.append(" , " + MaterialTransaction.PROPERTY_ID);
OBQuery<MaterialTransaction> trxQry = OBDal.getInstance().createQuery(
MaterialTransaction.class, where.toString());
trxQry.setNamedParameter("inventory", inventory.getId());
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
