Module Navigation

Troubleshooting Acumatica Integration Error: Tax Setup (Federal, State, Local)

These five messages all fire while Arcoro writes an employee record out to Acumatica. Two of them stop the whole employee from reaching Acumatica, because Acumatica will not accept payroll data for a person without a valid, active Work State Location. That same location is what drives which state withholds tax on the employee's pay inside Acumatica, which is why Work State Location problems are covered here rather than in the organization structure article. The other three messages only fire when Federal Taxes is included in the sync, and they only affect federal withholding fields; the rest of the employee record still syncs even when they appear.

Error Messages

Message textDirectionOccurs whenOutcomeFix
The Acumatica Provider could not map the provided Federal Filing Status '[federal filing status]'. The Employee and Payroll Employee records will still be synced. The federal Filing Status in Acumatica may no be correct.Write, Arcoro to AcumaticaThe Federal Taxes scope is included in the sync, and the employee's Federal Tax record has a Filing Status value the connector does not recognize (including a blank or unset status).Field skipped only. Federal Filing Status is left unset in Acumatica; the Employee and Payroll Employee records still sync.Correct the employee's Federal Filing Status in the source system to a supported value.
The Federal Tax record contains an unsupported property 'Federal Tax Override Amount'. The value will not be used. Other values will still be synced with Acumatica.Write, Arcoro to AcumaticaThe Federal Taxes scope is included in the sync, and the employee's Federal Tax record has a Federal Tax Override Amount greater than zero. A blank or zero amount does not trigger this message.Field skipped only. The override amount is not sent; every other Federal Tax value still syncs.Remove the Federal Tax Override Amount from the source record. Acumatica does not support it.
The Federal Tax record contains an unsupported property 'Federal Tax Override Percent'. The value will not be used. Other values will still be synced with Acumatica.Write, Arcoro to AcumaticaThe Federal Taxes scope is included in the sync, and the employee's Federal Tax record has a Federal Tax Override Percent greater than zero. A blank or zero percent does not trigger this message.Field skipped only. The override percent is not sent; every other Federal Tax value still syncs.Remove the Federal Tax Override Percent from the source record. Acumatica does not support it.
Work State: Location '[work state location code]' was not found or is inactive in Acumatica. The record will not be synced. To resolve this problem, you can either update the Work State Location in the source system to a valid value or add/enable it in Acumatica and then rerun the sync.Write, Arcoro to AcumaticaThe employee has a Work State Location value, but it does not match any active Location in Acumatica. This check runs for every employee write, regardless of which scopes are selected for the sync.Whole record skipped. Nothing for this employee is sent to Acumatica.Set the Work State Location to a valid, active value, either by correcting it in the source system or by adding or enabling it in Acumatica.
Work State: Location is required in Acumatica. The employee record will not be synced.Write, Arcoro to AcumaticaThe employee's Work State Location field is blank. This check also runs for every employee write, and it runs before the lookup above.Whole record skipped. Nothing for this employee is sent to Acumatica.Enter a Work State Location on the employee record in the source system.

Confirming the Error

  1. Open the sync execution in Sync History for the connector and run in question.
  2. Find the step for the Acumatica connector.
  3. Find the Employees entity row within that step.
  4. Check the Errors, Warnings, Information, Failures, Added, Updated, and Unchanged columns for that row to see whether this employee's row contributed to Errors.
  5. Open the errors list for the Employees entity row and match on the fixed part of the sentence, not on the values in quotes, since the quoted value changes per employee.

Three of the five messages in this article say other values will still be synced. An employee can show an error in the errors list and still be counted in Updated (or Added) for that same run. Do not assume an error means the employee did not sync at all; check the outcome column above for that specific message confirming nothing happened.

Resolving the Error

Federal Filing Status Not Mapped

  1. Open the employee's Federal Tax details in the source system.
  2. Check the Filing Status field. If it is blank or set to a value that is not a standard federal filing status, correct it.
  3. Rerun the sync for this employee and confirm the error is gone from the Employees entity errors list.

Federal Tax Override Amount or Override Percent Not Supported

  1. Open the employee's Federal Tax details in the source system.
  2. Check whether a Federal Tax Override Amount or Override Percent is set for this employee.
  3. Acumatica does not support this property today. It will keep appearing on every sync until the value is removed from the source record.
  4. If you need the override amount or percent applied in Acumatica, it must be entered directly in Acumatica; the connector will not carry it there.

Work State Location Not Found or Inactive

  1. Confirm the exact Work State Location value on the employee record in the source system.
  2. In Acumatica, check whether a Location with that code exists and is active.
  3. If the code does not exist or is inactive in Acumatica, either add or activate it there, or change the employee's Work State Location in the source system to a code that is already active in Acumatica.
  4. Rerun the sync and confirm the employee now appears in Added or Updated instead of Errors.

Work State Location Missing

  1. Open the employee record in the source system.
  2. Enter a Work State Location value for the employee.
  3. Rerun the sync and confirm the employee no longer appears in the Employees entity errors list.

When to Escalate

If any of the following occur, you may need to reach out to Arcoro support for additional assistance.

  • The two Federal Tax Override messages describe a capability the connector does not support. Escalating them is a product request, not a defect. The connector does not carry override amounts or percentages to Acumatica today.
  • Federal Filing Status keeps failing to map for a value that looks like a standard, valid filing status after you corrected it. This may mean the connector is missing a mapping for that value.
  • Work State Location errors appear for many or all employees in the same run, rather than one or two. This can point to a problem loading the list of active Locations from Acumatica before the sync ran, rather than a bad value on any one employee.
Was this article helpful?
0 out of 0 found this helpful