SAP Knowledge Base Article - Public

1638028 - Error "Change of time agreement item not possible" While Uploading Times Using Excel

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

  1. Go to the Time Administration work center.
  2. Select the Time Recordings view and Time Sheet sub view.
  3. Highlight the respective employee and select the Actions button and choose the Upload Project Confirmations/Times from Microsoft Excel.
  4. Input the time data and save the data in the system through Excel.
  5. Clear the data in Excel file and enter new times for another employee in the same file and save the data.
  6. 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

Product

SAP Business ByDesign all versions