Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0004481 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] 08. Project and service management | minor | always | 2008-07-22 09:59 | 2011-02-04 09:11 | ||||||
| Reporter | rafaroda | View Status | public | ||||||||
| Assigned To | rmorley | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | ||||||
| OS Version | Ubuntu 7.10 | Database version | 8.3 | Ant version | 1.7 | ||||||
| Product Version | 2.50MP6 | SCM revision | 5950 | ||||||||
| 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 | 0004481: Review of Amounts and History panels in Project windows | ||||||||||
| Description | Both Multiphase and Service Project windows have fields in Amounts (see attach Amount-Panel.png) and History (see attach History-Panel.png) panels which fields are calculated by triggers (taking lines or phases and tasks values) and read-only in some cases but not in others. This is the current functionality (Openbravo ERP version 2.50 MP6). A) Amount panel (see C_Project_Trg2 trigger): * Planned Amount: mandatory field. ** In Service Projects: filled with the sum of Project Line planned amounts each time that a Project Line is added or updated. When Project Lines are deleted, this field is not updated (BUG). If you change this field manually and there are Project Lines, the value typed will be overwritten by the sum of the Project Lines. ** In Multiphase Projects: this field is never updated automatically. * Planned Quantity: mandatory field. ** In Service Projects: filled with the sum of Project Line quantities each time that a Project Line is added or updated. Quantities summed are from different products (ODD FUNCTIONALITY). When Project Lines are deleted, this field is not updated (BUG). If you change this field manually and there are Project Lines, the value typed will be overwritten by the sum of the Project Lines. ** In Multiphase Projects: this field is never updated automatically. * Planned Purchase Amount: non-mandatory hidden field. ** In Service Projects: filled with the sum of Project Line planned purchase amounts (planned price x planned quantity) each time that a Project Line is added or updated (BUG: it should be planned purchase price x planned quantity). When Project Lines are deleted, this field is not updated (BUG). ** In Multiphase Projects: this field is never updated automatically. * Planned Margin: mandatory field ** In Service Projects: calculated as the sum of Planned Margins of the lines (BUG: a margin of 80% in 2 lines does not make a margin of 160%). When Project Lines are deleted, this field is not updated (BUG). If you change this field manually and there are Project Lines, the value typed will be overwritten by the sum of the Project Lines. ** In Multiphase Projects: this field is never updated automatically. * Contract Amount: mandatory field ** In Service Projects: this field is never updated automatically. ** In Multiphase Projects: this field is never updated automatically. * Contract Quantity: mandatory field ** In Service Projects: this field is never updated automatically. ** In Multiphase Projects: this field is never updated automatically. * Service Revenue: non-mandatory and non-calculated field. Estimated (planned) revenues for the services (products with product type = services) provided during the project. Used as planned service revenue in the project profitability report. * Service Cost: non-mandatory and non-calculated field. Estimated cost of providing those services, that is, the cost of the human resources involved in providing those services. Used as planned service cost in the project profitability report. * Service Margin %: non-mandatory and non-calculated field. Estimated profitability margin for the services provided during the project. Many times one is not concerned about the net amounts of revenues and expenses but about the final profitability margin in %. Used as planned service margin in the project profitability report. * Planned Expenses: non-mandatory and non-calculated field. Estimated expenses in collateral goods or services (taxis, hotels, meals, servers, ...) that happen during the execution and supply of of the services. Used as planned expenses in the project profitability report. * Reinvoiced Expenses: non-mandatory and non-calculated field. Amount of those collateral expenses that we estimate that the customer will accept to be re-billed for. Used as planned reinvoiced expenses in the project profitability report. * Expenses Margin %: non-mandatory and non-calculated field. Estimated balance in % between the collateral expenses and the amount that the customer accepted to be re-billed for. Ideally, this margin would be zero (the customer was re-billed for all the collateral expenses), but is usually negative (we had some expenses that the customer did not accept to pay) and rarely positive (the customer paid us for our expenses more than we spent). Used as planned expenses margin % in the project profitability report. B) History panel: * Invoiced Amount: mandatory read-only field ** In Service Projects: this field is never updated automatically. ** In Multiphase Projects: this field is never updated automatically. * Invoiced Quantity: mandatory read-only field ** In Service Projects: this field is never updated automatically. ** In Multiphase Projects: this field is never updated automatically. * Project Balance: mandatory read-only field ** In Service Projects: this field is never updated automatically. ** In Multiphase Projects: this field is never updated automatically. | ||||||||||
| Steps To Reproduce | 1) Go to Project & Service Management || Transactions || Multiphase Project 2) Go to Project & Service Management || Transactions || Service Project | ||||||||||
| Proposed Solution | This is the proposed functionality: A) Amount panel: * Planned Amount: fix BUG. ** In Service Projects: read-only and calculated automatically. ** In Multiphase Projects: hidden. * Planned Quantity: fix BUG. ** In Service Projects: read-only and calculated automatically. ** In Multiphase Projects: hidden. * Planned Purchase Amount: fix 2 BUGS. ** In Service Projects: read-only and calculated automatically. ** In Multiphase Projects: hidden. * Planned Margin: fix 2 BUGS. ** In Service Projects: read-only and calculated automatically. ** In Multiphase Projects: hidden. * Contract Amount: keep it as it is. * Contract Quantity: keep it as it is. * Service Revenue: Change name to Planned Service Revenue. * Service Cost: Change name to Planned Service Cost. * Service Margin %: Change name to Planned Service Margin %. * Planned Expenses: keep it as it is. * Reinvoiced Expenses: Change name to Planned Reinvoiced Expenses. * Expenses Margin %: Change name to Planned Expenses Margin %. B) History panel: * Invoice Amount: hide in both Multiphase and Service Projects * Invoice Quantity: hide in both Multiphase and Service Projects * Project Balance: hide in both Multiphase and Service Projects | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files |  Amount-Panel.png [^] (12,591 bytes) 2008-07-22 09:59
History-Panel.png [^] (4,356 bytes) 2008-07-22 09:59
| ||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0020595) rafaroda (developer) 2009-09-30 14:38 edited on: 2009-09-30 16:01 |
SELECT C_PROJECT_ID, NAME, PLANNEDAMT, PLANNEDQTY, PLANNEDPOAMT, PLANNEDMARGINAMT, COMMITTEDAMT, COMMITTEDQTY, SERVREVENUE, SERVCOST, SERVMARGIN, EXPEXPENSES, EXPREINVOICING, EXPMARGIN INVOICEDAMT, INVOICEDQTY, PROJECTBALANCEAMT FROM C_PROJECT ORDER BY UPDATED DESC |
|
(0020598) rafaroda (developer) 2009-09-30 16:02 |
Reminder sent to: pjuvara Paolo, Can you please comment on the porposed solution? This issue is part of the Project Profitability Review project. Thanks. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-22 09:59 | rafaroda | New Issue | |
| 2008-07-22 09:59 | rafaroda | Assigned To | => rafaroda |
| 2008-07-22 09:59 | rafaroda | sf_bug_id | 0 => 2024356 |
| 2008-07-22 09:59 | rafaroda | File Added: Amount-Panel.png | |
| 2008-07-22 09:59 | rafaroda | File Added: History-Panel.png | |
| 2008-07-22 10:00 | rafaroda | Relationship added | blocks 0000502 |
| 2008-07-22 10:00 | rafaroda | Status | new => scheduled |
| 2008-07-22 10:00 | rafaroda | fix_in_branch | => trunk |
| 2008-07-27 17:14 | rafaroda | Target Version | 2.50 => |
| 2008-07-27 17:14 | rafaroda | fix_in_branch | trunk => |
| 2008-11-10 14:25 | rafaroda | Assigned To | rafaroda => pjuvara |
| 2009-09-27 06:41 | rafaroda | Status | scheduled => acknowledged |
| 2009-09-30 14:38 | rafaroda | Note Added: 0020595 | |
| 2009-09-30 15:21 | rafaroda | version | pi => 2.50MP6 |
| 2009-09-30 15:21 | rafaroda | Description Updated | |
| 2009-09-30 15:21 | rafaroda | Steps to Reproduce Updated | |
| 2009-09-30 15:58 | rafaroda | Description Updated | |
| 2009-09-30 15:58 | rafaroda | Steps to Reproduce Updated | |
| 2009-09-30 15:59 | rafaroda | Description Updated | |
| 2009-09-30 16:01 | rafaroda | Note Edited: 0020595 | |
| 2009-09-30 16:02 | rafaroda | Note Added: 0020598 | |
| 2010-08-24 22:52 | fgredruello | Issue Monitored: fgredruello | |
| 2010-10-25 18:06 | networkb | Relationship added | blocks 0015030 |
| 2010-10-25 18:12 | networkb | Relationship deleted | blocks 0015030 |
| 2010-10-25 18:12 | networkb | Relationship added | related to 0015030 |
| 2011-02-04 09:11 | jpabloae | Assigned To | pjuvara => rmorley |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |