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

SAP Knowledge Base Article - Public

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

Symptom

You, as a time administrator, try to upload employee's times by Excel file. You may encounter the following error:

Change of time agreement item not possible

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 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.

Excel throws the above error message.

Cause

If an excel upload for employee times has been processed successfully, the technical IDs(UUIDs) of these employee times are saved in hidden columns within the Excel file.

So Excel will not allow to save the time, if you use the same file for another employee’s time uploading.

Resolution

If you want to reuse the same file to upload other employee times, you have to remove the technical data in hidden columns before uploading again from this file.

However changing employee times that have been uploaded before is only possible within the system but not via Excel uploading anymore, except you keep a copy of the file with the same technical data as the one used in initial Excel uploading and upload it for employee times update.

Keywords

Change of time agreement item not possible, Upload Times Using Excel , KBA , SRD-CC , Cross Components , Product Enhancement

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP BUSINESS BYDESIGN 1802 ; SAP BUSINESS BYDESIGN 1808 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1805 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0