Integrate Netsuite data to optimized your inventory with Lokad

Inventory Forecasting for Netsuite


Home » Integrations » Here

Lokad can be seen as an add-on for NetSuite. We deliver advance inventory forecasting, commerce analytics and pricing optimization. Lokad is an app, like NetSuite, with a monthly subscription. NetSuite-powered companies typically get started with Lokad to optimize their inventory, that is, increase service levels while reducing inventory levels in the same time. Don't hesitate to request a free demo; while we strive to make Lokad as simple as possible, optimizing inventory tends to be inherently complex.

The data from NetSuite can be imported in just a few clicks into Lokad thanks to a native integration that leverages NetSuite SuiteTalk (web services). In this page, we detail how to make the most of this native NetSuite integration.


Getting Started

In order to import your NetSuite data into Lokad, you need a Lokad account. If it's not already done, you can get one at no cost in 60 seconds.

Also, you need to give Lokad the NetSuite SuiteTalk credendials that can be found in the web services preferences. From the top navbar, you should go to Setup, then to Integrations, then to Web Services Preferences.

Image

Then, from this screen, you will obtain your Account ID and the Role ID, the later being associated to the user who will grant the actual access to Lokad.

Image

Within NetSuite, API connections are stateful, and as a consequence, only a single app can be connected through the NetSuite SuiteTalk through the same credentials at the same time. Thus, we recommend to create a user within NetSuite dedicated to Lokad. By doing this, you will avoid unwanted interference between Lokad and other apps. 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 your are about to change anything within NetSuite.
  • 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 .

Data retrieved from NetSuite

Lokad retrieves extensive data from NetSuite which include:
  • All inventory items with the stock on hand, the stock on order, the buy price.
  • The sales order history with the quantity, the net amount, the client.
  • The purchase order history with the quantity, the net amount, the delivery date, the supplier, the status.

This data is pushed into 3 flat files named Lokad_Items.tsv, Lokad_Orders.tsv and Lokad_PurchaseOrders.tsv within your Lokad account.

Lokad_Items.tsv

The file Lokad_Items.tsv contains the columns:
  • Id: a synthetic identifier composed by Lokad
  • Ref: the item ID
  • Loc: the name of the location
  • Name: the item name
  • Variant: a synthetic entry based on the item options
  • Sku: MPN when present
  • Category: first entry found in the site category list (might change)
  • Brand: name of the manufacturer (might change)
  • StockOnHand: quantity on hand
  • StockOnOrder: quantity on order
  • StockAvailable quantity available
  • CurrrentReorderPoint: the reorder point for the inventory item
  • Supplier: name of the vendor (might change)
  • BuyPrice: the per unit cost
  • SupplierLeadTime: extrapolated from the purchase orders.
  • OrderingLeadTime: extrapolated from the purchase orders.
  • LeadTime: extrapolated from the purchase orders.
  • IsForecasted: always true.

Lokad_Orders.tsv

The file Lokad_Orders.tsv contains the columns:
  • Id: a synthetic identifier composed by Lokad
  • Ref: the item ID
  • Loc: the name of the location
  • Date: the creation date of the order
  • DeliveryDate: the due date
  • Quantity: the quantity of the order line
  • NetAmount: the amount without tax for the line
  • Currency: the currency code
  • OrderStatus: the status associated to the order
  • Client: the client email associated to the order
  • OrderId: the internal ID for the sales order

Lokad_PurchaseOrders.tsv

The file Lokad_PurchaseOrders.tsv contains the columns:
  • Id: a synthetic identifier composed by Lokad
  • Ref: the item ID
  • Loc: the name of the location
  • Date: the creation date of the purchase order
  • DeliveryDate: the reception date of the procurement matching the purchase order
  • Quantity: the quantity of the purchase order line
  • NetAmount: the amount without tax for the line
  • Currency: the currency code
  • OrderStatus: the status of the purchase order
  • PaymentStatus: the payment status of the purchase order
  • Supplier: the source
  • OrderId: the internal ID for the purchase order