NetSuite Item Records and D365 Product Data

Maps every NetSuite Item type — Inventory, Non-Inventory, Service, Kit/Package, Assembly, Matrix, and Other Charge — to the equivalent D365 released-product model. Explains the fundamental reshape from NetSuite's per-item-combination child-record matrix to D365's product-master-and-variants design, and covers per-subsidiary item settings, pricing, and preferred-vendor setup.

What you will be able to do

Introduction

NetSuite's item catalogue is the backbone of every transaction: each Item record carries not only descriptive attributes but also per-item posting accounts, cost methods, unit-of-measure sets, and subsidiary-level pricing — all bundled into a single record type.

NetSuite Item Type Taxonomy

NetSuite organises its catalogue around a type field that determines what the item can do:

Matrix Items and the Variant Reshape

Matrix Items are the most consequential item migration decision. In NetSuite, a Matrix Item is a parent item record that defines the option set (e.g. Size: S/M/L/XL; Colour: Red/Blue/Black).

Item Groups and Posting Profile Alignment

In NetSuite, an Item's posting accounts live on the Item record itself. The Income Account, COGS Account, Asset Account and Deferred Revenue Account are fields on that record — there is no accounting group sitting above them handing values down.

Units of Measure — Units Types to Unit Sequence Groups

NetSuite bundles all UOM information into a Units Type record: a named set of units with conversion factors and a flag identifying which unit is the base. The Units Type is assigned to an Item, and all transactions on that item use the conversions defined in the Units Type.

Per-Legal-Entity Release and Subsidiary-Level Settings

In NetSuite OneWorld, an item is tenant-wide; subsidiary access is controlled by the item's subsidiary list, and pricing is differentiated through Price Levels (custom price lists that can be assigned per customer or per sales transaction).

Knowledge check

Summary

NetSuite carries seven distinct Item types; most map closely to D365 released-product types, with Matrix Items requiring a fidelity reshape from per-combination child records to product-master-and-variants.