NetSuite Accounting Sync & Export 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 must be positive to export 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, ensure the category "Rate is Required" is not enabled.
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 the above fields are filled in properly. If any are missing this error will occur. Once you've updated the record, rerun the Tallie export.
Error: [USER_ERROR] This bill has payments applied to it. Are you sure you want to edit it?
Reason:
The exported bill is reimbursable, which cannot be edited in NetSuite after export.
Solution:
Make changes in NetSuite and export reports to the archive, or, reject the report and submit, approve, and export reimbursable expenses on a net new report in Tallie.
Error: Invalid customform reference key
Reason:
Tallie uses the standard default forms in NetSuite to write bills (form). The error indicates that the form is currently inactive.
Solution:
Reactivate the Form in NetSuite. Once completed, try your export again.