details: https://code.openbravo.com/erp/devel/pi/rev/8bed44ca01d9
changeset: 22328:8bed44ca01d9
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Feb 25 12:05:58 2014 +0530
summary: Fixes Issue 25112 Valued stock report does not filter by stocked
products
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diffs (20 lines):
diff -r 8845de885b87 -r 8bed44ca01d9
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
--- a/src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java Mon Mar
03 11:06:05 2014 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java Tue Feb
25 12:05:58 2014 +0530
@@ -11,7 +11,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2012 Openbravo SLU
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -240,6 +240,7 @@
where.append(" where trx." + MaterialTransaction.PROPERTY_MOVEMENTDATE + "
< :maxDate");
where.append(" and trx." + MaterialTransaction.PROPERTY_ISCOSTCALCULATED
+ " = false");
where.append(" and loc." + Locator.PROPERTY_WAREHOUSE + ".id = :wh");
+ where.append(" and p." + Product.PROPERTY_STOCKED + " = true");
if (!"".equals(strCategoryProduct)) {
where.append(" and p." + Product.PROPERTY_PRODUCTCATEGORY + ".id =
:prodCategory");
}
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
