2547545 - Incorrect Time Account Balance - Advanced Reporting

• The report is showing the wrong balance value for some account types
• The Time Off portlet is showing different balance values than the reports

SAP SuccessFactors HXM Suite

• The report is not configured properly
• The data export of the Time Account object does not match the values available in the portlet, but it matches the value in the report

The report is not configured properly

Consider the following items when creating the report:

• Date options of the tables
• Filters on account type, employee status, pay component, booking type, etc.
• The Time Off portlet only displays active accounts. However, the report can show all accounts regardless the status.
  In this case, you need to apply a filter to get only active time accounts (e.g. mdfSystemStatus in A) 

The data export of the Time Account object does not match the values available in the portlet, but it matches the value in the report

Export the Time Off data and check the external code of the account type:

1. Check the balance available in the Time Off portlet
   
   
2. Go to Admin Center > Export Data > Select Generic Object "Time Account" > Click on Export button
   
   
3. Go to Monitor Job page to download the file
   
4. If you do not have the external code of the account type, open the Time Account.csv (if you already have, jump to step 6)
   
5. Filter by userid and copy the external code of the account type
   
6. Now open the Time Account-Time Account Details.csv, filter by the external code and sum the "timeAccountDetails.bookingAmount" column
   
7. Compare the sum of the "timeAccountDetails.bookingAmount" to the balance available in the Time Off portlet.
8. If they do not match, check if Simulate Accruals is set to 'Yes' on the time account type of the time account. If this is enabled, it is expected to see accruals as part of the account balance on Time Off, however, this would not be pulled by the report due to reporting product limitation. See 2377364 - Advanced Reporting - Time account - Time OFF with Simulated Accrual values - Limitation explained
9. If they match, you need to check the report configuration.

Please see EC Time Off Implementation guide for this expected behavior in report:

https://help.sap.com/viewer/8b4f98853bb44ed8a7ba1fdb0cc0ddeb/latest/en-US/67f62f498b1f40d396b87da2b894a6c5.html

2368375 - How to Set Up and Use Date Options in Advanced Reporting

Time Off Advanced Reporting report account type balance export data value time management incorrect different date EC not the same , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-EC , Employee Central , How To