[OpenbravoERP-commits] devel/pi: Fixes issue 0026096: Issue in costing engine when havi...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/5fa0d14ad3d4
changeset: 22779:5fa0d14ad3d4
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Thu Mar 27 09:53:31 2014 +0100
summary:   Fixes issue 0026096: Issue in costing engine when having production
p- and the products do not have cost calculated

diffstat:

 src-db/database/model/functions/MA_PRODUCTION_COST.xml |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (14 lines):

diff -r c3112a8c4e22 -r 5fa0d14ad3d4 
src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml    Thu Mar 27 
13:07:49 2014 +0530
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml    Thu Mar 27 
09:53:31 2014 +0100
@@ -114,8 +114,8 @@
         , M_PRODUCTIONPLAN pp
       WHERE pr.m_production_id = p_Production_ID
         AND pr.m_production_id = pp.m_production_id
-        AND pp.m_productionplan_id = pl.m_productionplan_id
-        AND pl.calculated = 'N';
+        AND pp.m_productionplan_id = pl.m_productionplan_id;
+      v_costingdate := COALESCE(v_costingdate, v_productiondate);
     ELSE
       -- Costing engine not migrated
       SELECT MAX(pr.ad_client_id), MAX(pr.ad_org_id), MAX(movementdate), 
MAX(movementdate), COUNT (*), MAX(pr.DOCUMENTNO)

------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits