NetSuite

There are several practices for connecting to NetSuite, e.g., Saved Searches or a NetSuite API. Lokad is heading for a Saved Search approach which is a more robust, flexible, and abstracted method of connecting to NetSuite. Saved Searches are reusable search definitions that can use various advanced filters, possibility of crafting the querries, and display options for the results which eliminates the need for excessive filters in the connector itself. Saved Searches allow filters to be added, removed, and modified quickly. It should be noted that each time a saved search is being run, the search will query the database and return current information. The modification of data might affect the search results. You will notice that if you refresh the search results, i.e., updated information will be displayed. Please note that every new NetSuite syncer should be of the “netsuite tokens” kind.

As previosuly mentioned, the data from NetSuite can be also imported into Lokad thanks to a native integration that leverages the NetSuite API. In the present page, we provide details on how to make the most of the NetSuite integration and we list all the possible NetSuite files you can be importing to Lokad along with the variables they contain.

Setup of the Lokad/NetSuite data connector

The suggested process to connect your Lokad and NetSuite accounts is the following:

The last step will redirect you to your Lokad account and the data connection between your Lokad account and your NetSuite account will be finalized there.

Two remarks:

  • Our data retrieval logic is read-only: your NetSuite data will not be modified in any way by Lokad; in the future, if Lokad were to add write capabilities for NetSuite, we will make it very explicit whenever you are about to change anything within NetSuite. In addition, your company remains the sole owner of your data; by default, we treat this data as if an NDA was in place between your company and Lokad; if you want an actual NDA to be signed, just drop us a message.

Annex: Tables reference

Lokad retrieves extensive data from NetSuite which include:

Data are pushed to your Lokad account into the following files:

Additional information can be found in NetSuite’s documentation.

NetSuite_AssemblyItemCustomFields.tsv

NetSuite_AssemblyItemLocations.tsv

NetSuite_AssemblyItemMembers.tsv

NetSuite_AssemblyItemPrices.tsv

NetSuite_AssemblyItems.tsv

NetSuite_AssemblyItemVendors.tsv

NetSuite_InventoryItemCustomFields.tsv

NetSuite_InventoryItemLocations.tsv

NetSuite_InventoryItemPrices.tsv

NetSuite_InventoryItems.tsv

NetSuite_InventoryItemVendors.tsv

NetSuite_ItemAvailability.tsv

NetSuite_ItemCorrelations.tsv

NetSuite_ItemFulfillmentItems.tsv

NetSuite_ItemFulfillments.tsv

NetSuite_ItemLights.tsv

NetSuite_ItemReceiptItems.tsv

NetSuite_ItemReceipts.tsv

NetSuite_KitCustomFields.tsv

NetSuite_KitMembers.tsv

NetSuite_KitPrices.tsv

NetSuite_Kits.tsv

NetSuite_PurchaseOrderCustomFields.tsv

NetSuite_PurchaseOrderItems.tsv

NetSuite_PurchaseOrders.tsv

NetSuite_SalesOrderCustomFields.tsv

NetSuite_SalesOrderItems.tsv

NetSuite_SalesOrders.tsv

NetSuite_VendorAddressBook.tsv

NetSuite_VendorCustomFields.tsv

NetSuite_Vendors.tsv

NetSuite_WorkOrderItems.tsv

NetSuite_WorkOrders.tsv