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
- Open Excel template and enter proper data.
- Click button Save Data.
- Excel Add-in may throw error "No time agreement exists for employee".
Cause
You might have added extra space in the excel file or while creating employee you might have 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 of the possible reason for this error could be space before/after the employee ID #xyz# and it may be stored as such in the backend of the system.
To cross check whether the space exist before/after the employee ID, please search with the Employee ID in the Employee Personal Administration or Employee Time file, if the search didn't work try to put the *xyz * to find the employee, this will confirm you, that there is space exist before or after the Employee ID.
Accordingly do the changes to the excel file and perform the Time recording update.
See Also
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