NetSuite Accounting Sync Errors Follow
This article lists common error messages which may be returned from NetSuite when exporting to Netsuite. You can view these errors on the Export Page via View Export Errors.
Error: Invalid customer reference key XYZ for entity AB.
Reason:
This error indicates that the customer selected (XYZ is the NetSuite ID for the customer) is no longer available for user AB in NetSuite when creating an expense entry. It could be the Project/Customer is in closed/completed/on hold status.
Solution:
Try creating an expense entry manually in NetSuite for the same employee using the same information in the Tallie expense report. This should help indicate which value is unavailable, and if so, you can correct the value in NetSuite and rerun the Tallie export.
Error: Invalid account reference key WXYZ for subsidiary ABCDE.
Reason:
A GL Account (one with the internal ID WXYZ) is not available for the user/employee’s subsidiary (ABCDE).
Solution:
Try to manually create an expense item in NetSuite under the same user with that category. If NetSuite doesn’t allow it, then it needs to be made available to that subsidiary in NetSuite before the expense report/item can be exported to NetSuite from Tallie. Once you make the category available in NetSuite you can rerun the Tallie export.
Error: Invalid entity reference key 15045.
Reason:
Usually, in NetSuite error messages, "entity" refers to the user. This error could be caused by (not limited to) the Employee being inactive or terminated in NetSuite.
Solution:
In NetSuite, confirm the employee is active and available.
Error: The provided NetSuite credentials are no longer valid. Please update your credentials on the Sync Settings page
Reason:
The tokens on the Sync Settings page are no longer valid.
Solution:
The Tallie Administrator with Primary Netsuite Administrator credentials needs to re-enter the token information by navigating to Settings > Integration & Sync > Sync Settings > Re-enter the information > Save.
Error: You do not have permissions to set a value for the element expense category due to one of the following reasons 1) The field is read-only 2) An associated feature is disabled 3) The field is available either when a record is created or updated, but not in both cases.
Reason:
NetSuite does not allow a vendor bill to contain a negative total amount (e.g. -$201.00). NetSuite requires the total amount to be a positive value. At the beginning of the error message, there is a number shown (e.g. 3109), which is the expense report code/number in Tallie. If you navigate to that specific expense report, you can see the total amount for the report is a negative amount.
Solution:
In Tallie, add a few more expense items in the same report to bring the total amount in the report to a positive value.
Note: if the expense report contains both company-paid credit card transactions and out-of-pocket reimbursable items, NetSuite will most likely try to create a vendor bill for the credit card transactions and a regular expense item for the reimbursable items. In both cases, the total amount needs to be positive to export them to NetSuite.
Error: You do not have permissions to set a value for the element expense amount due to one of the following reasons 1) The field is read-only 2) An associated feature is disabled 3) The field is available either when a record is created or updated, but not in both cases.
Reason:
In NetSuite, the specific category generating this error likely has a "Rate is Required" feature enabled.
Solution:
To check that your categories don't require a rate, in NetSuite, go to Setup > Accounting > Expense Categories. Once on that page, click the category name to view the category. For each category on the report in Tallie, make sure that the category does not have "Rate is Required" checked.
Error: Can't export report for 'John Doe' as this user is not part of the integration.
Reason:
One of the criteria for exporting expenses for this user/employee in NetSuite is missing. To export data from a Tallie user account to the NetSuite Vendor record, the following factors need to be checked:
• First name
• Last name
• Email address
• Status in NetSuite = Active
Solution:
In NetSuite, confirm if all of the above fields are filled in properly. If missing, any one of them will give this error. Once you've updated the record, rerun the Tallie export.