details: https://code.openbravo.com/erp/stable/2.50/rev/5d67930d2f9e
changeset: 9772:5d67930d2f9e
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Tue Jan 03 18:17:04 2012 +0100
summary: Fixes issue 0019153: Error in Production Cost Report query
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 240202af6b24 -r 5d67930d2f9e
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Tue Jan 03 11:36:56 2012 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
Tue Jan 03 18:17:04 2012 +0100
@@ -99,7 +99,7 @@
HAVING SUM(pl.MovementQty) <> 0) rpp
LEFT OUTER JOIN
(SELECT pl.M_Product_ID, SUM(pl.MovementQty) AS ConsumedQty,
- SUM(pl.MovementQty*C_CURRENCY_CONVERT(pl.CalcCost, ?, ?,
TO_DATE(p.movementdate), null, pl.ad_client_id,
pl.ad_org_id))/SUM(pl.MovementQty) AS CalcCost,
+ SUM(C_CURRENCY_CONVERT(pl.CalcCost, ?, ?,
TO_DATE(p.movementdate), null, pl.ad_client_id,
pl.ad_org_id))/SUM(pl.MovementQty) AS CalcCost,
pl.M_ProductionPlan_ID
FROM M_ProductionLine pl, M_ProductionPlan pp, M_Production p
WHERE pl.ProductionType = '-'
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
