0010690: Expense Report and Project Profitability Reports display hours even if time sheet lines are in days

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0010690

Openbravo ERP

08. Project and service management

public

2009-09-22 11:56

2011-01-12 12:34

Reporter

rafaroda

Assigned To

adrianromero

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

rPath Linux

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Additional Information

Tags

No tags attached.

Relationships

related to	feature request	0010689		new	rmorley	Expense Sheet Lines do not support secondary UOM
related to	backport	0015631	2.50MP26	closed	adrianromero	Project profitability report is not working under some circumstances
related to	defect	0015630	2.50MP26	closed	adrianromero	Project profitability report is not working under some circumstances