Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012431Openbravo ERP08. Project and service managementpublic2010-02-24 10:332010-03-16 00:00
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012431: It is not possible to execute Project profitability
DescriptionWhen Project profitability is executed in other client than Smallbazaar and other currency than EUR, this error appears:

No conversion rate defined
There is no conversion rate defined from (EUR-€) to (ZWD-Z$) for date '08-08-2006', Client 'SmallBazaar' and Organization 'Main'.
Steps To ReproduceSelect Accounting Test Admin client.
Go to Project and Service management > Analysis tools > Project Profitability.
Search "Accounting test Org" as organization, and ZWD as currency
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00120142.50MP14 closed adrianromero Error in Project Profitability 
has duplicate defect 0009043 closed adrianromero Project Profitability report uses conversion rates for client BigBazaar even if I am using a different client 
Attached Filesdiff issue-12431-possible-patch.diff (8,952) 2010-02-24 17:41
https://issues.openbravo.com/file_download.php?file_id=2277&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-02-24 10:33networkbNew Issue
2010-02-24 10:33networkbAssigned To => adrianromero
2010-02-24 10:33networkbOBNetwork customer => Yes
2010-02-24 17:27rafarodaRelationship addedrelated to 0009043
2010-02-24 17:28rafarodaNote Added: 0024790
2010-02-24 17:40rafarodaNote Added: 0024792
2010-02-24 17:41rafarodaFile Added: issue-12431-possible-patch.diff
2010-02-24 17:41rafarodaIssue Monitored: rafaroda
2010-02-24 17:45rafarodaNote Added: 0024795
2010-02-24 17:47rafarodaRelationship addedrelated to 0012014
2010-02-24 18:05adrianromeroStatusnew => scheduled
2010-02-24 18:05adrianromerofix_in_branch => pi
2010-03-08 11:42sureshbabuNote Added: 0025117
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-09 13:27hgbotCheckin
2010-03-09 13:27hgbotNote Added: 0025176
2010-03-09 13:27hgbotStatusscheduled => resolved
2010-03-09 13:27hgbotResolutionopen => fixed
2010-03-09 13:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dbfe99032a08d06a12e1c55b007eb9acca30115b [^]
2010-03-10 06:37sivaramanNote Added: 0025201
2010-03-10 11:00rafarodaNote Added: 0025206
2010-03-10 18:16adrianromeroRelationship replacedhas duplicate 0009043
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025410
2010-03-15 08:38arunkumarNote Added: 0025447
2010-03-15 08:38arunkumarStatusresolved => closed
2010-03-16 00:00anonymoussf_bug_id0 => 2970935

Notes
(0024790)
rafaroda   
2010-02-24 17:28   
Please have a look at issue 0009043 since it seems very related. In some place in the report there it a proper filter by client and organization.
(0024792)
rafaroda   
2010-02-24 17:40   
I attached a possible cause of the problem (please notice that this diff is NOT the fix).
(0024795)
rafaroda   
2010-02-24 17:45   
If issue 0009043 is duplicated please close issue 0009043 rather than this one (since this one is OBPS).
(0025117)
sureshbabu   
2010-03-08 11:42   
Hi

To test the issue, you need to create a new client other than the Smallbazaar(which comes along with sample data)
(0025176)
hgbot   
2010-03-09 13:27   
Repository: erp/devel/pi
Changeset: dbfe99032a08d06a12e1c55b007eb9acca30115b
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Tue Mar 09 17:59:31 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/dbfe99032a08d06a12e1c55b007eb9acca30115b [^]

Fixes issue 12431: It is not possible to execute Project profitability

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0025201)
sivaraman   
2010-03-10 06:37   
Issue:
It is not possible to execute Project profitability for client than Smallbazaar and other currency than EUR.

Steps to reproduce:
1. Log on to Openbravo
2. Change user role to Accounting Test Admin and entity to Accounting Test
3. Go to Project and Service management > Analysis tools > Project Profitability
4. Set "Accounting test Org"as organization
5. Set "Currency" as the client base currency (other than EUR)
6. Click "HTML Format" button
(0025206)
rafaroda   
2010-03-10 11:00   
Should we close issue 0009043 as duplicated? Thanks.
(0025410)
hudsonbot   
2010-03-12 22:41   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/dbfe99032a08 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025447)
arunkumar   
2010-03-15 08:38   
Tested & Working fine