Configure itemType mapping

The NetSuite REST API using specific paths for mapping item types such as (but not limited to):

• assemblyitem

• inventoryitem

• noninventoryitem

• noninventoryresaleitem

• noninventorypurchaseitem

• bom

• bomrevision

• etc

Exactly one property mapping for NetSuite must be set as an item type mapping in order for SharpSync to know which item type value to use when creating new items in NetSuite. You can leave both the Onshape and the Netsuite mappings as (Unmapped), but the mapping must exist.

Item Type Property Mapping Settings

Setting	Value
Accessor	itemType
Primary accessor	(Unmapped) or mapped to a Primary Source accessor if you have one
Secondary accessor	(Unmapped)
Update Primary on Submit	unchecked
Update NetSuite on Submit	unchecked
Rendering Type	Select List
List Items	(see below)
Prefer NetSuite value	checked
Is Item Type Property	checked

When an item is created in NetSuite, it is typically one of the item types mentioned above. As such, add this as a list of options to pick from your Select List. You can include any item type in this list that is supported by your installation of NetSuite. A typical List Items list is as follows:

assemblyitem|inventoryitem|noninventorypurchaseitem|noninventorysaleitem|noninventoryresaleitem

On a more technical note: These items are derived by calling the endpoint

/GET {{netsuite-api}}/services/rest/record/v1/metadata-catalog with an empty body

Item Type Property Mapping Rules

In addition to this you'll want to create the following rules:

• A Text Manipulation rule for the Primary Source (CAD source) system that runs the following script (or similar based on your conditions) on data import:

if (rowData.isAssemblyRow === true) 
    return 'assemblyitem'; 

return 'inventoryitem'; /* or whatever your default item type is */

• A Text Manipulation rule for the Secondary Source (NetSuite) that runs the following script on data import to derive the existing NetSuite item type:

return rowData.secondaryDefaultItemCreationType;

• A Text not empty rule. This will prevent errors when submitting the BOM