SAP Knowledge Base Article - Public

3403965 - Error: 'No Time Agreement Exists for Employee' When Trying to Upload Time Recordings via Excel Add-In

Symptom

You are trying upload the Employee Time recordings via Excel Add-In, however you get the error message as "No time agreement exists for employee"

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Time Administration work center
  2. Go to Employees view
  3. Click on Actions - Record Employee Times from Microsoft Excel
  4. Open Excel template and enter the mandatory data
  5. Click on Save Data 
  6. Excel Add-in may throw error "No time agreement exists for employee"

Cause

There may be some extra space in the excel file or when creating the employee, you might have accidentally added extra spaces to the Employee ID.

Ex: Employee ID might be in excel is xyz and Employee ID might be in the system is xyz# Or tis could be Other way around.

Note: abc referred as Employee ID & # referred as space.

Resolution

One reason for this error could be the presence of a space before or after the employee ID #xyz#, which may be stored as such in the backend of the system. To verify if there is a space before or after the employee ID, please search for the Employee ID in the Employee Personal Administration or Employee Time file. If the search does not work, try using *xyz* to find the employee. This will confirm whether there is a space before or after the Employee ID. Once confirmed, make the necessary changes to the excel file and update the Time recording accordingly.

See Also

1404035 - Error 'No time agreement exists for employee' When Trying to Save Time Recordings via Excel Add-in for a Project 

Keywords

Excel Add-in, Time Agreement, Time Recording, Time Recording via Excel, No Time Agreement, SRD-HR-TLM, BYD, Excel, Excel Upload of Time, No time agreement exists for employee, Employee Time Recording. , KBA , SRD-HR-TLM , Time and Labour Management , Problem

Product

SAP Business ByDesign 2305 ; SAP Business ByDesign 2408 ; SAP Business ByDesign 2411