details: https://code.openbravo.com/erp/devel/pi/rev/1dc82c8f017f
changeset: 17798:1dc82c8f017f
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Aug 29 12:03:41 2012 +0200
summary: issue 21458: The column Consum per unit Std of the production cost
report should show other value
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 650c384edc2a -r 1dc82c8f017f
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Wed Aug 29 11:53:16 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Wed Aug 29 12:03:41 2012 +0200
@@ -84,7 +84,7 @@
FROM
(SELECT SUM(pl.MovementQty) AS ProducedQty,
MAX(C_CURRENCY_CONVERT(pl.ComponentCost, ?, ?,
TO_DATE(p.movementdate), null, pl.ad_client_id, pl.ad_org_id)) AS
ComponentCost,
- pp.M_ProductionPlan_ID, wrp.MA_Sequence_ID,sp.sum(sp.quantity)
as ProducedStdQuantity
+ pp.M_ProductionPlan_ID, wrp.MA_Sequence_ID,sum(sp.quantity) as
ProducedStdQuantity
FROM M_Production p
INNER JOIN M_ProductionPlan pp ON (p.M_Production_ID =
pp.M_Production_ID)
INNER JOIN M_ProductionLine pl ON (pp.M_ProductionPlan_ID =
pl.M_ProductionPlan_ID)
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
