Sage Intacct Export & Sync Errors

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

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

AbacusLabs and Web Server Errors

  • Error Code:

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

    Reason:

    This error occurs when Authorisation has not been given to Emburse Spend to access your Sage Intacct Company file

    Solution: 

    1. Log in to Sage Intacct 
    2. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
    3. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    Abacuslabs is not authorized to execute this function

    Reason:

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

    Solution: 

    1. Log in to Sage Intacct 
    2. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
    3. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    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:

    1. Log in to Sage Intacct 
    2. Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add AbacusLabs 
    3. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

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

    Reason:

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

    Solution:

    The Sage Intacct Administrator will need to ensure that the WebServices role has the necessary Sage 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 screen
    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 Code:

    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 Code:

    Emburse Spend is not authorized to execute this function

    Reason:

    This error indicates that the integration user does not have full permission in Intacct. 

    Solution: 

    1. Log in to Sage Intacct 
    2. Navigate to Company >> WebServices User Information.
      1. Under Roles >> assign Emburse Spend.
      2. Under User Entities >> assign the entity your Spend account is connected to. 
    3. Navigate to Company >> Admin >> Roles
      1. Under Emburse Spend Rol >> Ensure that each role subscription has all the permissions for all the Applications/Modules.
    4. Log in to Spend and go to Settings by clicking the Gear button n the top right of the screen
    5. Select Accounting Integrations >> Accounting Sync History and select Sync type as Corporate Card Expenses and Errors only option.
    6. Click Re-sync Record.

Corporate Card Errors

  1. Error Code:

    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. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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

  2. Error Code:

    There is no due on the bill XYZ

    Reason:

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

    Solution: 

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

    1. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Emburse Spend into Sage Intacct.

    1. Log in into Sage Intacct and Void the payment within Sage Intacct
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 

  3. Error Code:

    syncing_card_txes_in_multi_gl_account_mode_requires_card_to_be_mapped_to_GL_account

    Reason:

    One or more corporate cards have not yet been mapped to a GL account in your accounting software. If a card is not mapped, transactions from that card cannot be synced by Emburse Spend to your accounting software.

    Solution: 

    1. Log in to Emburse Spend and select the Settings Gear in the upper right corner to access Company Settings.
    2. In the Company Settings menu, select Accounting Integration.
    3. Scroll down to the list of corporate cards and look for those with blank drop-downs.
    4. Use the drop-downs to select the correct GL account for each unmapped card, then select Save.
    5. Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
    6. Filter the list by Corporate Card Expenses and Errors Only, then select Re-sync Record.

  4. Error: BL03000113 - Credit Card ID is not valid

    Reason: The expiration date associated with the credit card account in Intacct is expired.

    Solution: Update the credit card account expiration date.

Department, Organization, and GLD Errors

  • Error Code:

    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 Sage Intacct.

    Solution: 

    1. In Sage 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 Sage Intacct, and Save.
    5. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    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 Sage Intacct that requires a Department to be coded on an expense in Emburse Spend.

    Solution:  

    1. Admin needs to turn off the requirement in their system that all the departments' lines be the same.
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    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 Sage Intacct requirement for a Restriction when a particular GL account (Category) is selected on the expense

    Solution: 

    1. Log in to Emburse Spend and click Card Transactions or Reimbursements 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 screen
    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 Code:

    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 Emburse Spend and click Card Transactions or Reimbursements 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 screen
    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 Code:

    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 Emburse Spend and click Card Transactions or Reimbursements 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 screen
    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 Code:

    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 Sage Intacct.

    Solution:

    1. Log in to Emburse Spend 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 Sage 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 Code:

    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 Sage Intacct

    1. Confirm the Department is Active in Sage Intacct
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Emburse Spend

    1. Log in to Emburse Spend and click Card Transactions or Reimbursements 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 screen
    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 

Transaction Errors

  • Error Code:

    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 Sage Intacct Integration
    2. Confirm web services are enabled and the user is a 'business' user with permissions set to 'full'
    3. Confirm the Emburse Spend 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 Sage Intacct.

  • Error Code:

    If all transactions are erroring after a specific date

    Reason:

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

    Solutions:

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

    1. Confirm the GL account is Active or update the inactive status by changing the date
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Emburse Spend

    1.  Use the Advanced Filter to locate the expense
    2. Locate and edit the Expense and  update the Category with an appropriate one 
    3. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    A transaction with the number XYZ already exists for the vendor 'Spend'

    Reason:

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

    Solution:

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

  • Error Code:

    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, Emburse Spend will update the date to the first day of the next open period month. 

    Solution: 

    1. The Sage Intacct admin will need to open the Summary Transaction Batch.
    2.  In Sage Intacct to view the list of summaries, go to the module (for example, Accounts Receivable), Subledger > Summaries. Open the summary 
    3. Log in into Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    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 Sage Intacct
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Emburse Spend

    1. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    Date must be on or after mm/dd/yyyy

    Reason:

    The record is trying to sync to a closed date. You must set a Closed date and re-sync the record.

    Solution: 

    1. Log in to Emburse Spend and click the gear to access Company Settings.

    2. In the left-nav, select Accounting Integration and set up the Closed date.

Vendor Errors

  • Error Code:

    Invalid Vendor 'Spend' specified.

    Reason:

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

    Solution:

    1. Confirm if the Vendor is active in Sage Intacct. If it is inactive, please make it Active and follow the next steps
    2. Log in to Emburse Spend and go to Account & Settings by clicking the Gear button on the top right side of the screen
    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 Code:

    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 Sage Intacct’s Vendor/Customer list
    2. Log in to Emburse Spend and click Card Transactions or Reimbursements 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 screen
    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 Code:

    Format for Vendor: Vendor ID XYZ is not valid.

    Reason:

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

    Solution:

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

 

Was this article helpful?