details: https://code.openbravo.com/erp/devel/pi/rev/4ed38c38dea2
changeset: 23946:4ed38c38dea2
user: Daniel Ruiz <daniel.ruiz <at> openbravo.com>
date: Tue Jul 01 12:49:36 2014 +0200
summary: Fixes issue 26666: wrong cost when more than one P+ and 0 quantity
on WE
diffstat:
src-db/database/model/functions/MA_PRODUCTION_COST.xml | 1 +
src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql | 3 ++-
2 files changed, 3 insertions(+), 1 deletions(-)
diffs (31 lines):
diff -r cf5b06483c08 -r 4ed38c38dea2
src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml Tue Jul 01
12:11:52 2014 +0200
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml Tue Jul 01
12:49:36 2014 +0200
@@ -161,6 +161,7 @@
AND
pl2.M_productionplan_ID = pp.M_ProductionPlan_ID
AND pl1.calculated = 'N')
AND pp.MA_COSTCENTER_VERSION_ID IS NOT NULL
+ AND pl.movementqty <> 0
GROUP BY pp.M_ProductionPlan_ID,
pp.ma_costcenter_version_id, ccv.costuom,
ccv.COST, pp.MA_CostCenterUse,
pp.MA_WRPHASE_ID, pp.LINE) LOOP
v_ResultStr := 'Common variables';
diff -r cf5b06483c08 -r 4ed38c38dea2
src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql Tue Jul
01 12:11:52 2014 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLineProduction_data.xsql Tue Jul
01 12:49:36 2014 +0200
@@ -12,7 +12,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) 2008-2010 Openbravo SLU
+ * All portions are Copyright (C) 2008-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -32,6 +32,7 @@
FROM M_PRODUCTIONLINE PL, M_PRODUCTIONPLAN PP, M_LOCATOR L,
M_WAREHOUSE W
WHERE PL.M_PRODUCTIONPLAN_ID = PP.M_PRODUCTIONPLAN_ID
AND PL.M_LOCATOR_ID = L.M_LOCATOR_ID
+ AND PL.MOVEMENTQTY <> 0
AND L.M_WAREHOUSE_ID= W.M_WAREHOUSE_ID
AND PP.M_PRODUCTION_ID = ?
]]>
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
