NetSuite data syncs

Syncing Inventory Adjustments will adjust inventory levels according to the configuration settings provided, including Inventory Adjustment Account, Department, Class, Adjustment Reason, Bin/Lot, etc.

This functionality launches on August 4, 2025. Check back soon for more info!

When a Purchase Order (PO) syncs to NetSuite, the Vendor, Shipping Address (as a Location), and Items on each PO line are synced first. Our process handles this automatically, but it does mean the source data must meet certain setup requirements.

To make sure your PO syncs without errors, double‑check the following:

• Each PO line must include a valid Item or Part

  • If any PO line is missing an Item, NetSuite will reject the entire PO during sync.

• The PO must include a Vendor and Shipping Address

  • These are required by NetSuite to create the PO. If either is missing, the sync will fail.

• Your NetSuite permissions must be set up correctly

  • Missing permissions can block POs from syncing. The full list of required permissions is available in the Configure NetSuite to connect section.

• The NetSuite integration must be configured correctly

  • The following fields must be filled out in the NetSuite Integration Configuration Panel for POs to sync. See the below section Populating Required Fields for more info.

    • Tax Schedule ID

    • Income Account

    • COGS Account

    • Asset Account

This functionality launches on August 4, 2025. Check back soon for more info!

Currently, Violet supports syncing data from NetSuite to ION.

The ability to sync into NetSuite will be live on August 4, 2025. Check back soon for details.

Use this field to specify a default Tax Schedule for any Items that Violet updates or creates in NetSuite.

To find this, navigate to your preferred Tax Schedule in NetSuite. This can be found by navigating to Setup > Accounting > Tax Schedules, then selecting your desired Tax Schedule. The number at the end of the URL when viewing a Tax Schedule will be the NetSuite ID - copy this ID and enter it in Violet:

Provide the Income Account Number to be used for Items in NetSuite.

Provide the Cost of Goods Sold (COGS) Account number to be used for Items in NetSuite.

Provide the Asset Account Number to be used for Items in NetSuite.

Use this field to specify a Purchase Order Line Item Promise Date based on custom fields you have enabled in NetSuite.

Custom fields can be found by navigating to Customization > Lists, Records, & Fields > Transaction Line Fields. Locate the custom field you'd like to use for PO Line Item Promise Date, copy the value under "ID", and enter it in Violet:

Use this field to specify an Item Revision based on custom fields you have enabled in NetSuite.

Custom fields can be found by navigating to Customization > Lists, Records, & Fields > Item Fields. Locate the custom field you'd like to use for Item Revisions, copy the value under "ID", and enter it in Violet:

If you're not using the default Address fields, you can use this to specify which custom field(s) you use.

Custom fields can be found by navigating to Customization > Lists, Records, & Fields > Entity Fields. Locate the custom field(s) you'd like to use, copy the value(s) under "ID", and enter in Violet.

If you need to combine multiple fields (like street, city, and state), separate them with a comma and a space (e.g., 'streetField, cityField, stateField').