Symptom
When try to upload employee's times by Excel file, the following error happens:
Change of time agreement item not possible
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Time Administration work center.
- Select the Time Recordings view and Time Sheet sub view.
- Highlight the respective employee and select the Actions button and choose the Upload Project Confirmations/Times from Microsoft Excel.
- Input the time data and save the data in the system through Excel.
- Clear the data in Excel file and enter new times for another employee in the same file and save the data.
- Excel throws the error message.
Cause
If an excel uploaded for employee times has been processed successfully, the technical IDs(UUIDs) of these employee times are saved in hidden columns within the Excel file.
If the same file is used for another employee’s time uploading, Excel will not allow to save the time as the UUID is ponited to another time entries.
Resolution
When reuse the same file to upload employee times, It is necessary to remove the technical data in hidden columns before uploading again from this file.
In addition, it is possible to change employee times with the same technical data as the one generated in the initial Excel uploading.
Keywords
Change of time agreement item not possible, Upload Times Using Excel , KBA , time administrator , change of time agreement item , SRD-HR-TLM , Time and Labour Management , Product Enhancement