Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019152
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementminoralways2011-11-23 15:552011-12-22 03:53
ReportermaiteView Statuspublic 
Assigned Tojecharri 
PriorityhighResolutionfixedFixed in Version3.0MP7
StatusclosedFix in branchpiFixed in SCM revision6a8a0f555ee5
ProjectionnoneETAnoneTarget Version3.0MP7
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket13256
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019152: Error in Production Cost Report query

DescriptionError in Production Cost Report query
Steps To ReproduceRealize that ReportProductionCost_data.xsql, in "selectMaterial" query, in "rpn" subquery is multiplying by "pl.MovementQty" when calculating "CalcCost", and it should not.
Proposed Solutionsubstitute "CalcCost" in "rpn" subquery by:

SUM(C_CURRENCY_CONVERT(pl.CalcCost, ?, ?, TO_DATE(p.movementdate), null, pl.ad_client_id, pl.ad_org_id))/SUM(pl.MovementQty) AS CalcCost

instead of

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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00191532.50MP38 closedjonalegriaesarte Error in Production Cost Report query 

-  Notes
(0043953)
hgbot (developer)
2011-12-19 17:54

 Repository: erp/devel/pi
Changeset: 6a8a0f555ee54cb71b7056cbebc5ab6f96d8bbb7
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Dec 19 10:18:32 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6a8a0f555ee54cb71b7056cbebc5ab6f96d8bbb7 [^]

Fixes issue 19152: Error in Production Cost Report query

---
M src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
---
(0043971)
maite (viewer)
2011-12-20 11:35

 verified
(0043993)
hudsonbot (viewer)
2011-12-22 03:53

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9ac5e6f282ca [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2011-11-23 15:55 maite New Issue
2011-11-23 15:55 maite Assigned To => jonalegriaesarte
2011-11-23 15:55 maite Modules => Core
2011-11-23 15:55 maite OBNetwork customer => Yes
2011-11-23 15:55 maite Support ticket => 13256
2011-11-23 15:55 maite Issue Monitored: networkb
2011-11-23 16:14 maite Status new => scheduled
2011-11-23 16:14 maite fix_in_branch => pi
2011-12-16 11:19 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2011-12-19 17:54 hgbot Checkin
2011-12-19 17:54 hgbot Note Added: 0043953
2011-12-19 17:54 hgbot Status scheduled => resolved
2011-12-19 17:54 hgbot Resolution open => fixed
2011-12-19 17:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6a8a0f555ee54cb71b7056cbebc5ab6f96d8bbb7 [^]
2011-12-20 11:35 maite Note Added: 0043971
2011-12-20 11:35 maite Status resolved => closed
2011-12-20 11:35 maite Fixed in Version => 3.0MP7
2011-12-22 03:53 hudsonbot Checkin
2011-12-22 03:53 hudsonbot Note Added: 0043993

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker