Symptom
You have one employee that you have noticed one accrual that seems to be incorrect.
In most cases when you have wrong accruals you can easily reproduce it by using the Time Account Process Simulator(For more details, check KBA:2479225) together with the Business Rule Execution Log (For more details, check KBA:2257064).
However when your accrual rule uses the function Cap Accrual then this approach may not be effective.
Below you can see a method to troubleshoot the postings to help you determining the reason for the result.
Environment
- SAP SuccessFactors Employee Central (EC) - All Versions;
- SAP SuccessFactors Employee Central (EC) - Time Off;
Resolution
To explain this method, let's consider the following scenario for the Cap Accrual function:
- Maximum Accrual: 2.25;
- Account Balance: (the below method will explain how to calculate it manually);
- Account Balance Limit: 27;
How to troubleshoot the calculation:
- First of all you need to export the postings of the employee and you do this by following these steps:
- Go to the employee where the accrual is incorrect;
- Click in Administer Time > Time Accounts;
- In the Account Postings session, you can download all the postings;
- The result will be one CSV file and in the CSV you can order by Created On (see example below);
- Now, with this information in hands you are able to calculate the balance manually the most important here is to ignore the columns "Balance Before" and "Balance After" those values are calculated automatically and wont be effective here. The field that we will use to calculate this is the amount (see example below) so you can delete these current columns and add two new columns (will name them as "Manual Balance Before" and "Manual Balance After"):
- For the manual calculation, you will always use the amount and then calculate your own Manual Balance "Before" and "After", for this scenario the first row receives 2.25 in balance "before" and "after" (cause there are no amounts posted before this row);
- After this point then you just need to always fill the Manual Balance Before for the current rows in the following way See the example below:
- Manual Balance Before = Manual Balance After(previous row);
- Manual Balance After = Manual Balance Before (current Row) + Amount (current Row);
- In case any of your Manual Balances After results in a number greater than the Account Balance Limit, then in the next row need to manually add the balance limit in the column "Manual Balance Before" see the example below:
- Following the 6 steps above and repeating it for every row you should be able to build a table like this:
Note that all the accrual posted were 2.25 with exception of March 31st which was 1. In this case if you look to the balance before (26) and compare with the Account Balance Limit (27) it would explain the reason why on that date the posting was only 1 day.
Keywords
troubleshooting cap accrual troubleshooting accruals wrong accrual with cap accrual function , KBA , LOD-SF-EC-TIM , Time Off , How To