Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007283Openbravo ERP08. Project and service managementpublic2009-01-30 16:372009-04-21 10:54
plujan 
gorkaion 
normalmajorhave not tried
closedfixed 
30
pi 
2.50beta 
Core
No
0007283: Project Profitability report do not work using default data
I have a client with standard data (Smoke Test was followed). When I launch the Project Profitability report with standard filter, I get an error:
No conversion rate defined
ERROR: @NoConversionRate@ 100 @to@ 102 @ForDate@ '11-12-2007', @Client@ 'Accounting Test' @And@ @ACCS_AD_ORG_ID_D@ 'Accounting Test Org'.

and the report is not displayed.
1. Create a new client, with products, business partners, etc. as in Smoke Test
2. Create a new Multiphase project and a Service project as in Smoke Test
3. Go Project and Services > Analysis Tools > Project Profitability
4. With default filters, click HTML Format button. An error is displayed, see attach.
QA_review_pre_beta
related to defect 0009043 closed adrianromero Project Profitability report uses conversion rates for client BigBazaar even if I am using a different client 
png BUG_250_trunk_ProjectProfitability.PNG (21,532) 2009-01-30 16:37
https://issues.openbravo.com/file_download.php?file_id=776&type=bug
png
Issue History
2009-01-30 16:37plujanNew Issue
2009-01-30 16:37plujanAssigned To => rafaroda
2009-01-30 16:37plujansf_bug_id0 => 2549424
2009-01-30 16:37plujanFile Added: BUG_250_trunk_ProjectProfitability.PNG
2009-01-30 16:37plujanRegression testing => No
2009-01-30 16:37plujanTag Attached: QA_review_pre_beta
2009-02-03 10:42psarobeStatusnew => scheduled
2009-02-03 10:42psarobefix_in_branch => trunk
2009-02-17 17:33rafarodaAssigned Torafaroda => gorkaion
2009-02-18 12:20artemIssue Monitored: artem
2009-02-20 17:48svnbotCheckin
2009-02-20 17:48svnbotNote Added: 0013864
2009-02-20 17:48svnbotStatusscheduled => resolved
2009-02-20 17:48svnbotResolutionopen => fixed
2009-02-20 17:48svnbotsvn_revision => 13485
2009-02-23 09:15artemIssue End Monitor: artem
2009-04-21 10:54psarobeStatusresolved => closed
2009-05-15 11:10rafarodaRelationship addedrelated to 0009043

Notes
(0013864)
svnbot   
2009-02-20 17:48   
Repository: openbravo
Revision: 13485
Author: gorkaion
Date: 2009-02-20 17:48:31 +0100 (Fri, 20 Feb 2009)

Fixed bug 7283. Modified the Project Profitability report to filter also the subqueries by client and organization. It also filters the subqueries to consider only invoices with a related project.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13485&sc=1 [^]