Inventory Engine

Sync data like inventory, purchasing and work order information bi-directionally using Violet's Inventory Engine.

Overview

This feature fuses data from your MES and your ERP, ensuring accurate, real-time information across your software stack - from your supply chain team to the manufacturing floor.

What data types are supported? Violet can sync any data type and any property (including custom fields) between your source and target tools.

How frequently is data synced? Data can be sync-ed on a scheduled basis or on an event-driven basis, as long as webhooks are available for your tools (and most are - for example NetSuite and ION).

What direction does data flow? You can control the source of truth and direction of data flow for every data type. For example, you may want to sync NetSuite Vendors to ION Suppliers, and you may want to enable bi-directional data sync between NetSuite and ION Purchase Orders.

Supported Data Types: NetSuite <> ION

When syncing between NetSuite and ION, the below properties are kept in sync by Violet by default. Any additional properties, including custom attributes, can be synced as well:

Purchase Orders

• PO Number

• Amount

• Promise Date

• Status

• Vendor

• Shipping Address

• Creator

• Created Date

• Last Modified

PO Line Items

• Quantity

• Amount

• Status

• Exp. Receipt Date

• Part Name

• Part Number and Revision

• Created Date

• Last Modified

Parts / Items

• Part Number and Revision

• Part Name

• Quantity Available

• Quantity On Hand

• Tax Schedule

• COGS Account

• Asset Account

• Created Date

• Last Modified

Item Receipts

• Date Received

• Corresponding Purchase Order ("Created From")

• Vendor

• Quantity

• Location

• Item

• Memo

• Currency

• Exchange Rate

• Posting Period

• Subsidiary

• Created Date

• Last Modified

Vendors

• Company Name

• Email

• Billing Address

• Shipping Address

• Phone Number

• Contact Names

• Description

• Created Date

• Last Modified

Inventory Adjustment Sync Logic

Inventory adjustments are made according to your specific configuration settings.

For example, adjustments made to NetSuite will consider the following:

• Advanced Bin/Numbering

  • If enabled, Inventory Details (including Lot name) are required

• Adjustment Account

• Department

• Class

• Adjustment Reason (Consumption or Create Inventory)

Data Create/Update Flow

Violet will insert and/or update ("upsert") data according to what is pre-existing in the target app. See the diagram below for a visualization of the data flow for Purchase Orders: