Symptom
This case document contains two issues with respect to Revenue by Team Member Report.
Case 1: All the Projects available in the system will not be shown in the Revenue by Team Member report.
When you open the Revenue by Team Member report here you will be able to see all the Projects available in the system will not be shown in this report.
Case 2: Team Member" - unassigned (#) in the Revenue by Team Member report.
When you open the Revenue by Team Member report you will be able see the Team Member does not show the Expenses, Team Member" does not display any data for the key figure "Net Value - Invoiced Time and Expenses" and the characteristic "Team Member" - unassigned (#) in this report.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Work Center Project Management.
- Go to View Reports -> List.
- Select the report Revenue by Team Member.
- Here you can all the Projects available in the system will not be shown in the Revenue by Team Member report.
This can be verified from Project Management work center you can see all the listed projects.
- Go to Project management work center.
- Click on Projects view.
- Select All Project in show field and click GO.
- Here, you can see numerous projects listed.
Case 2:
- Go to Work Center Project Management.
- Go to View Reports -> List.
- Select the report Revenue by Team Member.
- Run the report and move the characteristics Invoice request ID and Invoice request item to rows.
- Here you can see Team Member does not display any data for the key figure Net Value - Invoiced Time and Expenses and the characteristic Team Member - unassigned (#) in the Revenue by Team Member report with Invoice request items with Invoicing Method Fixed Price are not displayed.
Cause
Case 1 :
This Revenue by Team Member Report (PROCPIU03_Q0001) shows only those Projects which are linked to Sales Orders that are Released.
Case 2 :
The Revenue by Team Member Report ( PROCPIU03_Q0001) does not show the expenses which are linked to Fixed Price Items because it is not possible to determine the revenue per employee for a fixed price appropriately it will only show data related to project tasks which are linked to Sales order items which are of type Time and Material hence it is displaying the key figure "Net Value - Invoiced Time and Expenses - 0.00" and the characteristic "Team Member" - unassigned (#).
Revenue by Team Member is to be able to check estimated revenue per team member based on the expenses , time recordings, expense reports incurred or actuals by the team member. We can determine the revenue based on the quantity in case of time recordings and amounts in case of expense reports. This is possible for time and materials items, because the basis for time and material items is the actuals. However, for fixed price items we have no appropriate mechanism to determine the estimated revenue per team member, because we do not associate actuals with fixed price items and without actuals, it is not possible to determine estimated revenue.
For fixed price items it is not possible for us to calculate the estimated Revenue per team member. Hence it is not possible for us to show the Expenses which might have been linked to Fixed Price Items, since you are going to invoices a fixed price and not the Incurred or Actuals.
Resolution
System is working fine as this is designed behavior. This is the current functionality in the report Revenue by Team Member Report (PROCPIU03_Q0001).
Keywords
KBA , AP-PRO , Project Processing , How To