details: https://code.openbravo.com/erp/devel/pi/rev/9ca1b1bb1f9b
changeset: 21429:9ca1b1bb1f9b
user: Victor Villar <victor.villar <at> openbravo.com>
date: Fri Nov 08 15:43:58 2013 +0100
summary: Fixed issue 25100:Production cost is not calculated in instances
with the old cost engine
diffstat:
src-db/database/model/functions/MA_PRODUCTION_COST.xml | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diffs (36 lines):
diff -r f46ef9cc4504 -r 9ca1b1bb1f9b
src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml Fri Nov 08
12:46:39 2013 +0100
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml Fri Nov 08
15:43:58 2013 +0100
@@ -198,8 +198,8 @@
AND ppl.PRODUCTIONTYPE = '-'
AND ppl.M_PRODUCTIONPLAN_ID =
Cur_ProductionPlan.M_PRODUCTIONPLAN_ID
AND c.ISPRODUCTION='Y'
- AND c.COSTTYPE = 'AVA'
- AND v_iscostmigrated = 'Y') LOOP
+ AND ((c.COSTTYPE = 'AVA' AND v_iscostmigrated = 'Y')
+ OR (c.COSTTYPE = 'AV' AND v_iscostmigrated =
'N'))) LOOP
v_ProductionCost_Tmp := v_ProductionCost_Tmp +
COALESCE(Cur_WIP.cost,0);
UPDATE M_PRODUCTIONLINE
SET calccost = COALESCE(Cur_WIP.cost, 0)
@@ -217,8 +217,8 @@
AND ppl.PRODUCTIONTYPE = '-'
AND ppl.M_PRODUCTIONPLAN_ID =
Cur_ProductionPlan.M_PRODUCTIONPLAN_ID
AND c.ISPRODUCTION='N'
- AND c.COSTTYPE =
'AVA'
- AND v_iscostmigrated
= 'Y'
+ AND ((c.COSTTYPE =
'AVA' AND v_iscostmigrated = 'Y')
+ OR (c.COSTTYPE
= 'AV' AND v_iscostmigrated = 'N'))
AND NOT EXISTS (SELECT 1
FROM M_COSTING,
M_PRODUCTIONLINE
WHERE M_COSTING.M_PRODUCT_ID
= M_PRODUCTIONLINE.M_PRODUCT_ID
@@ -227,8 +227,8 @@
AND
M_PRODUCTIONLINE.PRODUCTIONTYPE = '-'
AND
M_PRODUCTIONLINE.M_PRODUCT_ID = c.M_Product_ID
AND
M_COSTING.ISPRODUCTION='Y'
-
AND c.COSTTYPE = 'AVA'
-
AND v_iscostmigrated = 'Y')) LOOP
+ AND ((M_COSTING.COSTTYPE =
'AVA' AND v_iscostmigrated = 'Y')
+ OR (M_COSTING.COSTTYPE
= 'AV' AND v_iscostmigrated = 'N')))) LOOP
v_ProductionCost_Tmp := v_ProductionCost_Tmp +
COALESCE(Cur_RawMaterial.cost,0);
UPDATE M_PRODUCTIONLINE
SET calccost = COALESCE(Cur_RawMaterial.cost, 0)
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
