Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009037Openbravo ERP08. Project and service managementpublic2009-05-15 08:182009-05-30 00:00
Reporterrafaroda 
Assigned Torafaroda 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Versionmain 
Target VersionFixed in Versionpi 
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
Summary0009037: 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
depends on backport 0009088 closed rafaroda Change Project Profitability citeria for displaying invoices 
depends on backport 0009089 closed rafaroda Change Project Profitability citeria for displaying invoices 
related to defect 0008895 closed jayakumar report "project profitability" is incorrect with invoices voids 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-15 08:18rafarodaNew Issue
2009-05-15 08:18rafarodaAssigned To => rafaroda
2009-05-15 08:18rafarodaRegression testing => No
2009-05-15 08:20rafarodaRelationship addedrelated to 0008895
2009-05-19 17:05psarobeStatusnew => scheduled
2009-05-19 17:05psarobefix_in_branch => pi
2009-05-20 09:37hgbotCheckin
2009-05-20 09:37hgbotNote Added: 0016490
2009-05-20 09:37hgbotStatusscheduled => resolved
2009-05-20 09:37hgbotResolutionopen => fixed
2009-05-20 09:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/babe29aa8dfbf7660fd6fe2fa932ea147010ac49 [^]
2009-05-20 09:43rafarodaNote Added: 0016491
2009-05-29 17:03sureshbabuStatusresolved => closed
2009-05-29 17:03sureshbabuNote Added: 0016776
2009-05-29 17:03sureshbabuFixed in Version => pi
2009-05-30 00:00anonymoussf_bug_id0 => 2798623

Notes
(0016490)
hgbot   
2009-05-20 09:37   
Repository: erp/devel/pi
Changeset: babe29aa8dfbf7660fd6fe2fa932ea147010ac49
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed May 20 09:34:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/babe29aa8dfbf7660fd6fe2fa932ea147010ac49 [^]

Fixes issue 0009037 Changed Project Profitability criteria for displaying invoices

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0016491)
rafaroda   
2009-05-20 09:43   
To test this fix:
   1. Create an invoice associated to a project with some lines.
   2. Complete this invoice.
   3. Void this invoice by clicking reactivate button.
   4. Create a new invoice associated to the same project with some lines.
   5. Complete this invoice.
   6. Run the Project profitability Report selecting the project.
   7. The amount displayed should be equal to the summed line amount of the second invoice.
(0016776)
sureshbabu   
2009-05-29 17:03   
Tested working fine