Craftable’s Netsuite integration facilitates syncing Bill/Credit data as well as Inventory Count Values against specific General Ledger accounts as a Journal Entry into Netsuite.
Setting Up Your Netsuite Integration
We use the SOAP web services through Netsuite to integrate into your environment. This means that we’ll need the information listed below to establish the sync process from Books to Craftable.
Important Note: You may need an Administrator to help set up and gather this information.
LocationID (if used)
DepartmentID (if used)
SubsidiaryID (if used)
SCompID (this is the company ID) (required)
ConsumerKey (required, see below on how to create this)
ConsumerSecret (required, see below on how to create this)
TokenID (required, see below on how to create this)
TokenSecret (required, see below on how to create this)
URL (We use the suitetalk URL)
FolderID (this is the ID of the folder for image sync)
Additional Information on how to gather the elements listed above:
For the LocationID, Department ID, and SubsidiaryID, one thing to note is that we can support the configuration you’ve set in Netsuite. This means that if you’re not using Departments, Locations, or Subsidiaries – that will work just fine. Ensure that you relay this information to the Integration team setting up your integration.
Additionally, if you have multiple outlets you’re integrating with, we’ll need the corresponding information for each outlet as it may vary depending on your setup.
For the Consumer Key and Consumer Secrets - This requires that you set up a New Integration. To do this, go to Setup, Integrations, Manage integrations, and New.
Name the Integration “Craftable”. You’ll want the settings to look something like this screenshot below:
Important: The values highlighted above will only appear one time. Make sure you copy this information immediately (Consumer Key and Consumer Secret) and email it to our Integrations team to finish the setup.
For the Token Key and Token Secret, you will need to first create a third-party integration user for us to authenticate with the Integration we’ve set above. To do this, go to Setup, Users/Roles, and Manage Users.
Note: You will also need to assign a Role for our Third Party Integration account. We recommend reviewing Netsuite’s documentation on roles/permissions if this is the first time setting this up. One best practice they will recommend is creating a role specifically for third-party integrations.
The next step is we’ll need to create the Token and assign it to the user created. To do this, go to Setup, Users/Roles, Access tokens, and New.
In the Application name, select the Craftable (or whatever you named our Integration)
In User, select the integration user. (This would be the user you set up)
In Role, select the integration role. (We recommend building a role specifically for Third Party Integrations.)
IMPORTANT: After pressing save it will provide you with our Token ID and Token Secrets. These only appear once. Ensure that you copy the information and send both the Token ID and Token Secret to the Integration team so they can complete the integration.