Module Navigation

Troubleshooting Sage 300 Integration Error: Direct Deposit and Banking

Sage 300 CRE stores each direct deposit as a deduction record in HH2, matched to the employee by a Pay Deduction Code. Whether Arcoro is reading these deductions into Arcoro or writing them out from Arcoro to Sage 300 CRE, every direct deposit needs a matching Pay Deduction Code, a valid bank routing and account number, a supported calculation method, and a unique code per employee. When any one of those pieces is missing, unmatched, or invalid, the sync leaves that single direct deposit out rather than fail the whole employee record.

Error Messages

Message textDirectionOccurs whenOutcomeFix
Direct Deposit with HH2 Id: '[HH2 deduction Id]' does not have a bank account number associated with it and will not be synced. [underlying error, if any].Read (Sage 300 CRE into Arcoro)The employee has an active, non-archived Sage 300 CRE deduction of type Direct Deposit or Net Direct Deposit, but the bank account number lookup for that deduction came back empty or failed.Collection item skipped. This one direct deposit is left out; the employee and other direct deposits still read.In Sage 300 CRE, add or correct the bank account number on this deduction, then rerun the sync.
Direct Deposit with HH2 Id: '[HH2 deduction Id]' does not have a bank routing number associated with it and will not be synced. [underlying error, if any].Read (Sage 300 CRE into Arcoro)Same deduction filter as above, but the bank routing number lookup came back empty or failed.Collection item skipped.In Sage 300 CRE, add or correct the bank routing number on this deduction, then rerun the sync.
Direct Deposit with Code: '[pay deduction code]' and HH2 Id: '[HH2 deduction Id]' has an unsupported Calculation Method of '[calculation method]' and will not be processed. The Sage 300 CRE provider supports the following Calculation Methods: Default, Flat Amount and Net Pay.Read (Sage 300 CRE into Arcoro)The deduction's effective calculation method (its own method, or the Pay Deduction Code's method when the deduction is set to Default; always treated as Net Pay for a Net Direct Deposit type) is something other than Default, Flat Amount, or Net Pay.Collection item skipped.In Sage 300 CRE, change the deduction's or Pay Deduction Code's Calculation Method to Default, Flat Amount, or Net Pay, then rerun the sync.
The matching Direct Deposit Code '[direct deposit code]' found in HH2 has IsArchived = true and cannot be updated by the Sync. To Sync this data contact support to set IsArchived = false and rerun the Sync.Write (Arcoro out to Sage 300 CRE)Arcoro is sending a direct deposit whose matching Sage 300 CRE deduction (matched on Pay Deduction Code and employee) already exists in HH2 with IsArchived set to true.Collection item skipped. Logged as an Error even though the message name says Warning.Contact support to have the deduction's IsArchived flag set to false in HH2, then rerun the sync.
More than one active record was sent from the source system with Direct Deposit Code '[direct deposit code]'. Duplicate direct deposits will not be synced. Please ensure there is only one direct deposit with Code '[direct deposit code]' in the source system, then execute the Sync again.Write (Arcoro out to Sage 300 CRE)Among the direct deposits Arcoro is sending for the employee, more than one shares the same Code, each with a populated effective date before tomorrow, IsActive set to true, and today's date falling inside that record's effective-to-expiration window (open-ended on either side if that date is blank).Collection item skipped for every record with that Code, not only the extras. None of the direct deposits sharing that duplicate Code are synced this run.In the source system, remove or deactivate the extra records so only one direct deposit exists for that Code, then rerun the sync.
One or more Direct Deposit records sent from the source system does not have a Code. Sage 300 CRE requires this property and these items will not be synced.Write (Arcoro out to Sage 300 CRE)A direct deposit record sent from the source system has a blank or missing Code.Collection item skipped. Logged as an Error even though the message name says Warning.In the source system, add a Code value to the direct deposit record, then rerun the sync.
The Direct Deposit record has an empty Bank Routing or Account Number. Sage 300 CRE requires these properties and the provider can not sync this record. Correct the data in the source system and run the Sync again.Write (Arcoro out to Sage 300 CRE)The direct deposit record's Routing Number field or Account Number field, as sent from the source system, is blank.Collection item skipped.In the source system, enter both the Routing Number and Account Number for the record, then rerun the sync.
The Direct Deposit record does not include a flat or percentage amount for the Direct Deposit. A valid Sage 300 CRE Direct Deposit requires an Amount and the provider can not sync this record. Correct the data in the source system and run the Sync again.Write (Arcoro out to Sage 300 CRE)Neither a flat deposit amount nor a deposit percentage is set on the record.Collection item skipped.In the source system, enter either a flat amount or a percentage for the direct deposit, then rerun the sync.
The Direct Deposit code '[direct deposit code]' could not be matched with a valid Pay Deduction Code in HH2. The code must be an exact match, including any spaces and have a Type of NetDirectDeposit or DirectDeposit. The record will not be synced.Write (Arcoro out to Sage 300 CRE)No Pay Deduction Code in HH2 exactly matches the record's Code (including spacing) with a Type of Direct Deposit or Net Direct Deposit.Collection item skipped. Logged as an Error even though the message name says Warning.In Sage 300 CRE, create or correct a Pay Deduction Code that exactly matches the source Code and has the correct Type, or correct the Code in the source system to match an existing Pay Deduction Code. Then rerun the sync.
Source record for a Direct Deposit with Code '[direct deposit code]' does not include the required Bank RoutingNumber.Write (Arcoro out to Sage 300 CRE)The routing number was not carried through for this record and no matching deduction exists yet in Sage 300 CRE, so this is a brand-new direct deposit being created. This check only applies during creation.Collection item skipped. The new direct deposit is not created in Sage 300 CRE. Because this check only runs on creation, if the record already exists in Sage 300 CRE a later sync will not flag or block a routing number that goes missing afterward.In the source system, add the missing bank routing number, then rerun the sync so the direct deposit can be created.
Source record for a Direct Deposit with Code '[direct deposit code]' does not include the required Bank AccountNumber.Write (Arcoro out to Sage 300 CRE)Same as above, for the account number on a brand-new direct deposit being created.Collection item skipped. Same creation-only behavior as the routing number message above.In the source system, add the missing bank account number, then rerun the sync so the direct deposit can be created.

Confirming the Error

  1. Open the Sync History screen and find the sync execution for the date and time in question.
  2. Find the step for the Sage 300 CRE connector in that execution.
  3. Find the Employees entity row for that step. Direct deposits are read and written as part of the Employees entity, under the Direct Deposits scope, so they do not have a separate entity row of their own.
  4. Check the Errors, Warnings, Information, Failures, Added, Updated, and Unchanged columns for that row. Every message in this article is logged as an Error or a Warning, never a Failure.
  5. Open the errors or warnings list for that entity row and match on the fixed part of the sentence (for example, "does not have a bank account number associated with it"), not on the values inside quotes, since those values are specific to the employee and record.
  6. If the Failures count is non-zero for this employee, that is not caused by anything in this article. Treat it as a separate, more serious issue.

Resolving the Error

Bank Account or Routing Number Missing in Sage 300 CRE (Read)

  1. In Sage 300 CRE, open the employee's Direct Deposit deduction identified by the HH2 Id in the message.
  2. Add or correct the missing bank account number, bank routing number, or both.
  3. If the message includes trailing text after the Arcoro sentence, that text is the raw error returned by the lookup call and may point to a connection or data problem in Sage 300 CRE rather than a simple blank field.
  4. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

Unsupported Calculation Method (Read)

  1. In Sage 300 CRE, open the deduction or its Pay Deduction Code identified in the message.
  2. Change the Calculation Method to Default, Flat Amount, or Net Pay.
  3. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

Archived Direct Deposit Code (Write)

  1. Confirm that the direct deposit Code named in the message is the one they intend to keep using.
  2. Escalate to have the matching deduction's IsArchived flag set to false in HH2.
  3. Once IsArchived is false, rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

Duplicate Direct Deposit Code Sent From the Source System (Write)

  1. In the source system, find every direct deposit record with the Code named in the message.
  2. Confirm which records are currently active with an effective date on or before today and, if set, an expiration date on or after today.
  3. Remove or deactivate all but one of the matching records so the Code is unique for that employee.
  4. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

Missing Code on the Source Record (Write)

  1. In the source system, open the direct deposit record referenced by the error.
  2. Enter a Code value for the record.
  3. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

Missing Bank Routing or Account Number in the Source Record (Write)

  1. In the source system, open the direct deposit record identified by the Code in the message.
  2. Enter the missing Bank Routing Number, Bank Account Number, or both.
  3. If the message names a routing or account number specifically and the record is new (it does not exist yet in Sage 300 CRE), that field must be present before the record can be created at all.
  4. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list, and that it now appears as Added or Updated.

Missing Deposit Amount or Percentage (Write)

  1. In the source system, open the direct deposit record referenced by the error.
  2. Enter either a flat deposit amount or a deposit percentage.
  3. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

No Matching Pay Deduction Code in HH2 (Write)

  1. In Sage 300 CRE, check for a Pay Deduction Code that exactly matches the Code named in the message, including spacing, with a Type of DirectDeposit or NetDirectDeposit.
  2. If no such Pay Deduction Code exists, create one, or correct the Code in the source system to match an existing Pay Deduction Code.
  3. Rerun the sync and confirm the direct deposit no longer appears in the entity's errors list.

When to Escalate

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

  • The error still appears after the source or Sage 300 CRE data has been corrected and the sync has been rerun.
  • The message is the Archived Direct Deposit message. Un-archiving the deduction in HH2 is not a self-service action described in the code.
  • The log text does not match any message in the table above.
  • The Failures count for the employee is non-zero. This family never produces a Failure, so a non-zero Failures count points to a different problem.
  • The trailing text after a bank account or routing number read error looks like a raw exception message rather than plain Arcoro wording. That text is passed through from the lookup call and may indicate a connection problem with Sage 300 CRE rather than a data problem.
Was this article helpful?
0 out of 0 found this helpful