details: https://code.openbravo.com/erp/devel/pi/rev/8dd45748904f
changeset: 21387:8dd45748904f
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Oct 25 11:13:02 2013 +0200
summary: Fixes issue 24714: The Production Cost Report should represent
the Standard Cost column per produced unit produced
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql | 8
++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (39 lines):
diff -r 5a38d2d280ca -r 8dd45748904f
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Fri Oct 25 10:14:49 2013 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Fri Oct 25 11:13:02 2013 +0200
@@ -143,7 +143,7 @@
FROM (
SELECT auxSeq.MA_Machine_ID AS ID, MA_Machine.name,
SUM(auxSeq.TotalRealCost*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty)
AS CostPerUnit,
- SUM(C_CURRENCY_CONVERT(sm.CalcCost, ?, ?, TO_DATE(sm.Updated), null,
sm.ad_client_id,
sm.ad_org_id)*auxSeq.ComponentCost*auxSeq.ProducedQty)/SUM(auxSeq.ProducedQty)
AS CostPerUnitStd,
+ SUM(C_CURRENCY_CONVERT(sm.CalcCost, ?, ?, TO_DATE(sm.Updated), null,
sm.ad_client_id, sm.ad_org_id)*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty) AS
CostPerUnitStd,
to_char((to_number(?)+1)*5) as level_blanck,
to_char(40-((to_number(?)+1)*5)) as level_name, to_char(to_number(?)+1) as
levelid
FROM
(SELECT rmc.MA_Machine_ID, rpp.ComponentCost, SUM(rpp.ProducedQty)
AS ProducedQty,
@@ -203,7 +203,7 @@
FROM (
SELECT auxSeq.MA_Indirect_Cost_ID AS ID, MA_Indirect_Cost.name,
SUM(auxSeq.TotalRealCost*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty)
AS CostPerUnit,
- SUM(C_CURRENCY_CONVERT(si.CalcCost, ?, ?, TO_DATE(si.Updated), null,
si.ad_client_id,
si.ad_org_id)*auxSeq.ComponentCost*auxSeq.ProducedQty)/SUM(auxSeq.ProducedQty)
AS CostPerUnitStd,
+ SUM(C_CURRENCY_CONVERT(si.CalcCost, ?, ?, TO_DATE(si.Updated), null,
si.ad_client_id, si.ad_org_id)*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty) AS
CostPerUnitStd,
to_char((to_number(?)+1)*5) as level_blanck,
to_char(40-((to_number(?)+1)*5)) as level_name, to_char(to_number(?)+1) as
levelid
FROM
(SELECT rmi.MA_Indirect_Cost_ID, rpp.ComponentCost,
SUM(rpp.ProducedQty) AS ProducedQty,
@@ -263,7 +263,7 @@
FROM (
SELECT auxSeq.C_Salary_Category_ID AS ID, C_Salary_Category.name,
SUM(auxSeq.TotalRealCost*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty)
AS CostPerUnit,
- SUM(C_CURRENCY_CONVERT(se.CalcCost, ?, ?, TO_DATE(se.Updated), null,
se.ad_client_id,
se.ad_org_id)*auxSeq.ComponentCost*auxSeq.ProducedQty)/SUM(auxSeq.ProducedQty)
AS CostPerUnitStd, to_char((to_number(?)+1)*5) as level_blanck,
to_char(40-((to_number(?)+1)*5)) as level_name, to_char(to_number(?)+1) as
levelid
+ SUM(C_CURRENCY_CONVERT(se.CalcCost, ?, ?, TO_DATE(se.Updated), null,
se.ad_client_id, se.ad_org_id)*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty) AS
CostPerUnitStd, to_char((to_number(?)+1)*5) as level_blanck,
to_char(40-((to_number(?)+1)*5)) as level_name, to_char(to_number(?)+1) as
levelid
FROM
(SELECT rme.C_Salary_Category_ID, rpp.ComponentCost,
SUM(rpp.ProducedQty) AS ProducedQty,
SUM(rme.CalcCost) AS TotalRealCost, rpp.MA_Sequence_ID
@@ -322,7 +322,7 @@
FROM (
SELECT auxSeq.MA_CostCenter_Version_ID AS ID, MA_CostCenter.name,
SUM(auxSeq.TotalRealCost*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty)
AS CostPerUnit,
- SUM(C_CURRENCY_CONVERT(se.CostCenterCost, ?, ?, TO_DATE(se.Updated),
null, se.ad_client_id,
se.ad_org_id)*auxSeq.ComponentCost*auxSeq.ProducedQty)/SUM(auxSeq.ProducedQty)
AS CostPerUnitStd,
+ SUM(C_CURRENCY_CONVERT(se.CostCenterCost, ?, ?, TO_DATE(se.Updated),
null, se.ad_client_id,
se.ad_org_id)*auxSeq.ComponentCost)/SUM(auxSeq.ProducedQty) AS CostPerUnitStd,
to_char((to_number(?)+1)*5) as level_blanck,
to_char(40-((to_number(?)+1)*5)) as level_name, to_char(to_number(?)+1) as
levelid
FROM
(SELECT rpp.MA_CostCenter_Version_ID, rpp.ComponentCost,
SUM(rpp.ProducedQty) AS ProducedQty,
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
