Module Navigation

Troubleshooting Acumatica Integration Error: Direct Deposit and Banking

Acumatica has two strict rules for an employee's Direct Deposit records: exactly one active record must be marked with a Code of 'Gets Remainder', and no two active records can share the same bank account. When the Direct Deposit records coming from Arcoro break either rule, Acumatica will not accept the banking information for that employee. The rest of the employee's data can still sync normally; only the direct deposit records are held back until the source data in Arcoro is corrected.

Error Messages

Message textDirectionOccurs whenOutcomeFix
No active or valid Direct Deposit record sent from the source system has a Code = 'Gets Remainder' for this employee. Acumatica requires that one (and only one) Direct Deposit have this value. No Direct Deposit records will be synced for this employee. Correct the source data and run the sync again.Write, Arcoro to AcumaticaNone of the employee's active Direct Deposit records that have an account number, a routing number, and a recognized account type carry a Code of 'Gets Remainder'.Every Direct Deposit record for this employee is skipped for this sync run. The employee record and all other employee scopes still sync normally.In Arcoro, mark exactly one active direct deposit record for the employee with the 'Gets Remainder' code, then run the sync again.
More than one active Direct Deposit record sent from the source system has a Code = 'Gets Remainder' for this employee. Acumatica only supports a single Direct Deposit having this value. No Direct Deposit records will be synced for this employee. Correct the source data and run the sync again.Write, Arcoro to AcumaticaTwo or more of the employee's active Direct Deposit records that have an account number, a routing number, and a recognized account type carry a Code of 'Gets Remainder'.Every Direct Deposit record for this employee is skipped for this sync run. The employee record and all other employee scopes still sync normally.In Arcoro, remove the 'Gets Remainder' code from the extra record(s) so only one active direct deposit record for the employee carries it, then run the sync again.
Multiple Active Direct Deposit records for Account Number: [bank account number]. These records will not be processed. Verify that no duplicates exist in the source system and attempt the sync again.Write, Arcoro to AcumaticaTwo or more of the employee's active Direct Deposit records share the same routing number, account number, and account type.Only the duplicate records for that specific bank account are skipped. The employee record, and any other, non-duplicate Direct Deposit records for the employee, still sync normally. Exception: if removing the duplicates leaves the employee with zero, or more than one, active 'Gets Remainder' record, one of the two messages above will also occur, and in that case every Direct Deposit record for the employee is skipped instead.In Arcoro, remove the duplicate direct deposit record so only one active record exists for that bank account, then run the sync again.

Confirming the Error

  1. Open the sync execution for the run in question in the Arcoro sync history.
  2. Find the step for the Acumatica connector and open the Employees entity for that step.
  3. Check the entity row's Errors column. If it is greater than zero, open the row to see the individual employees.
  4. Find the employee reported. Note that this employee can still show up in the Updated column even though it also has a Direct Deposit error on the same row. That combination, employee updated but direct deposit still broken, is exactly what generates this type of ticket.
  5. Open the errors list for that employee and match on the fixed wording of the sentence, not on the bracketed account number or any other value that is filled in per employee.
  6. If more than one of the three messages appears for the same employee in the same run, resolve the 'Gets Remainder' count issue first, since it can override a partial fix to the duplicate account issue.

Resolving the Error

Missing or duplicate 'Gets Remainder' record

  1. In Arcoro, open the employee's direct deposit records.
  2. Confirm exactly one active record is marked with the 'Gets Remainder' code. Each of those active records must also have an account number, a routing number, and a valid account type for Acumatica to count it.
  3. If none are marked, mark one. If more than one is marked, remove the code from all but one.
  4. Save the change in Arcoro.

Duplicate Direct Deposit records for one account

  1. In Arcoro, open the employee's direct deposit records.
  2. Find the active records that share the same routing number, account number, and account type. The account number in the error message is masked to the last four digits, so match on those digits.
  3. Deactivate or delete the duplicate record so only one active record remains for that bank account.
  4. Save the change in Arcoro.

After correcting the source data, run the sync again. Confirm the fix by returning to the sync history for the new run and checking that the Errors count for the employee's Direct Deposits scope is back to zero.

When to Escalate

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

  • You confirm the direct deposit data in Arcoro already meets both rules, exactly one active 'Gets Remainder' record and no duplicate active accounts, but the error still appears after a new sync run.
  • The same error keeps appearing for a different employee each run, suggesting a broader data quality issue rather than a single employee record.
  • You cannot identify which direct deposit record is causing the error from the masked account number in the message.
Was this article helpful?
0 out of 0 found this helpful