Intacct Export & Sync Errors

This article lists common error messages that may be returned when exporting to Intacct. You can view these errors on the Accounting Sync History Page via Company Settings > Accounting Sync History. 

Note: Bank Debit errors will not indicate the specific transaction within the batch that is causing the error.

Error: This company is not authorized for XML transactions. Please subscribe to the XML Gateway. 

Reason:

The error occurs when the Integration does not have the correct configuration for WebServices subscription.

Solution: 

1. Please follow the steps from this article: Setting up an Intacct Integration
2. Confirm web services are enabled and the user is a 'business' user with permissions set to 'full'
3. Confirm the Abacus user is scoped to have permissions only for the entity in question (For Role based permission, view/edit the user, and under the ENTITIES tab, edit and specify the entity that they would like to sync to)
4. For Corporate cards, you will need to ensure that you have the Corporate Card Expenses app enabled
5. If you are not subscribed to XML gateway, please subscribe in Intacct.

Error: If all transactions are erroring after a specific date

Reason:

This error occurs when accounts have been set an "inactive" date in Intacct 

Solutions:

Option 1: Confirm that the GL Account is active or available for the Entity in Intacct

1. Confirm the GL account is Active or update the inactive status by changing the date
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Option 2: Change the GL account mapped to the Category in Abacus

1.  Use the Advanced Filter to locate the expense
2. Locate and edit the Expense and  update the Category with an appropriate one 
3. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: A transaction with the number XYZ already exists for the vendor 'Abacus'

Reason:

This error occurs when the transaction has already synced into Intacct but the error is not cleared on the Accounting Sync History page

Solution:

1. Confirm if the record is already in Intacct, If it exists follow the next steps
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
4. Click Dismiss Error

Error: Invalid Vendor 'Abacus' specified.

Reason:

This error occurs when the vendor that we are trying to sync may be inactive in Intacct.

Solution:

1. Confirm if the Vendor is active in Intacct. If it is inactive, please make it Active and follow the next steps
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
4. Click  Re-Sync Record

Error: The sender AbacusLabs is not authorized to make WebServices requests to company ID 

Reason:

This error occurs when Authorisation has not been given to Abacus to access your Intacct Company file

Solution: 

1. Login to Intacct 
2. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
3. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
5. Click Re-Sync Record

Error: abacuslabs is not authorized to execute this function

Reason:

The error occurs when the AbacusLabs user does not have full permission in Intacct

Solution: Login to Intacct 

1. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
4. Click Re-sync Record

Error: Use of empty Location is invalid. A valid Multi-Entity Location must be specified.

Reason:

This error occurs when AbacusLabs does not have permission for the specific Location entity

Solution: Please follow the steps below

1. Login to Intacct 
2. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
3. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
5. Click Re-sync Record

Error: Use of empty Organization is invalid. A valid Multi-Entity Organization must be specified

Reason:

The error occurs when the Web Services user does not have access to the Entity in Intacct.

Solution: 

1. In Intacct, the administrator needs to go to Applications and select Company.
2. Then select Users (could be under WebServices Users as well.) 
3. Then admin should Edit the User, and go to the User Entities tab
4. Then specify the entity for Intacct, and Save.
5. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
6. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Debits and Errors only option 
7. Click Re-sync Record

Error: Unable to add to the summary: The batches for the period are closed.

Reason:

This error occurs when the expenses are in a closed period date. Card transactions should be posted with either the transaction date or the transaction date associated with the expense item (based on your Accounting sync settings). If an item's associated date falls within a closed period, Abacus will update the date to the first day of the next open period month. 

Solution: 

1. The Intacct admin will need to open the Summary Transaction Batch.
2.  In Intacct to view the list of summaries, go to the module (for example, Accounts Receivable), Subledger > Summaries. Open the summary 
3. Login into Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: Another Contact with the given value(s) already exists.

Reason:

The error indicates that there is a record with the name in a different list for example Vendor/Customer with identical names. 

Solution: 

1. Make sure that the Vendor/ Merchant name is slightly different from the existing name in Intacct’s Vendor/Customer list
2. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
3. Locate and edit the Expense and update the Vendor/ Merchant field on the expense
4. Go to Account & Settings by clicking the Gear button on the top right side of the page
5. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
6. Click Re-sync Record 

Error: You must select the same department in all the lines for transaction department value approval. Please modify the line items or save your transaction in draft mode. Once your administrator has resolved this error you can submit your transaction for approval. 

Reason:

This error occurs when there is a requirement rule in Intacct that requires a Department to be coded on an expense in Abacus.

