Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009037 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 08. Project and service management | minor | always | 2009-05-15 08:18 | 2009-05-30 00:00 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | babe29aa8dfb | |||
| 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 | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009037: 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 |
|
|
(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 (viewer) 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 (viewer) 2009-05-29 17:03 |
Tested working fine |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |