Sage Intacct allows some fields to be blank that Arcoro requires. When a Business Unit, Cost Code, Department, or Union-type record comes out of Sage Intacct without a Name or an ID, Arcoro cannot build a usable record, so it skips that single record and keeps going with the rest.
On the General Ledger side, Arcoro is sending payroll data into Sage Intacct as a journal entry. A journal entry needs an account on every line, a payroll date, and at least two line items to balance. If any one of those is missing, Arcoro will not create the journal entry in Sage Intacct at all, even if only one line item has the problem.
Error Messages
| Message text | Direction | Occurs when | Outcome | Fix |
|---|---|---|---|---|
| A [record type] with ID: '[record Id]' does not have a Name. This field is required and the record will not be Synced. Modify the data to make each record have a unique Name and execute the Sync again. | Read (Sage Intacct into Arcoro) | The record's Name field is null, empty, or whitespace only. | That one record is skipped. Every other record of the same type continues to sync normally. | In Sage Intacct, open the record shown by its Id in the message and enter a Name. |
| A [record type] with Name: '[record Name]' does not have an ID. This field is required and the record will not be Synced. Modify the data to make each record have a unique Id and execute the Sync again. | Read (Sage Intacct into Arcoro) | The record's ID field is null, empty, or whitespace only. | That one record is skipped. Every other record of the same type continues to sync normally. | In Sage Intacct, open the record shown by its Name in the message and enter or correct its Id. |
| Account is required. Correct the data in the Source System and execute the Sync again. | Write (Arcoro out to Sage Intacct) | A General Ledger line item has no Account Number set. | The entire journal entry is not created in Sage Intacct. One line item with a missing account blocks the whole payroll journal, not just that line. | In Arcoro, correct the GL account mapping so every line item on the payroll journal has an account number, then rerun the sync. |
| Payroll Date is Required. | Write (Arcoro out to Sage Intacct) | The payroll journal record being synced has no Payroll Date. | The entire journal entry is not created in Sage Intacct. This check runs before Sage Intacct is even queried, so no line items are evaluated either. | In Arcoro, confirm the payroll run being synced has a Payroll Date set, then rerun the sync. |
| At least two line items are required when syncing a journal entry. | Write (Arcoro out to Sage Intacct) | The payroll journal record being synced has no line items, or only one. | The entire journal entry is not created in Sage Intacct. This check runs before Sage Intacct is even queried, so no line items are evaluated either. | In Arcoro, confirm the payroll run selected for this sync produced at least two balanced line items, then rerun the sync. |
Note: The phrase "Source System" in the Account message refers to Arcoro, not Sage Intacct, because this message fires in the write direction. This is the opposite of the two read-side messages above it, where the fix is always in Sage Intacct. Always check the Direction column.
Note: "Payroll Date is Required." is a short, generic sentence. There is a separate, unused resource string with nearly identical wording ("Payroll Date is required.", lower-case "required") that has no active code path and should never be referenced in a ticket. Match on the exact casing "Payroll Date is Required." with a capital R, and confirm the record is a General Ledger sync before treating it as this message.
Record Types That Can Appear in the Two Generic Messages
| Record type as it appears in the message | Message it can produce | Where you can fix it |
|---|---|---|
| Sage Intacct Location/Arcoro Entity (this is Arcoro's Business Unit entity; Sage Intacct's Location dimension record) | Name required | Sage Intacct, on the Location record shown by its ID in the message |
| Cost Code (Sage Intacct's Task record under a Project) | Name required, ID required | Sage Intacct, on the Task record under the Project shown in the message |
| Department | Id required | Sage Intacct, on the Department record shown by its Name in the message |
| Union (labor union user-defined list) | Name required | Sage Intacct, in the user-defined list configured for Labor Unions |
| Union Local (labor union local user-defined list) | Name required | Sage Intacct, in the user-defined list configured for Labor Union Locals |
| Union Class (labor union class user-defined list) | Name required | Sage Intacct, in the user-defined list configured for Labor Union Classes |
Business Unit is the only record type where the message text does not use the word "Business Unit." It literally reads "Sage Intacct Location/Arcoro Entity."
Confirming the Error
- Open the sync execution for the run in question
- Find the step for the Sage Intacct connector in that execution.
- For a read-side message, open the row for the entity named in the message (Business Unit, Cost Code, Department, Union, Union Local, or Union Class). For a General Ledger message, open the General Ledger entity row.
- Check the Errors, Warnings, Information, Failures, Added, Updated, and Unchanged columns for that row. A read-side required-field message shows as an Error on that entity row, with the record still counted toward Failures rather than Added or Updated.
- Open the errors list for that entity row and match on the fixed part of the sentence, for example "does not have a Name" or "Account is required," not on the quoted ID, Name, or Account value, since those vary per record.
- Read the record type out of the message (the word before "with ID" or "with Name") to know which record in Sage Intacct to open next.
Resolving the Error
Name is Required (GenericNameRequiredError)
- Read the record type and ID out of the message.
- Use the record type table above to find which Sage Intacct record and list it points to.
- In Sage Intacct, open that record by its ID and enter a Name.
- Save the record in Sage Intacct.
- Rerun the sync and confirm the entity row no longer lists that record under Errors.
ID is Required (GenericIdRequiredError)
- Read the record type and Name out of the message.
- Use the record type table above to find which Sage Intacct record the list points to.
- In Sage Intacct, open that record by its Name and enter or correct its ID.
- Save the record in Sage Intacct.
- Rerun the sync and confirm the entity row no longer lists that record under Errors.
Account is Required (GeneralLedgerAccountNullError)
- Confirm this is a General Ledger sync and the error is on the General Ledger entity row, not a read-side entity row.
- In Arcoro, review the payroll run being synced and check the GL account mapping for every pay type, deduction, or other item feeding that line.
- Fill in the missing account mapping in Arcoro.
- Rerun the sync and confirm the General Ledger entity row shows the journal entry as Added rather than a Failure.
Payroll Date is Required (GeneralLedgerPayrollDateRequiredError)
- Confirm this is a General Ledger sync and the error is on the General Ledger entity row.
- In Arcoro, confirm the payroll run selected for this sync has a Payroll Date set.
- Correct the payroll run in Arcoro if the date is missing.
- Rerun the sync and confirm the General Ledger entity row shows the journal entry as Added rather than a Failure.
At Least Two Line Items Are Required (GeneralLedgerJournalMinimumLineItemsError)
- Confirm this is a General Ledger sync and the error is on the General Ledger entity row.
- In Arcoro, confirm the payroll run selected for this sync produced at least two line items that together balance as debits and credits.
- If the payroll run should have two or more lines but does not, treat this as a data issue in the payroll run rather than a connector problem.
- Rerun the sync and confirm the General Ledger entity row shows the journal entry as Added rather than a Failure.
When to Escalate
If any of the following occur, you may need to reach out to Arcoro support for additional assistance.
- The record in Sage Intacct already has a Name or ID filled in, matches the record type table above, and the same error still appears after a rerun.
- The General Ledger account mapping in Arcoro looks complete for every line item on the payroll run, but Account is required still fires.
- The payroll run in Arcoro clearly has a Payroll Date and two or more line items, but the General Ledger message still fires.
- You cannot tell from the record type table above which Sage Intacct record the message refers to.