Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010690 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 08. Project and service management | major | always | 2009-09-22 11:56 | 2011-01-12 12:34 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 21ce76219421 | |||
| 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 | pi | 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 | 0010690: Expense Report and Project Profitability Reports display hours even if time sheet lines are in days | |||||||
| Description | Expense Report and Project Profitability Reports are displaying hours even if the time sheet line has been reported in days. Take into account that the cost associated to the hours is defined per hours in Master Data Management || Business Partner Setup || Salary Category || Salary Category >> Cost | |||||||
| Steps To Reproduce | 1) Define a new Salary Category: Consultant 2) Assign it a Cost of: * Cost = 60 * Cost UOM = per Hour * Starting Date = 01-01-2000 3) Select an Employee and assign it the previous Salary category from Starting Date = 01-01-2007 (Master Data Management || Business Partner || Business Partner >> Employee >> Salary category) 4) Create a new product: * Name = Consultancy * UOM = Day * Product Type = Service 5) In UOM tab create a record for UOM = Hour 6) Create a conversion between Hours and Days in Master Data Management || Product Setup || Unit of Measure * Select Day and in Conversion tab add: ** To UOM = Hour ** Multiply Rate by = 8 * Select Hour and in Conversion tab add: ** To UOM = Day ** Divide Rate by = 8 7) Create a new Service Project: * Name = My Project * Business Partner = Millman 8) Create an Expense Sheet for the previous employee in step 3 (Project & Service Management || Transactions || Expense Sheet || Header) 9) Add a new time sheet line for reporting 3 consultancy days in project My Project: * Time Sheet = Y * Product = Consultancy (UOM is changed to Day) * Quantity = 3 * Project = My Project 10) Go back to expense sheet header and Process it. 11) Report project profitability selecting My Project (Project & Service Management || Analysis Tools || Project Profitability) * Real Cost = 60 €/hour x 3 Days = 180 €xDays/hour when it should be Real Cost = 60 €/hour x 3 Days x 8 hours/day = 1140 € 12) Report expenses selecting My Project (Project & Service Management || Analysis Tools || Expense Report) * Employee hours = 3 (180,00) when it should be 3 Days x 8 hours/day (3 Days x 8 hours/day x 60 €/hour) = 24 hours (1140 €) * Product hours = 3 (180,00) when it should be 3 Days x 8 hours/day (3 Days x 8 hours/day x 60 €/hour) = 24 hours (1140 €) | |||||||
| Proposed Solution | 1) In Project & Service Management || Transactions || Expense Sheet || Header >> Lines make UOM field read-only since secondary UOM is not supported there (see feature request 0010689). 2) Time (expense) sheet lines are always reported with the product UOM (days, weeks, ...). 3) Project profitability and expense reports require hours: * if there is not a conversion between the reported time UOM and hours, when executing those reports an error message is displayed informing that there should be an UOM conversion defined from the UOM to hours. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0032206) hgbot (developer) 2010-10-26 09:37 |
Repository: erp/devel/pi Changeset: 0f75f9ed2c728784e29852401f4d11f7b256d393 Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Tue Oct 26 13:06:52 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/0f75f9ed2c728784e29852401f4d11f7b256d393 [^] Fixes Issue 10690: Expense Report and Project Profitability Reports display hours even if time sheet lines are in days --- M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src/org/openbravo/erpCommon/ad_reports/ReportExpense.java M src/org/openbravo/erpCommon/ad_reports/ReportExpense_data.xsql M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql --- |
|
(0032207) harikrishnan (reporter) 2010-10-26 09:38 |
Steps to test: *Follow the steps to test. Root Cause: *Before the days are not properly converted in to the hours UOM.Since these two fields deals with the hours,so we need hours UOM to the output.If this conversion rate is not defined then we have to throw a error. Impact: Only it ll affect these two reports.They are tested well. |
|
(0032227) hgbot (developer) 2010-10-26 16:25 |
Repository: erp/devel/pi Changeset: 21ce762194211fdbf531a0ca5b6ae5c3a59d13f0 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue Oct 26 16:24:46 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/21ce762194211fdbf531a0ca5b6ae5c3a59d13f0 [^] Fixes Issue 10690: Expense Report and Project Profitability Reports display hours even if time sheet lines are in days Fixed typo --- M src-db/database/sourcedata/AD_MESSAGE.xml --- |
|
(0032414) hudsonbot (developer) 2010-11-05 12:44 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/0f75f9ed2c72 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^] |
|
(0032418) hudsonbot (developer) 2010-11-05 12:44 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/21ce76219421 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-22 11:56 | rafaroda | New Issue | |
| 2009-09-22 11:56 | rafaroda | Assigned To | => rafaroda |
| 2009-09-22 12:00 | rafaroda | Relationship added | related to 0010689 |
| 2009-09-29 22:59 | psarobe | Status | new => scheduled |
| 2009-09-29 22:59 | psarobe | fix_in_branch | => pi |
| 2010-02-11 18:05 | rafaroda | Assigned To | rafaroda => adrianromero |
| 2010-08-24 22:50 | fgredruello | Issue Monitored: fgredruello | |
| 2010-10-25 12:41 | harikrishnan | Assigned To | adrianromero => harikrishnan |
| 2010-10-26 09:37 | hgbot | Checkin | |
| 2010-10-26 09:37 | hgbot | Note Added: 0032206 | |
| 2010-10-26 09:37 | hgbot | Status | scheduled => resolved |
| 2010-10-26 09:37 | hgbot | Resolution | open => fixed |
| 2010-10-26 09:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0f75f9ed2c728784e29852401f4d11f7b256d393 [^] |
| 2010-10-26 09:38 | harikrishnan | Note Added: 0032207 | |
| 2010-10-26 16:25 | hgbot | Checkin | |
| 2010-10-26 16:25 | hgbot | Note Added: 0032227 | |
| 2010-10-26 16:25 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/0f75f9ed2c728784e29852401f4d11f7b256d393 [^] => http://code.openbravo.com/erp/devel/pi/rev/21ce762194211fdbf531a0ca5b6ae5c3a59d13f0 [^] |
| 2010-11-05 12:44 | hudsonbot | Checkin | |
| 2010-11-05 12:44 | hudsonbot | Note Added: 0032414 | |
| 2010-11-05 12:44 | hudsonbot | Checkin | |
| 2010-11-05 12:44 | hudsonbot | Note Added: 0032418 | |
| 2010-12-27 12:22 | psarobe | Status | resolved => closed |
| 2010-12-28 00:00 | anonymous | sf_bug_id | 0 => 3146614 |
| 2011-01-12 09:51 | psarobe | Assigned To | harikrishnan => adrianromero |
| 2011-01-12 09:51 | psarobe | Status | closed => new |
| 2011-01-12 09:51 | psarobe | Resolution | fixed => open |
| 2011-01-12 12:33 | psarobe | Status | new => scheduled |
| 2011-01-12 12:34 | psarobe | Status | scheduled => resolved |
| 2011-01-12 12:34 | psarobe | Resolution | open => fixed |
| 2011-01-12 12:34 | psarobe | Status | resolved => closed |
| 2011-01-13 18:31 | adrianromero | Relationship added | related to 0015631 |
| 2011-01-13 18:33 | adrianromero | Relationship added | related to 0015630 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |