Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009089 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 08. Project and service management | minor | always | 2009-05-15 08:18 | 2009-06-03 11:12 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | 2.35MP13 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | c8e4303156cd | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | main | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009089: Change Project Profitability citeria for displaying invoices | |||||||
| Description | The 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 Reproduce | 1) 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 Solution | Change all the ia.docStatus IN ('CO', 'CL') by ia.Processed='Y' in ReportProjectProfitability_data.xsql | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0016506) hgbot (developer) 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 (reporter) 2009-05-28 07:27 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-05-19 17:05 | psarobe | Type | defect => backport |
| 2009-05-19 17:05 | psarobe | fix_in_branch | => 2.3x |
| 2009-05-19 18:22 | rafaroda | Relationship added | related to 0008923 |
| 2009-05-20 12:34 | hgbot | Checkin | |
| 2009-05-20 12:34 | hgbot | Note Added: 0016506 | |
| 2009-05-20 12:34 | hgbot | Status | scheduled => resolved |
| 2009-05-20 12:34 | hgbot | Resolution | open => fixed |
| 2009-05-20 12:34 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.3x/rev/c8e4303156cdef13af38bd3b4c0b8b0b1a15ee08 [^] |
| 2009-05-28 07:27 | sureshbabu | Status | resolved => closed |
| 2009-05-28 07:27 | sureshbabu | Note Added: 0016696 | |
| 2009-05-28 07:27 | sureshbabu | Fixed in Version | => 2.35MP14 |
| 2009-06-03 11:12 | sureshbabu | Fixed in Version | 2.35MP14 => 2.35MP13 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |