ACA Companion - Fix Employee Sync Errors

This article provides solutions to common errors encountered during the ACA Companion Application employee migration process that syncs employees from the core application to the ACA Companion. This migration process will try to sync every employee record in the core application with a valid SSN and create a record for them in the ACA Companion. 

Key Takeaways

• Solutions to common Employee sync errors
• List of Reports/AQs to find and correct errors
• Correcting and updating Employee errors
• Import file for mass updates

CHAPTERS

Demo Video
Fix Errors Caused by Duplicate Social Security Numbers
    Run the ACA Companion Employee Sync Error Advanced Query
    Make changes to Employee Records
    Import the updated spreadsheet
Troubleshooting
Fix Errors Caused by Multiple or Missing Primary Addresses
    Run the ACA Companion Employee Sync Primary Address Error Advanced Query
    Make changes to Employee Records

Demo Video

This video demonstrates how to resolve migration errors when synchronizing ACA data.

Fix Errors Caused by Duplicate Social Security Numbers

Run the ACA Companion Employee Sync Error Advanced Query

This section describes the process of finding the employee records that are causing the errors and exporting them to an Excel spreadsheet.

1. Click Reports in the Avionté application Main Menu.
   
   
2. Click on ACA Companion Employee Sync Error in the list of reports.
   
   
3. Select the desired lookup criteria. All Employees will show results for all employees in the system. To show only results for a specific year, select Paycheck Year for the LookUp Criteria, and then enter the desired year. 
   
   
   
   
4. Click Run Query.
   
   
   
   
5. Click the Options tab.
   
   
   
   
6. Click Export to Excel.
   
   
   
   
7. Navigate to the desired location and save the file.

Make changes to Employee Records

This section describes the actions required to change the employee records.

There are three columns in the spreadsheet that will be used to identify and fix the errors.

1. Use Excel or another spreadsheet application to open the file that was saved in the previous section.
   
   

2. Locate records that share a Group ID number.

    

   

3. Choose the row that will be the primary record for the employee. The primary record will overwrite all other records with this SSN during the employee migration process.
   
   
4. Update the primary record with the most current and accurate employee information.
   
   
5. Repeat these actions for all records in the report.
   
   
6. Save the updated Excel file.

Import the updated spreadsheet

This section describes the process of importing the updated spreadsheet back into Avionté.

1. Click Import Export in the Avionté application Main Menu.
   
   
2. Click on the Actions menu.
   
   
   
   
3. Select Import Export Batch Wizard. The Import Export Batch wizard will display.
   
   
   
   
4. In the Description field, enter a brief description, e.g., ACA Correction.
   
   
5. From the Mapping Group drop-down menu, select the first entry that appears in the drop-down menu.  (The query requires that an option be chosen from this menu, but the actual mapping group selected has no effect on the outcome of the process).
   
   
6. From the Processing Method drop-down menu, select ACA Employee Sync Error Import.
   
   
7. Click the Browse button.
   
   
8. Navigate to the update Excel spreadsheet and click Open.
   
   
9. Verify that Worksheet Contains Column Names in First Row is checked.
   
   
10. Click Finish to save the settings and close the Import Export Batch wizard.
    
    
11. Click Process Import Export Batch.
    
    
    
    
12. The system will display any errors discovered in the content of the spreadsheet. Resolve any errors and repeat steps 1 to 10 above. If errors are encountered, they must be resolved and the preceding steps must be repeated before continuing to the next step. 
    
    
13. Once all errors have been resolved, click Process Batch to import the data from the spreadsheet.
    
    
    
    

Troubleshooting

The table below contains common error messages, their causes, and instruction for how to resolve them.

Fix Errors Caused by Multiple or Missing Primary Addresses

Run the ACA Companion Employee Sync Primary Address Error Advanced Query

This section describes the process of finding the employee records that are causing the errors.

1. Click Reports in the Avionté application Main Menu.
   
   
2. Click on ACA Companion Employee Sync Primary Address Error in the list of reports.
   
   

3. Click Run Query.

    

   

    

Make changes to Employee Records

This section describes the actions required to change the employee records.

1. The ErrorMessage column shows the cause of the error for each record in the report.

    
   
   

2. Choose a row to edit, noting the error message.
   
   
3. Double-click on the row. This opens the employee record.
   
   
4. Update the employee's record with the required changes indicated in the error message.
   
   
5. Repeat these actions for each row in the report.