SAP Knowledge Base Article - Public

2547545 - Incorrect Time Account Balance - Advanced Reporting

Symptom

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

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Cause

  • 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

Resolution

The report is not configured properly - Consider the following items when creating the report

  • Date options of all tables
  • Filters on account type, employee status, pay component, booking type, etc

 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
    portlet.png
    portlet2.png
  2. Go to Admin Center > Export Data > Select Generic Object "Time Account" > Click on Export button

    export data.png
  3. Go to Monitor Job page to download the file
    monitor jobs.png
  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)
    zip.png
  5. Filter by userid and copy the external code of the account type
    time account.png
  6. Now open the Time Account-Time Account Details.csv, filter by the external code and sum the "timeAccountDetails.bookingAmount" column
    details.png
  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 future 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

See Also

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

Keywords

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, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors Workforce Analytics all versions