Symptom
After uploading time recording via SAP ByD Excel Add-In, the actual hours are not updated in the respective project.
Environment
SAP Business ByDesign
Reproducing the Issue
- Open the Excel file for time recording upload
- Login into SAP Byd Excel Add in in MS Excel
- Enter the necessary time entries and details
- Select Save to
- Message shows records created successfully
- In SAP Business ByDesign, go to Project Management work center and open the Projects view
- Open the respective Project
- The hours are not available under actual hours field
Cause
Time entries uploaded from Excel are not showing on the project because they are not activated.
Errors can occur during activation for various reasons e.g. because a labor resource did not exist for the project time recording, or a purchase order could not be determined etc.
These errors can be seen by the administrator under Time Administration work center in the Employee Time Records view by selecting "Errors (Excel Upload)" from the dropdown.
Resolution
The process for uploading Project time recordings is as follows:
- Upload time entries via Excel where initial data validation on the times is performed.
- Once uploaded, activation of the times is done via a backend job, and if any error occurs, an error task is created for the administrator.
- The administrator can check on the Employee Time Records view by selecting "Errors (Excel Upload)" from the dropdown. From there, the administrator can correct and activate the time entries.
Please use the Employee Time Records view to see the errors for the times uploaded and correct via the time sheet.
Keywords
Time Recording via Excel, Time Sheet, Project Time Recording, Excel Upload, add in, project time , KBA , AP-TIM-TIM , Employee Time , Problem
SAP Knowledge Base Article - Public