Intacct Export & Sync Errors Follow
This article lists common error messages that Intacct may return when syncing List or Expense data between Tallie and Intacct.
Error: No record exists for the specified key.
Reason:
This error occurs when a report with the same report number has been previously exported to Intacct but has since been deleted.
Solution:
Check if the same report number is in Intacct. If so, the report can be archived in Tallie.
If the same report is not in Intacct, reject the report. Then, move the expenses to a new report, submit the report, approve the report, and finally export the report.
Error: Field 'Vendor entity' is one of many fields that can't be changed in a partially editable transaction.
Reason:
Admin has already exported this expense report in Intacct. For example, it could be from the same enterprise or a different enterprise. Additionally, that specific report number may not allow for edits. For instance, if the report was paid already.
Solution:
There are a few ways to solve this error:
- Admins should check the report number in Intacct to confirm if the same report is already there. If so, the report can be archived in Tallie.
- If the report isn't the same, admins will first have to reject the report. Then, move the expenses to a new report, submit the report, approve the report, and finally export the report.
Error: The provided Intacct API credentials are invalid.
Reason:
This error occurs when an admin enters the wrong credentials or Tallie isn't authorized to access the Intacct account.
Solution:
Check the credentials to ensure they are correct. You can locate your Company ID in Intacct by going to Company > Company Info > General Information > Company Information > ID.
Your User ID can be found in Intacct by going to Company > Users or Web Service Users > Click Edit for the User > User ID. Admins can reset their password by clicking Reset Password in this window.
If the credentials are correct, admins should authorize Tallie to access the Intacct account. To do this, go into Intacct and click Company > Company Info > Edit > Security > Web Service Authorizations > Click the blue plus sign > Sender ID > Add SpringAhead > Save
For more details please see: Adding Users for the Intacct Sync
Error: You do not have permission for API operation READ_BY_QUERY on objects of type <object name>
Reason:
This error occurs when a user in Tallie tries to connect to Intacct but does not have adequate permissions to access lists such as type class, project, savings account, credit card, item, GL account, checking account, customer, or vendor.
Solution:
To access these lists, users should be a Business user with Full Admin Privileges. They should also have access to all entities and departments. If this is not possible, the Admin should provide the user with access to modules and lists that Tallie requires when syncing and exporting. The best practice to do this is to create a Sync User. To create a Sync User:
- Going to Company > Users or Web Service Users > Click Subscriptions next to the user > check off all modules/applications > Save.
- Then, for each module/application click Permissions > Choose All > Save.
- Once that is complete, click Full Sync in Tallie.
Please Note: If you do not see Subscriptions for the user, then that company uses Roles and you can do this same process but instead, navigate to Company > Roles > Click Subscriptions next to the Role that is assigned to the user. Once that is set, click Full Sync in Tallie.
Error: Unable to add to the summary: 'Cash Management Transactions: YYYY/MM/DD Batch'. The batches for the period are closed. Open the summary for this period'
Reason:
This error occurs when the sync is attempting to post a transaction to a closed period in Sage Intacct.
Solution:
Adjust the export date (or GL Posting Date) of the transaction so that the date is in the current accounting period in Sage Intacct and sync via Settings > Integration & Sync > Export Settings > Non-Reimbursable Expenses > When creating Transactions: use the export Date or Prompt for the date to be used to ensure the export date is within an open period > Save
Error: Unfortunately, Tallie could not export this expense to the charge card because the expiration date provided in Intacct is in the past. Please update your expiration Intacct, sync with Tallie and try your export again.
Reason:
This error occurs when the expiration date on the charge card account in Intacct has a date that is in the past.
Solution:
To resolve this error, edit the expiration date on the associated card account in Intacct, then try your export again.
Error: The sender ID 'SpringAhead' is not authorized to make Web Services requests to company ID XXXX
Reason:
This error occurs when authorization has not been given for our application to access your Intacct company file.
Solution:
Add the Sender ID "SpringAhead" to the Web Services Authorizations List found on the Security tab of Company Configuration while logged in to Intacct as an Administrator.
Navigate to Company > Company Info > Edit > Security > Web Services Authorization > Add "SpringAhead"
Error: Could not create Label record!
Reason:
The sync error refers to Expense Types in Intacct. You will see this error occur if you do not have expense type enabled or are not using the list when you export your expenses as bills.
Solution:
These sync errors can be ignored if you are able to successfully export. If you changed your export from Bills to Expense Reports, you would need to enable Expense Types in Intacct and ensure each Expense type is linked to a GL account in Intacct.
Error: You cannot post documents to the GL in closed batches.
Reason:
This error message is specifically about the receipts attached to expense reports. That period has most likely been closed in Intacct, which is why the receipts cannot export.
Solution:
The receipts will need to be added manually in Intacct to clear the error message.
Error: A problem occurred between Tallie and Intacct: Invalid Key
Reason:
This error usually means the report that was exported originally to Intacct was deleted or marked as Paid in Intacct.
Solution:
Check if the same report number is in Intacct. If so, the report can be archived in Tallie.
If the same report is not in Intacct, reject the report. Then, move the expenses to a new report, submit the report, approve the report, and finally export the report.
Error: xml_tallie is not authorized to execute this function
Reason:
The error occurs when the Tallie user does not have full permission in Intacct.
Solution:
To resolve this error, please follow the steps below:
- Login to Intacct
- Navigate to Company >> select Company Info >> Edit >> Security >> Web Service Authorization >> Add Tallie
- In Tallie, go to Settings >> Integration & Sync >> Sync Settings. Once on this page, enter your Intacct credentials and select Connect.
- Click the Start Sync button once it appears.
- Export your report again
Error: PL0400005: You do not have permission for API operation READ_BY_QUERY on objects of type eeaccountlabel
Reason:
This error occurs when the web service user being used in the integration does not have the appropriate permissions for the object type referenced, eeaccountlabel refers to the Intacct Expense Types
Solution:
Ensure that the Web Services user can access View and list permissions for the Expense Types
Navigate to Applications > Company > Admin > Roles > Select Tallie Role > View > View Subscription > Time & Expense > Permissions > Expense Type > List and View
Error: A problem occurred between Tallie and Intacct : BL03000088 - Unable to add to the summary: 'Cash Management Transactions: 2021/08/19 Batch'. The batches for the period are closed. Open the summary for this period.
Reason:
This error occurs when the expenses are in a closed period date.
Solution:
Re-open the Summary Transaction Batch of the closed period.
In Intacct, go to the module (for example, Accounts Receivable), Subledger > Summaries > Open the summary.
If you would like to export using the export date, you can adjust the export settings to do so by navigating to Cog Wheel >> Integration & Sync >> Export Settings and selecting 'use Export Date' in the 'When creating transactions' section of the Non-Reimbursable Expenses page.
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:
Locate and edit the expense to update the 'XYZ' field on the expense. Try to export the report again.
Error: The corporate credit card “must be linked to a valid Intacct Cash Management account. This is required for Intacct corporate credit card exports. Missing Error message “IntacctTransaction_Missing_CreditCard_EnterpriseMapping’.
Reason:
This error happens when a corporate card isn't mapped to a valid Intacct Cash Management account.
Solution:
Navigate to Settings > Manage Lists > Corporate Cards and map the card. Don't forget to Save it at the bottom of the page.
Error: The account number XYZ requires a Restriction (ABC)
Reason:
The error message means that the account XYZ needs access to a specific Restriction (ABC) on the Intacct side or, the dimension would need to be turned off within Intacct in order to export.
Solution:
This issue will need to be resolved on the Intacct side. In order to turn off the dimensions to allow the exports, below is a walkthrough from Intacct:
- In Sage Intacct, click General Ledger, and then General Ledger Accounts
- Click Edit next to the account to access the edit window
- Uncheck all dimensions
- Click Save
- Sync again