Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009089Openbravo ERP08. Project and service managementpublic2009-05-15 08:182009-06-03 11:12
Reporterrafaroda 
Assigned Torafaroda 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Versionmain 
Target VersionFixed in Version2.35MP13 
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
Summary0009089: 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 0008923 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.3x
2009-05-19 18:22rafarodaRelationship addedrelated to 0008923
2009-05-20 12:34hgbotCheckin
2009-05-20 12:34hgbotNote Added: 0016506
2009-05-20 12:34hgbotStatusscheduled => resolved
2009-05-20 12:34hgbotResolutionopen => fixed
2009-05-20 12:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/c8e4303156cdef13af38bd3b4c0b8b0b1a15ee08 [^]
2009-05-28 07:27sureshbabuStatusresolved => closed
2009-05-28 07:27sureshbabuNote Added: 0016696
2009-05-28 07:27sureshbabuFixed in Version => 2.35MP14
2009-06-03 11:12sureshbabuFixed in Version2.35MP14 => 2.35MP13

Notes
(0016506)
hgbot   
2009-05-20 12:34   
Repository: erp/stable/2.3x
Changeset: c8e4303156cdef13af38bd3b4c0b8b0b1a15ee08
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed May 20 12:33:28 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.3x/rev/c8e4303156cdef13af38bd3b4c0b8b0b1a15ee08 [^]

Fixes issue 0009089 Changed Project Profitability criteria for displaying invoices

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0016696)
sureshbabu   
2009-05-28 07:27   
Tested working fine