When using the Sage 100 or 300 CRE integration, you may encounter an error message when syncing like below:
Write to Sage 100/300 CRE - Duplicate employees found in Sage 100/300 CRE matching on SSN. The Sync requires that Sage 300 CRE contain a single employee matching and the employee will not be synced.
What This Error Means
When this error appears in your sync log, it means one of the following conditions exists:
- Duplicate Employee Record in HH2 - There are two or more employee records in the HH2 database that share the same Social Security Number (SSN). The integration cannot determine which record is correct and stops the sync for that employee.
- Employee ID Casing Mismatch - The Employee ID in HH2 does not exactly match the Employee ID in CoreHR. This is case-sensitive — for example, "EMP001" and "emp001" are treated as different records. Even a single lowercase letter will cause the sync to fail for that employee.
How to Resolve This Error
Follow the steps below to identify and deactivate the duplicate record in HH2, then re-run your data sync:
- Log in to the Arcoro platform and navigate to the Integrations module.
- Click on Connectors from the left-hand navigation menu.
- Locate the connector for your Sage 100/300 CRE connection and click the edit pencil icon.
- Copy the HH2 Service URL shown in the connector settings and paste it into your web browser.
- Log in to the HH2 cloud site using the username and password displayed in the Sage 100/300 connector settings.
- Once logged into HH2, click on Employee Setup, found under the Your Company’s Data section.
- Use the employee search menu to locate the duplicate record. You can search by first name, last name, or employee ID.
-
Click on the employee record. A detail screen will appear with an Active checkbox. Review the status:
- Checkbox is checked (enabled): The record is active and will be included in the sync.
- Checkbox is unchecked (disabled): The record is already inactive and will be ignored by the integration.
- Important: Employee records cannot be deleted from HH2. Deactivating is the correct resolution.
-
If the record is a duplicate that needs to be excluded, uncheck the Active checkbox. The system saves automatically. Keep the following in mind:
- If you receive a save error, it may be because the email address on the duplicate record matches another record. Remove the email address from the duplicate record entirely, then save again.
- You will know the change saved successfully when a green checkmark appears next to the field you updated.
- Once the duplicate record has been deactivated in HH2, return to the Arcoro Integrations module and re-run your data sync.
Confirming the Issue is Resolved
After re-running the sync, navigate back to your sync log. The error for the affected employee should no longer appear, and the employee record should sync successfully to Sage 100/300 CRE.
Employee ID matching is case-sensitive. If the issue is a casing mismatch rather than a duplicate record, coordination between HH2 & Arcoro will be needed to ensure the Employee ID in HH2 exactly matches the Employee ID in CoreHR (including uppercase and lowercase letters).
If you are unsure which record is the duplicate, compare the employee details (hire date, status, department) in both HH2 and CoreHR to determine which record is the primary, active record.
Still Need Help?
If the issue persists after following these steps, please contact Arcoro Support with the following information:
- A screenshot of the sync log showing the error message
- The full name and employee ID of the affected employee(s)
- The name of the Sage 100/300 CRE connector in your Arcoro integrations module
- Confirmation of which steps above have already been attempted