Troubleshooting Other Integration Issues

Note:

This help topic is a placeholder. Content will be added gradually to these pages. For information about troubleshooting the integration, see NetSuite Integration.

Please review the Help Center Updates regularly for a summary of changes made to NetSuite Integration help topics.

Scenario	Possible Solutions
NetSuite records of a certain type are not imported into OpenAir using real-time record import.	Ensure that integration script deployments for that record type are deployed for all roles and executed as the `NSOA Connector` or as the custom role you created for the integration. See Verifying Integration Script Deployment Settings. For example, if you want to import purchase orders, vendor bills, or vendor credits from NetSuite into OpenAir, the following scripts must be deployed for or all roles and executed as the `NSOA Connector` or as the custom role you created for the integration: `OpenAir: PO/VB/VC Validate` or `OpenAir: PO/VB/VC Validate v2.1` `OpenAir: PO/VB/VC Save` or `OpenAir: PO/VB/VC Save v2.1` `OpenAir: Send Record to OpenAir` or `OpenAir: Send Record to OpenAir 2.0` Important: Either the SuiteScript 1 or the SuiteScript 2 version of each script must be deployed, but not both. Ensure that the user event script sending the record to OpenAir runs after all other user event scripts for the record type. See Verifying User Event Scripts Running Order
OpenAir NetSuite Connector logs show this error for all new and already integrated records of a certain type: `ERROR: The currency "" for NetSuite <record type> "<name>" has not been defined in NS OpenAir.`	Verify that the Multiple Currencies feature is enabled in your NetSuite account. See Enabling the Multiple Currencies Feature (External link to NetSuite SuiteAnswers — Answer ID: 7714). Verify that the `NSOA Connector` role or custom role you created for the integration includes `Full` access permission for `Currency` (Lists subtab). See NetSuite Permissions Required for the Integration. If there is only the root subsidiary in your NetSuite account, create another subsidiary. See Creating Subsidiary records (External link to NetSuite SuiteAnswers — Answer ID: 7714). Ensure NetSuite subsidiary information is mapped to an OpenAir hierarchy. See Map NetSuite employee subsidiary to employee hierarchy, Map NetSuite customer subsidiary to customer hierarchy, and Map NetSuite project subsidiary to project hierarchy. Run a full synchronization and include the import workflow for the NetSuite record type. Go to Setup > Integration > SOAP Web Services Preferences. Check the Run server SuiteScript and trigger workflows box. Click Save. See Enabling the OpenAir Integration in NetSuite. Note: This SOAP web services preference, when disabled, prevents the SuiteScript which OpenAir NetSuite Connector uses to fetch the integration preferences set in the NetSuite account from running. OpenAir NetSuite Connector does not handle the currency for the NetSuite record correctly because it expects the NetSuite account to use a single base currency account when in fact it uses multiple base currencies.

Scenario

Possible Solutions

NetSuite records of a certain type are not imported into OpenAir using real-time record import.

Ensure that integration script deployments for that record type are deployed for all roles and executed as the NSOA Connector or as the custom role you created for the integration. See Verifying Integration Script Deployment Settings.

For example, if you want to import purchase orders, vendor bills, or vendor credits from NetSuite into OpenAir, the following scripts must be deployed for or all roles and executed as the NSOA Connector or as the custom role you created for the integration:
- OpenAir: PO/VB/VC Validate or OpenAir: PO/VB/VC Validate v2.1
- OpenAir: PO/VB/VC Save or OpenAir: PO/VB/VC Save v2.1
- OpenAir: Send Record to OpenAir or OpenAir: Send Record to OpenAir 2.0
Important:
Either the SuiteScript 1 or the SuiteScript 2 version of each script must be deployed, but not both.
Ensure that the user event script sending the record to OpenAir runs after all other user event scripts for the record type. See Verifying User Event Scripts Running Order

OpenAir NetSuite Connector logs show this error for all new and already integrated records of a certain type:

ERROR: The currency "" for NetSuite <record type> "<name>" has not been defined in NS OpenAir.

Verify that the Multiple Currencies feature is enabled in your NetSuite account. See Enabling the Multiple Currencies Feature (External link to NetSuite SuiteAnswers — Answer ID: 7714).
Verify that the NSOA Connector role or custom role you created for the integration includes Full access permission for Currency (Lists subtab). See NetSuite Permissions Required for the Integration.
If there is only the root subsidiary in your NetSuite account, create another subsidiary. See Creating Subsidiary records (External link to NetSuite SuiteAnswers — Answer ID: 7714).
Ensure NetSuite subsidiary information is mapped to an OpenAir hierarchy. See Map NetSuite employee subsidiary to employee hierarchy, Map NetSuite customer subsidiary to customer hierarchy, and Map NetSuite project subsidiary to project hierarchy.
Run a full synchronization and include the import workflow for the NetSuite record type.
Go to Setup > Integration > SOAP Web Services Preferences. Check the Run server SuiteScript and trigger workflows box. Click Save. See Enabling the OpenAir Integration in NetSuite.

Note:
This SOAP web services preference, when disabled, prevents the SuiteScript which OpenAir NetSuite Connector uses to fetch the integration preferences set in the NetSuite account from running. OpenAir NetSuite Connector does not handle the currency for the NetSuite record correctly because it expects the NetSuite account to use a single base currency account when in fact it uses multiple base currencies.