details: https://code.openbravo.com/erp/devel/pi/rev/4544b6690ed6
changeset: 17799:4544b6690ed6
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Aug 29 12:17:23 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 1dc82c8f017f -r 4544b6690ed6
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Wed Aug 29 12:03:41 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Wed Aug 29 12:17:23 2012 +0200
@@ -110,7 +110,7 @@
GROUP BY pl.M_Product_ID, pl.M_ProductionPlan_ID
HAVING SUM(pl.MovementQty) <> 0) rpn
ON (rpp.M_ProductionPlan_ID = rpn.M_ProductionPlan_ID)
- GROUP BY rpn.M_Product_ID, rpp.ComponentCost, rpp.MA_Sequence_ID)
auxSeq
+ GROUP BY rpn.M_Product_ID, rpp.ComponentCost, rpp.MA_Sequence_ID,
rpp.ProducedStdQuantity) auxSeq
LEFT OUTER JOIN MA_SequenceProduct sp
ON (auxSeq.M_Product_ID = sp.M_Product_ID AND auxSeq.MA_Sequence_ID =
sp.MA_Sequence_ID), M_Product
WHERE auxSeq.M_Product_ID = M_Product.M_Product_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
