0025105: The Production cost should be calculated independently if the Cost center is defined in the Production Run

0025105

Openbravo ERP

05. Production management

public

2013-11-07 17:27

2017-02-15 09:47

Reporter

VictorVillar

Assigned To

Triage Omni OMS

Priority

immediate

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS

5

OS Version

Product Version

pi

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0025105: The Production cost should be calculated independently if the Cost center is defined in the Production Run

Description

The Production cost should be calculated independently if the Cost center is defined in the Production Run

Steps To Reproduce

The Production cost should be calculated independently if the Cost center is defined in the Production Run

Proposed Solution

There is a restriction at the beginning of ma_production_cost function when creates the Cur_ProductionPlan cursor --> "AND pp.MA_COSTCENTER_VERSION_ID IS NOT NULL":

SELECT pp.M_ProductionPlan_ID, pp.ma_costcenter_version_id,
SUM(CASE pl.productiontype WHEN '+' THEN (mp.weight * pl.movementqty)
ELSE 0 END) AS ProducedKG,
SUM(CASE pl.productiontype WHEN '+' THEN (pl.movementqty)
ELSE 0 END) AS ProducedUd,
SUM(CASE pl.productiontype WHEN '+' THEN COALESCE(wrpp.ComponentCost,1) ELSE 0 END) AS CompCostSum,
                                         ccv.costuom, ccv.COST, pp.MA_CostCenterUse, pp.MA_WRPHASE_ID, pp.LINE
                                  FROM M_PRODUCTIONPLAN pp INNER JOIN M_PRODUCTIONLINE pl ON pp.m_productionplan_id = pl.m_productionplan_id
                                                                                         AND pp.m_production_id = p_Production_ID
                                                           INNER JOIN M_PRODUCT mp ON pl.m_product_id = mp.m_product_id
                                                           LEFT JOIN MA_COSTCENTER_VERSION ccv ON ccv.MA_COSTCENTER_VERSION_ID = pp.ma_costcenter_version_id
                                                           LEFT JOIN MA_WRPHASE wrp ON wrp.ma_wrphase_id = pp.ma_wrphase_id
                                                           LEFT JOIN MA_WRPHASEPRODUCT wrpp ON wrp.ma_wrphase_id = wrpp.ma_wrphase_id
                                   AND wrpp.m_product_id = pl.m_product_id
                                  WHERE NOT EXISTS (SELECT 1
                                                   FROM M_PRODUCTIONLINE pl1, M_PRODUCTIONPLAN pp2, M_PRODUCTIONLINE pl2
                                                   WHERE pl1.m_productionplan_id = pp2.m_productionplan_id
                                                     AND pl1.m_product_id = pl2.m_product_id
                                                     AND pl2.productiontype='-'
                                                     AND pl1.productiontype='+'
                                                     AND pp2.m_production_id = p_Production_ID
                                                     AND pl2.M_productionplan_ID = pp.M_ProductionPlan_ID
                                                     AND pl1.calculated = 'N')
   AND pp.MA_COSTCENTER_VERSION_ID IS NOT NULL
                                 GROUP BY pp.M_ProductionPlan_ID, pp.ma_costcenter_version_id, ccv.costuom,
                                           ccv.COST, pp.MA_CostCenterUse, pp.MA_WRPHASE_ID, pp.LINE

Also the lines should NOT be calculated = Y when there is not defined the cost center version:

    UPDATE M_PRODUCTIONLINE
    SET CALCULATED='Y'
    WHERE M_PRODUCTIONPLAN_ID IN (SELECT M_PRODUCTIONPLAN_ID
                                  FROM M_PRODUCTIONPLAN
                                  WHERE M_PRODUCTION_ID = p_Production_ID
                                    AND MA_COSTCENTER_VERSION_ID IS NULL);

Additional Information