Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009088 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 08. Project and service management | minor | always | 2009-05-15 08:18 | 2009-05-27 14:46 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | 2.40MP5 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | e2f8d09b5e3b | |||
| 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 | 0009088: 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 |
|
|
(0016473) hgbot (developer) 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 (developer) 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 (reporter) 2009-05-27 14:46 |
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.40 |
| 2009-05-19 18:15 | hgbot | Checkin | |
| 2009-05-19 18:15 | hgbot | Note Added: 0016473 | |
| 2009-05-19 18:15 | hgbot | Status | scheduled => resolved |
| 2009-05-19 18:15 | hgbot | Resolution | open => fixed |
| 2009-05-19 18:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23 [^] |
| 2009-05-19 18:17 | rafaroda | Relationship added | related to 0008903 |
| 2009-05-20 09:30 | hgbot | Checkin | |
| 2009-05-20 09:30 | hgbot | Note Added: 0016489 | |
| 2009-05-20 09:30 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/926d97d5de16dd9e4c3c9b8bbe1ed29e3d8f3b23 [^] => http://code.openbravo.com/erp/stable/2.40/rev/e2f8d09b5e3b0bc3cf1842625fc9d1a248467e9e [^] |
| 2009-05-21 20:08 | psarobe | Status | resolved => new |
| 2009-05-21 20:08 | psarobe | Resolution | fixed => open |
| 2009-05-21 20:08 | psarobe | Status | new => scheduled |
| 2009-05-21 20:08 | psarobe | Fixed in Version | => 2.40MP4 |
| 2009-05-21 20:08 | psarobe | Status | scheduled => resolved |
| 2009-05-21 20:08 | psarobe | Resolution | open => fixed |
| 2009-05-27 14:46 | sureshbabu | Status | resolved => closed |
| 2009-05-27 14:46 | sureshbabu | Note Added: 0016679 | |
| 2009-05-27 14:46 | sureshbabu | Fixed in Version | 2.40MP4 => 2.40MP5 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |