Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008571Openbravo ERP08. Project and service managementpublic2009-04-15 06:472009-05-05 00:00
Reporterarunkumar 
Assigned Torajagopal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008571: Project Profitability Report shows error.
DescriptionClicking the HTML format or PDF format of the Project Profitability Report shows error.
Steps To Reproduce# Login as userA
# Go to Project & Service Management->Analysis Format -> Project Profitability
# Click HTML format or PDF format.

A popup window opens & shows a message as "Error".
Proposed Solution
Additional Information
Tags250 final review, 250MP1
Relationships
has duplicate defect 0008752 closed rafaroda Project profitabillity report throws an error 
Attached Filesjpg ProjectProfitabilityReport.JPG (145,082) 2009-04-15 06:47
https://issues.openbravo.com/file_download.php?file_id=1177&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-04-15 06:47arunkumarNew Issue
2009-04-15 06:47arunkumarAssigned To => rafaroda
2009-04-15 06:47arunkumarFile Added: ProjectProfitabilityReport.JPG
2009-04-15 06:47arunkumarRegression testing => No
2009-04-15 06:48arunkumarTag Attached: 250 final review
2009-04-20 12:49psarobePrioritynormal => urgent
2009-04-20 12:49psarobeSeverityminor => major
2009-04-20 12:49psarobeStatusnew => scheduled
2009-04-22 17:53rafarodaAssigned Torafaroda => sathiyan
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-24 09:47rafarodaRelationship addedhas duplicate 0008752
2009-04-24 11:46sathiyanAssigned Tosathiyan => rajagopal
2009-04-27 09:56rafarodaNote Added: 0015751
2009-04-27 14:30rajagopalFile Added: 8571.png
2009-04-28 07:57rajagopalFile Deleted: 8571.png
2009-04-28 11:30rafarodaNote Added: 0015832
2009-04-28 13:21hgbotCheckin
2009-04-28 13:21hgbotNote Added: 0015847
2009-04-28 13:21hgbotStatusscheduled => resolved
2009-04-28 13:21hgbotResolutionopen => fixed
2009-04-28 13:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/811e714cd5b8edf8f348d7c0817f496e484688b0 [^]
2009-05-04 19:44psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786899

Notes
(0015751)
rafaroda   
2009-04-27 09:56   
This could happen if you create a new organization which ID is an UUID. Please review in ReportProjectProfitabilityJR.jrxml the following line:

<field name="ORG" class="java.math.BigDecimal"/>

which corresponds in the SQL with P.AD_ORG_ID AS ORG,
(0015832)
rafaroda   
2009-04-28 11:30   
To make this report fail:

1) Create a new organization
2) Set it as ready
3) Set this organization child of main
4) Create a new service project with this new organization
5) Then create some sale order for this project
6) Complete this sale order and create an invoice for it
7) Complete this invoice

Then you will have data enough for the report to crash
(0015847)
hgbot   
2009-04-28 13:21   
Repository: erp/devel/pi
Changeset: 811e714cd5b8edf8f348d7c0817f496e484688b0
Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
Date: Tue Apr 28 16:46:57 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/811e714cd5b8edf8f348d7c0817f496e484688b0 [^]

Fixes bug 8571: Project Profitability Report shows error has been fixed.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml
---