Solution:  

1. Admin needs to turn off the requirement in their system that all the departments' lines be the same.
2. Log in to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Error: The account number XYZ requires a Restriction (ABC) Enter a valid Restriction (EFG) on line item X, and try again

Reason:

This error occurs when there is an Intacct requirement for a Restriction when a particular GL account (Category) is selected on the expense

Solution: 

1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
2. Locate and edit the Expense and update the XXXX field on the expense
3. Go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: Invalid Department XYZ: ABC specified. Department is restricted by GL Account, Location, Project. Configure relationships between the Department and the specified GL Account, Location, Project.

Reason:

This error occurs when there is a restriction rule set in Intact to have a certain Department to be available to a specific GL Account, Project, or location.

Solution:

1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
2. Locate and edit the Expense and update the XXXX field on the expense
3. Go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: You do not have permission for API operation CREATE on objects of type vendor

Reason:

The error occurs when the Abacus Web Services user does not have sufficient permissions in Intacct.

Solution:

The Intacct Administrator will need to ensure that the WebServices role has the necessary Intacct permissions/subscriptions to access the object referenced in the error message.

1. Go to Account & Settings by clicking the Gear button on the top right side of the page
2. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
3. Click Re-sync Record 

Error: The account number ‘XYZ’ requires an ABC. Enter a valid ABC on line item X, and try again.

Reason:

This error occurs when there is a requirement for an ABC to be mapped on an expense when a Specific GL account (Category) is selected. 

Solution: 

1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
2. Locate and edit the Expense and update the XXX field on the expense
3. Go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: You do not have permission for API operation READ_BY_QUERY on objects of type class.

Reason:

This error occurs when the web service user being used in the integration does not have the appropriate permissions, in this case, to ReportingPeriod.

Solution:

1. The Admin will need to ensure that the WebServices user has access to View and list permissions for the object (Programs / Projects)

Error: The credit card 'Credit card XYZ is not valid.

Reason:

This error occurred because the Corporate card is mapped with an invalid or inactive GL account.

Solution: 

1. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
2. Select Accounting Sync and scroll to Corporate cards section 
3. Map the Corporate cards with a valid credit card type GL account
4. Select Accounting Sync History and select Sync type as Corporate Card Expenses and Errors Only option 
5. Click Re-sync Record

Error: Location must be XYZ. This value is auto-filled by the Department. 

Reason:

The error occurs when the location is required on the expense but is not mapped to the custom field item from Intacct.

Solution:

1. Login to Abacus and go to Account & Settings 
2. Select the Team field or Expense field 
3. Locate the Location field and if it is not mapped, please map the Custom field item from Intacct
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: Oops, we can't find this transaction; enter a valid XYZ Key and then try again

Reason:

This error occurs when the GL account mapped to a category is inactive.

Solutions:

Option 1: Confirm that the GL Account is active

1. Confirm the GL account is Active in Intacct
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Option 2: Change the GL account mapped to the Category in Abacus

1. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
2. Select Categories and edit and update the GL account mapped to the Category
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Error: There is no due on the bill XYZ

Reason:

This error occurs when a bill is paid or partially paid in Intacct.

Solution: 

Option 1: If you do not want to Void the Bill in Intacct, the error can be dismissed in Abacus.

1. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
2. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
3. Click Dismiss Record 

Option 2: If you want to sync the record from Abacus into Intacct.

1. Login into Intacct and Void the payment within Intacct
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Error: The account number XYZ requires a Department. Enter a valid Department on line item X, and try again.

Reason:

This error occurs when a GL account (Category) selected requires a Valid Department selected on the expense 

Solution: 

Option 1: Confirm that the Department is active in Intacct

1. Confirm the Department is Active in Intacct
2. Login to Abacus and go to Account & Settings by clicking the Gear button on the top right side of the page
3. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
4. Click Re-sync Record 

Option 2: Change the Department mapped on the Expense in Abacus

1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
2. Locate and edit the Expense and update the Department on the expense
3. Go to Account & Settings by clicking the Gear button on the top right side of the page
4. Select Accounting Sync History and select Sync type as Corporate Card or Bank Debits Transactions and Errors only option 
5. Click Re-sync Record 

Error: Format for Vendor: Vendor ID XYZ is not valid.

Reason:

This error occurs when the merchant/vendor name in Abacus has a special character, such as a colon (:) or an ampersand (&), that Intacct does not allow.

Solution:

Change the vendor/merchant name so that it does not include a special character, then click Re-Sync Record.