3584139 - Incorrect Actual Work Value Listed in Project Time Recordings Report

You are using the Project Time Recordings standard report, and notice that the Actual Work  value for a time recording is showing a different value than the expected.

SAP Business ByDesign

1. Go to the Business Analytics work center.
2. Enter the Design Reports view.
3. Search for the report Project Time Recordings.
4. Click on the report to open it.
5. Execute the report according to the desired criteria.

Here it is possible to see that the Actual Work field is showing a small difference from the time recorded by the employee.

The behavior may happen due to a quantity conversion for the service of the project task.

As an example, we will define a service as X, which has the base unit of measure defined as Hours, and has a quantity conversion defining that 8 Hours are equivalent to 1 Working Day. The service is set in the project task in Working Days.

When an employee records time for a service, the time will be defined by Hours. When the time confirmation is displayed in the project history, it is converted from Hours to the project unit of Working Days.

When working with the Project Recorded Times report, the service unit of the project task is converted back to the standard time unit. In this case, the Working Days value is converted to Hours.

A discrepancy in the values may occur when the converted unit of measure is not defined with enough decimals to accommodate the entire value converted from Hours. In such situations, the converted value is rounded (with values of 0.5 being rounded up). This causes the inverse conversion from the project to the report to be different than the conversion from the time recording to the project, hence resulting in different values.

As an example, we will take the same service, units of measure and conversions mentioned above.

An employee books 4.5 hours for service X. In the project, these hours are converted to 0.5625 Working Days (4.5 hours booked divided by 8 hours in each Working Day = 0.5625 Working Day booked).

In case the Working Day unit of measure is defined as only having 3 decimals, the value 0.5625 is rounded up to 0.563.

When the report is executed, the value is converted back from Working Day to Hours. This results in 4.504 hours (0.563 Working Day multiplied by 8 Hours in each Working Day).

This value is the one that will be shown in the report.

The system works as expected.

In order to check the definition of the units of measure involved, please follow the below steps:

1. Go to the Business Configuration work center.
2. Enter the Overview view.
3. Search for the activity Quantities and Units of Measure.
4. Click the activity name to open it.
5. Click on the sub-activity Create and Maintain Trading Units.
6. Search for the unit of measure which is being used in the project task.
7. In the Display Decimals column, it is possible to confirm the amount of decimals which will be supported in the value conversion.

TLM, Book, Time File, PROPRJU05 , KBA , SRD-HR-TLM , Time and Labour Management , Problem