NetSuite Export & Sync Errors
This article lists common error messages which may be returned when exporting to NetSuite. 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.
Mapping Errors
Reason:
The custom fields in NetSuite are not configured correctly.
Solution:
Please refer to the article Creating and Syncing a NetSuite Custom Field to resolve the mapping of the custom field.
Reason:
This error occurs when you change from Cash mode to Accrual mode as the default mapping needs to be adjusted.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync.
- Select Default Expense Account, Bank Account, AP account, and Vendor for Bill.
- Select Save.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
A rule in NetSuite is requiring the native NetSuite Project field to be mapped to an expense, but the Project form NetSuite is not mapped to the Custom field in Emburse Spend.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the expense with the project item or the other custom field item.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Team fields or Expense fields.
- Locate the Project/ Custom Field and map it with the Project item from NetSuite.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
If you are getting this error, even when there are Locations, Departments, and Classes on every expense, it is because you are syncing in Accrual mode and the default mappings are not configured. A bank transfer record needs to be created to represent the full debit from the bank account to the clearing account. As the record is not related to a single expense, we need to know what Class, Location or Department to use on that record.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync>Default Field Mapping.
- Select a Default mapping for Class, Department, Location and, other custom fields and Save.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
No Credit Card-type GL account exists in NetSuite for the subsidiary connected to Emburse Spend. Without this account type, the Corporate Cards section does not display on the Accounting Integration page, so corporate cards cannot be mapped.
Solution:
- In NetSuite, create a Credit Card-type GL account for the applicable subsidiary.
- In Emburse Spend, go to Company Settings > Accounting Integration and confirm the Corporate Cards section displays.
- Map each corporate card to the correct GL account, then select Save.
- Go to Accounting Sync History.
- Filter by Corporate Card Expenses and Errors Only.
- Select Re-sync Record.
Vendor Errors
Reason:
This error occurs when there are multiple external entities that have the same entity name e.g. multiple vendors with the same name.
Solution:
- Rename the two vendors so that you can differentiate and track them differently
Reason:
This error occurs when there are two vendors that belong to the same entity, and have the same name, in NetSuite.
Solution:
- The NetSuite Administrator needs to make sure that the Employee names and their Vendor names are slightly different in NetSuite.
Transaction/ Expense Errors
Reason:
This error occurs when the expense has already exported to NetSuite and you are trying to re-sync the record.
Solution:
- Confirm if the record is already in NetSuite.
- If the record exists, proceed as follows.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card Expenses or Debits and Errors only.
- Select Dismiss Error.
Reason:
This error occurs when there is an approval rule in NetSuite that requires approval for bills before they are ready for payment.
Solution:
- The NetSuite Administrator will need to create an exception to the Approval rule to Bills in NetSuite.
- This will exempt Emburse Spend from creating/posting expenses without requiring approval in NetSuite.
Reason:
This error occurs when the expense has more than 83 characters in the note field or in the Merchant name.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the expense with fewer than 83 characters in the Merchant field or the note field.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurs when there is a Class requirement in NetSuite but a Class is not selected on the expenses.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the expense class.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurs when a transaction can't sync to NetSuite because the transaction date is part of an accounting period that has not been created or has not been fully set up in NetSuite.
Solution:
The Admin will need to create or complete the setup of the accounting period in NetSuite:
- Log in to NetSuite and select Setup.
- Select Accounting.
- Select Manage Accounting Periods.
- Update the accounting period(s) including the invoice date of the transaction causing the sync error.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
NetSuite has a limit of syncing only 15 transactions simultaneously. Emburse Spend allows for bulk approval for 30 transactions, so often companies will hit this error when approving large batches of transactions.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter byCorporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The Business unit or Department is not coded on the expense
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Team fields or Expense fields.
- Locate the Department/Business Unit/Custom Field and make sure that it is correctly mapped with Department/Business unit/Custom field from NetSuite.
- If the Custom field is not mapped, map the Custom field.
- Select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the expense with the Department/Business unit/Custom field item and Save.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
Our RESTlet returns the data formatted as MM/DD/YYYY and currently does not allow for user configurations of the date shape.
Solution:
- Change the date format to match the MM/DD/YYYY format in the Preferences section.
AccrualDebit
Reason:
This error occurs when the AccrualDebit script does not have access to all of the correct subsidiaries.
Solution:
- Go to Customization > Scripting > Script deployments.
- Locate the AccrualDebit script and select Edit.
- Go to Audience > Roles.
- Check Select All.
- Select Save.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurs when the AccrualDebit script does not have all of the correct subsidiaries included.
Solution:
- Go to Customization > Scripting > Script Deployments.
- Select Edit next to the AccrualDebit script.
- Go to Audience > Roles.
- Check Select All.
- Select Save.
Sync Errors
Reason:
This error occurs when the Custom Fields from NetSuite are not syncing with Emburse Spend.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Team fields or Expense fields.
- Locate the Project/Custom Field and make sure that it is mapped to the List item from NetSuite.
- If the Custom field is not mapped, map the Custom field.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurred because the vendor/merchant name is over 83 characters, which causes the sync to fail. This is a NetSuite limitation.
Solution:
- Log in to Emburse Spend and select CardTransactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the expense with fewer than 83 characters in the Merchant field or the Note field.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error occurs when the posting period is incorrect, closed or inactive.
Solution:
- Navigate to Setup > Accounting > Manage Accounting Periods.
- Confirm the following:
- Period is active.
- Period is spelled correctly.
- Period is open.
- Close the inaccurate posting period in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurs when the Emburse Spend Integration role does not have the Document and Files permissions in NetSuite.
Solution:
- In NetSuite, go to Setup > Users/Roles > Manage Roles.
- Select Spend Integration role from the list of options.
- Select Edit to view and edit the permissions assigned to the role user.
- Under Permissions, you should be able to select the checkbox next to Lists or Documents/Files.
- Select Save.
- Repeat the previous steps for user that the Emburse Spend integration role is assigned to.
- Go to Manage Users > Select the user > Edit > Access > Global Permissions > Add Documents and Files > Save.
- This action saves the settings for that user.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error is displayed when the Token is invalid or expired.
Solution:
Disconnecting the NetSuite integration removes all existing mappings. Before you disconnect, take full screenshots of all mappings on the Accounting Integrations page. See Accounting Integration Reconnection Guide for the full checklist.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync.
- Select Disconnect.
- Select Connect to NetSuite.
- Enter the appropriate credentials.
- Follow the steps from the article How to connect the NetSuite accounting software to Emburse Spend to complete the integration.
Reason:
This error occurs when the token used for the integration with Emburse Spend is either invalid or expired.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync.
- Select Disconnect.
- Select Connect to NetSuite.
- Enter the appropriate credentials.
- Follow the steps from the article How to connect the NetSuite accounting software to Emburse Spend to complete the integration.
Reason:
This error occurs when you approve corporate card expenses using the bulk approval feature. NetSuite has a rate limit so when there are too many sync attempts, NetSuite will limit the number of records that can sync at once from Emburse Spend.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card Expenses and Errors only.
- Select Re-sync Record.
- Wait for the sync to complete.
Reason:
NetSuite has a rate limit so when there are too many sync attempts, NetSuite will limit the number of records that can sync at once from Emburse Spend.
Solution:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card Expenses and Errors only.
- Select Re-sync Record.
- Wait for the sync to complete.
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:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to the list of corporate cards and identify cards with blank drop-downs.
- Use the drop-downs to select the correct GL account for each unmapped card, then select Save.
- Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
- Filter by Corporate Card Expenses and Errors.
- Select Re-sync Record.
Subsidiary Errors
Reason:
The vendor with the NetSuite Internal ID XYZ is either inactive or unavailable for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the vendor is active or available for the subsidiary in NetSuite
- Confirm the vendor is active or available for the aubsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the vendor mapped on the Expense in Emburse Spend
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the vendor on the expense.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
This error occurs when the Emburse Spend integration role is not available to all the NetSuite subsidiaries.
Solution:
- Log in to NetSuite.
- Go to Setup > Manage Roles.
- Edit the Emburse Spend Integration role.
- Select all subsidiaries from the list.
- Save the role.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the Department is either inactive or not available for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the department is active or available for the subsidiary in NetSuite.
- Confirm the department is active or available for the subsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the Department mapped on the Expense in Emburse Spend
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar to locate the expense or transaction.
- Locate the expense.
- Update the department on the expense.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the GL Account is either inactive or not available for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the GL Account is active or available for the subsidiary in NetSuite
- Confirm the GL account is active or available for the aubsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the GL account mapped to the Category in Emburse Spend
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Categories.
- Update the GL account mapped to the category.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the location is either inactive or not available for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the location is active or available for the subsidiary in NetSuite
- Confirm the location is active or available for the Subsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the Location mapped on the Expense in Emburse Spend
- Log in to Emburse Spend.
- Select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the location on the expense.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the class coded on the expense is either inactive or not available for the subsidiary.
Solution:
Option 1: Confirm that the class is active or available for the subsidiary in NetSuite
- Confirm the class is active or available for the subsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the Class mapped on the Expense in Emburse Spend
- Log in to Emburse Spend.
- Select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the class on the expense.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the GL account is either inactive or not available for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the GL account is active or available for the subsidiary in NetSuite
- Confirm the GL account is active or available for the subsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the GL account mapped to the Category in Emburse Spend
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Categories.
- Edit the and update the GL account mapped to the category.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the Emburse Spend Integration Role may not have permissions to access the Subsidiary in NetSuite. This NetSuite user would need to have full permissions across all the NetSuite subsidiaries.
Solution:
- Log in to NetSuite and go to Setup.
- Select User/ Roles > Manage Roles.
- Edit the Emburse Spend Integration role.
- Select all subsidiaries from the list.
- Save the role.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error invalid posting period indicates that Emburse Spend needs the posting period closed to sync to an open, or non-problematic period.
Solution:
- In order for the transactions to sync into the next posting period, all posting periods need to be closed for all subsidiaries in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Reason:
The error indicates that the customer coded on the expense is either inactive or not available for the subsidiary in NetSuite.
Solution:
Option 1: Confirm that the customer is active or available for the subsidiary in NetSuite
- Confirm the customer is active or available for the Subsidiary in NetSuite.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Option 2: Change the Customer mapped on the Expense in Emburse Spend
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar.
- Locate the expense.
- Update the cusomter on the expense.
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Filter by Corporate Card or Bank Debits Transactions and Errors only.
- Select Re-sync Record.
Permissions Errors
Reason:
This permission-related error occurs when a NetSuite script, workflow, or saved search attempts to reference a custom record that is unavailable. The record may not exist in the account, may have been deleted or renamed, or may be inaccessible due to role-based permission restrictions.
Solution:
Resolve the underlying permissions or record access issue in NetSuite. After the issue is corrected, re-run the failed sync in Emburse Spend.
- Verify Record Existence: Log in to NetSuite as an admin and confirm that the required custom record exists and has not been deleted or renamed.
- Check Role Permissions: Ensure the role used by the integration user has at least View or List permission for the relevant custom records. Update permissions under Setup Users/Roles Manage Roles as needed.
- Review Scripts and Workflows: Identify any scripts, workflows, or saved searches that reference custom records and confirm those records are still valid and accessible. Update dependencies if records were modified or replaced.
After you resolve the issue in NetSuite, complete these steps in Emburse Spend:
- Log in to Emburse Spend.
- Select the gear button on the top right side of the screen to display Account & Settings.
- Select Accounting Sync History.
- Filter by Corporate Card.
- Select Transactions and Errors Only.
- Select Re-sync Record.