details: https://code.openbravo.com/erp/devel/pi/rev/5df88a3c4cd1
changeset: 29355:5df88a3c4cd1
user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date: Mon Apr 25 18:48:59 2016 +0200
summary: Related to issue 32504: Remove cumqty value calculation in production
References to old m_costing cumqty column have been removed from Production
cost calculation and old Cost Engine as it was calculated but never used.
diffstat:
src-db/database/model/functions/MA_PRODUCTION_COST.xml | 14 +++++-----
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 6 ++--
src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml | 6 ++--
3 files changed, 13 insertions(+), 13 deletions(-)
diffs (119 lines):
diff -r daf66237fa61 -r 5df88a3c4cd1
src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml Fri Apr 22
10:01:49 2016 +0200
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml Mon Apr 25
18:48:59 2016 +0200
@@ -22,7 +22,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-2014 Openbravo SLU
+ * All portions are Copyright (C) 2001-2016 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -451,12 +451,12 @@
INSERT INTO M_COSTING (M_COSTING_ID, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, AD_CLIENT_ID,
AD_ORG_ID, M_PRODUCT_ID, DATETO, DATEFROM,
ISMANUAL,
M_PRODUCTIONLINE_ID, QTY,
- PRICE, CUMQTY,
+ PRICE,
COST, ISPERMANENT, ISPRODUCTION, COSTTYPE)
VALUES (v_NextNo,now(), p_User_ID, now(), p_User_ID,
Cur_ProductionLine.AD_CLIENT_ID,
Cur_ProductionLine.AD_ORG_ID,
Cur_ProductionLine.M_PRODUCT_ID, TO_DATE('31-12-9999','DD-MM-YYYY'),
v_CostingDate, 'N',
Cur_ProductionLine.M_PRODUCTIONLINE_ID,
Cur_ProductionLine.MOVEMENTQTY,
- ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
COALESCE(v_Qty,0) + Cur_ProductionLine.MOVEMENTQTY,
+ ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
(CASE (Cur_ProductionLine.MOVEMENTQTY) WHEN 0 THEN
0 ELSE ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4) END), 'N', 'Y', 'AV');
ELSE
v_ResultStr := 'update cost';
@@ -508,13 +508,13 @@
INSERT INTO M_COSTING (M_COSTING_ID, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, AD_CLIENT_ID,
AD_ORG_ID, M_PRODUCT_ID, DATETO, DATEFROM,
ISMANUAL,
M_PRODUCTIONLINE_ID, QTY,
- PRICE, CUMQTY,
+ PRICE,
COST,
ISPERMANENT, ISPRODUCTION, COSTTYPE)
VALUES (v_NextNo,now(), p_User_ID, now(), p_User_ID,
Cur_ProductionLine.AD_CLIENT_ID,
Cur_ProductionLine.AD_ORG_ID,
Cur_ProductionLine.M_PRODUCT_ID, v_DateTo, v_CostingDate, 'N',
Cur_ProductionLine.M_PRODUCTIONLINE_ID,
Cur_ProductionLine.MOVEMENTQTY,
- ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
COALESCE(v_Qty,0) + Cur_ProductionLine.MOVEMENTQTY,
+ ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
(CASE (v_Qty+Cur_ProductionLine.MOVEMENTQTY) WHEN
0 THEN 0 ELSE
ROUND(((v_Qty*v_CostOld)+(v_Cost))/(v_Qty+Cur_ProductionLine.MOVEMENTQTY),4)END),
'N', 'Y', 'AV');
ELSIF (v_count2 = 0) THEN
@@ -538,13 +538,13 @@
INSERT INTO M_COSTING (M_COSTING_ID, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, AD_CLIENT_ID,
AD_ORG_ID, M_PRODUCT_ID, DATETO, DATEFROM,
ISMANUAL,
M_PRODUCTIONLINE_ID, QTY,
- PRICE, CUMQTY,
+ PRICE,
COST,
ISPERMANENT, ISPRODUCTION, COSTTYPE)
VALUES (v_NextNo,now(), p_User_ID, now(), p_User_ID,
Cur_ProductionLine.AD_CLIENT_ID,
Cur_ProductionLine.AD_ORG_ID,
Cur_ProductionLine.M_PRODUCT_ID, v_DateTo, v_CostingDate, 'N',
Cur_ProductionLine.M_PRODUCTIONLINE_ID,
Cur_ProductionLine.MOVEMENTQTY,
- ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
COALESCE(v_Qty,0) + Cur_ProductionLine.MOVEMENTQTY,
+ ROUND(v_Cost/Cur_ProductionLine.MOVEMENTQTY,4),
(CASE (v_Qty+Cur_ProductionLine.MOVEMENTQTY) WHEN
0 THEN 0 ELSE
ROUND(((v_Qty*v_CostOld)+(v_Cost))/(v_Qty+Cur_ProductionLine.MOVEMENTQTY),4)END),
'N', 'Y', 'AV');
diff -r daf66237fa61 -r 5df88a3c4cd1
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
--- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Fri Apr
22 10:01:49 2016 +0200
+++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Mon Apr
25 18:48:59 2016 +0200
@@ -16,7 +16,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-2016 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -560,7 +560,7 @@
M_COSTING_ID, CREATED, CREATEDBY, UPDATED,
UPDATEDBY, AD_CLIENT_ID, AD_ORG_ID, M_PRODUCT_ID,
DATETO, DATEFROM, ISMANUAL, M_INOUTLINE_ID,
- C_INVOICELINE_ID, QTY, PRICE, CUMQTY,
+ C_INVOICELINE_ID, QTY, PRICE,
COST, COSTTYPE, ISPERMANENT
)
VALUES
@@ -568,7 +568,7 @@
Ad_Sequence_Nextno('M_Costing'), now(), v_User, now(),
v_User, Cur_InOutLine.AD_CLIENT_ID, Cur_InOutLine.AD_ORG_ID,
Cur_InOutLine.M_PRODUCT_ID,
COALESCE(v_Date, TO_DATE('31-12-9999', 'DD-MM-YYYY')),
Cur_InOutLine.MOVEMENTDATE, 'N', Cur_InOutLine.M_INOUTLINE_ID,
- NULL, Cur_InOutLine.MOVEMENTQTY, v_PriceNew, COALESCE(v_Qty,
0) + Cur_InOutLine.MOVEMENTQTY + v_CumQty, v_CostNew,
+ NULL, Cur_InOutLine.MOVEMENTQTY, v_PriceNew, v_CostNew,
'AV', 'N'
);
END IF;
diff -r daf66237fa61 -r 5df88a3c4cd1
src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml
--- a/src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml Fri Apr
22 10:01:49 2016 +0200
+++ b/src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml Mon Apr
25 18:48:59 2016 +0200
@@ -22,7 +22,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-2006 Openbravo SLU
+* All portions are Copyright (C) 2001-2016 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -102,7 +102,7 @@
M_COSTING_ID, CREATED, CREATEDBY, UPDATED,
UPDATEDBY, AD_CLIENT_ID, AD_ORG_ID, M_PRODUCT_ID,
DATETO, DATEFROM, ISMANUAL, M_INOUTLINE_ID,
- C_INVOICELINE_ID, QTY, PRICE, CUMQTY,
+ C_INVOICELINE_ID, QTY, PRICE,
COST, COSTTYPE, ISPERMANENT
)
VALUES
@@ -110,7 +110,7 @@
Ad_Sequence_Nextno('M_Costing'), now(), v_User, now(),
v_User, Cur_PriceList.AD_CLIENT_ID, Cur_PriceList.AD_ORG_ID,
Cur_PriceList.M_PRODUCT_ID,
TO_DATE('31-12-9999', 'DD-MM-YYYY'), p_Date, 'N', NULL,
- NULL, 0, Cur_PriceList.COSTSTD, 0,
+ NULL, 0, Cur_PriceList.COSTSTD,
Cur_PriceList.COSTSTD, 'ST', 'N'
)
;
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
