Issue
During a data sync from Core HR to Sage 300, you may encounter the following error:
"The Benefit with Deduction Code X has both pre and post tax cost for
the employee but the provider was unable to parse the pre/post Code correctly."
This error occurs when a benefit assigned to an employee in Core HR includes both a pre-tax deduction (e.g., for the employee) and a post-tax deduction (e.g., for a domestic partner), but the deduction codes in the benefit structure are not properly formatted for the sync.
Cause
The Core HR benefit structure requires separate deduction codes for pre-tax and post-tax amounts when both exist in a single benefit. These must be defined using the format:
PRETAXCODE|POSTTAXCODE
If this format is not used, Sage 300 cannot properly parse the deductions, resulting in a sync error.
Resolution
- Obtain the post-tax deduction ID from the client.
- The client should already have a post-tax deduction code configured in Sage 300 for this benefit plan or coverage level.
- Navigate to the benefit structure in Core HR:
- Go to Main Menu > Settings > Benefit Management.
- Click on the name of the current benefit package.
- Click the Configure Benefit Structure tab.
- Select the relevant benefit plan(s) that need updating.
- Click the Coverage Levels tab.
- Click on the appropriate coverage level.
- Update the deduction code fields:
- In the Deduction Code Alt 1 (used for employee deductions) and/or Deduction Code Alt 2 (used for company deductions/fringe):
- Enter the two deduction IDs, separated by a pipe symbol (|).
- Example: MEDPRETAX|MEDPOSTTAX
- In the Deduction Code Alt 1 (used for employee deductions) and/or Deduction Code Alt 2 (used for company deductions/fringe):
- Confirm setup with the client:
- Ensure the client intends to have both pre- and post-tax deductions reflected in both Deduction Code Alt 1 and Alt 2 as applicable.
- Save changes and rerun the data sync.
The error should now be resolved.
Additional Notes
- If the client does not yet have a post-tax deduction ID in Sage, they will need to create one before you can complete the setup.
- This formatting requirement applies to any benefit in Core HR where dual (pre/post) taxation applies.