Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009088Openbravo ERP08. Project and service managementpublic2009-05-15 08:182009-05-27 14:46
Reporterrafaroda 
Assigned Torafaroda 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Versionmain 
Target VersionFixed in Version2.40MP5 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009088: Change Project Profitability citeria for displaying invoices
DescriptionThe behavior of all the reports which show invoices is the following:
* Show invoices which are processed: C_INVOICE.PROCESSED = 'Y'
* This means that the invoices status can be both Completed (CO), Closed (CL) and Void (VO)


The behavior of the Project Profitability Report (which is showing invoices associated to projects) is the following:
* Shows invoices which are in status both Completed (CO) and Closed (CL): ia.docStatus IN ('CO', 'CL')

Why is the behavior different in the Project profitability Report?
* There is no functional reason but technical performance reasons: this report is using multiple subqueries and discarding invoices in status Void will make it faster.

For preserving the consistency of the reports which show invoices, project profitability report will show invoices with C_INVOICE.PROCESSED = 'Y' and not ia.docStatus IN ('CO', 'CL')
Steps To Reproduce1) Create an invoice related to a project
2) Add some lines.
3) Go back to header and complete it.
4) Void it.
5) Run the Project Profitability Report.

These invoices (both the voided and the created for voiding it) should appear in the Project Profitability Report (with net amount equal to 0).
Proposed SolutionChange all the ia.docStatus IN ('CO', 'CL') by ia.Processed='Y' in ReportProjectProfitability_data.xsql
Additional Information
TagsNo tags attached.
Relationships
related to backport 0008903 closed jayakumar report "project profitability" is incorrect with invoices voids 
blocks defect 0009037 closed rafaroda Change Project Profitability citeria for displaying invoices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-19 17:05psarobeTypedefect => backport
2009-05-19 17:05psarobefix_in_branch => 2.40
2009-05-19 18:15hgbotCheckin
2009-05-19 18:15hgbotNote Added: 0016473
2009-05-19 18:15hgbotStatusscheduled => resolved
2009-05-19 18:15hgbotResolutionopen => fixed
2009-05-19 18:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23 [^]
2009-05-19 18:17rafarodaRelationship addedrelated to 0008903
2009-05-20 09:30hgbotCheckin
2009-05-20 09:30hgbotNote Added: 0016489
2009-05-20 09:30hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23 [^] => http://code.openbravo.com/erp/stable/2.40/rev/e2f8d09b5e3b0bc3cf1842625fc9d1a248467e9e [^]
2009-05-21 20:08psarobeStatusresolved => new
2009-05-21 20:08psarobeResolutionfixed => open
2009-05-21 20:08psarobeStatusnew => scheduled
2009-05-21 20:08psarobeFixed in Version => 2.40MP4
2009-05-21 20:08psarobeStatusscheduled => resolved
2009-05-21 20:08psarobeResolutionopen => fixed
2009-05-27 14:46sureshbabuStatusresolved => closed
2009-05-27 14:46sureshbabuNote Added: 0016679
2009-05-27 14:46sureshbabuFixed in Version2.40MP4 => 2.40MP5

Notes
(0016473)
hgbot   
2009-05-19 18:15   
Repository: erp/stable/2.40
Changeset: 926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue May 19 18:10:17 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23 [^]

Fixes issue 0009088 Changed Project Profitability criteria for displaying invoices

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0016489)
hgbot   
2009-05-20 09:30   
Repository: erp/stable/2.40
Changeset: e2f8d09b5e3b0bc3cf1842625fc9d1a248467e9e
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed May 20 09:26:59 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/e2f8d09b5e3b0bc3cf1842625fc9d1a248467e9e [^]

Fixes issue 0009088 Fixed problems with discounts.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0016679)
sureshbabu   
2009-05-27 14:46   
Tested working fine