SAP Knowledge Base Article - Public

2582853 - How to report on Leave Balance excluding Accrual of Privileged Leave Entitlement for terminated users

Symptom

How to report on Leave Balance excluding Accrual of Privileged Leave Entitlement for terminated users

Environment

  • SuccessFactors HCM Core
  • Report Center
  • Advanced Repoting

Reproducing the Issue

User is terminated however the Leave Balance is calculated including Accrual Privileged Leave Entitlement after termination date.

  1. Go to Report Center or Analytics
  2. Run the Report on Leave Balance
  3. Result output is more that what expected / 

Cause

The user is terminated but he is still eligible to the Privileged Leave. Hence the system is adding all the Accrual after the termination Date

Resolution

  1. Go to Admin Center >
  2. Manage Time Off Structures >
  3. Time Account Type Eligibility Status >
  4. check if it is set to : Eligible = Yes
  5. If the Eligibility Status is set Eligible = Yes, 
  6. Contact the Employee Central Team to correct the status.

If the customer want to keep the same status but remove the additional "Accrual" fater the termionation date in the Leave Balance Report, Do the following:

  1. Go to the Report Center or Analytics
  2. Select the affected Report "Leave Balance" and Edit
  3. Select Employment Detail > Add "Last Worked Date" or "Terminated Date"
  4. Create a Calculated column with the condition below:
    If the bookingDate is "Less or Equal" to "Last Worked Date". THEN Value == bookingAmount ELSE Value== 0

See Screenshot below

Calculated Column.png

In the Pivot Query add the Calculated Column created in the Measures.

The output result will exlcude all accrual added after the termination date even though the terminated user is still eligible.

Pivot Query.png

 

Keywords

  • Leave balance excluding Accrual Privileged Leave Entitlement after termination date
  • Incorrect value for Leave Balance in Pivot Query
  • Wrong Calculated value in Advanced Reporting Leave Balance Report 
  • Advanced Reporting
  , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core 1711