Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009037
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementminoralways2009-05-15 08:182009-05-30 00:00
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PrioritylowResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revisionbabe29aa8dfb
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product VersionmainSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009037: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0009088 closedrafaroda Change Project Profitability citeria for displaying invoices 
depends on backport 0009089 closedrafaroda Change Project Profitability citeria for displaying invoices 
related to defect 0008895 closedjayakumar report "project profitability" is incorrect with invoices voids 

-  Notes
(0016490)
hgbot (developer)
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 (developer)
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 (reporter)
2009-05-29 17:03

Tested working fine

- Issue History
Date Modified Username Field Change
2009-05-15 08:18 rafaroda New Issue
2009-05-15 08:18 rafaroda Assigned To => rafaroda
2009-05-15 08:18 rafaroda Regression testing => No
2009-05-15 08:20 rafaroda Relationship added related to 0008895
2009-05-19 17:05 psarobe Status new => scheduled
2009-05-19 17:05 psarobe fix_in_branch => pi
2009-05-20 09:37 hgbot Checkin
2009-05-20 09:37 hgbot Note Added: 0016490
2009-05-20 09:37 hgbot Status scheduled => resolved
2009-05-20 09:37 hgbot Resolution open => fixed
2009-05-20 09:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/babe29aa8dfbf7660fd6fe2fa932ea147010ac49 [^]
2009-05-20 09:43 rafaroda Note Added: 0016491
2009-05-29 17:03 sureshbabu Status resolved => closed
2009-05-29 17:03 sureshbabu Note Added: 0016776
2009-05-29 17:03 sureshbabu Fixed in Version => pi
2009-05-30 00:00 anonymous sf_bug_id 0 => 2798623


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker