Item Variants

The Item Variants feature lets you group related items — such as a jacket sold in multiple colours and sizes — under a shared identity called a Style, and work with all variants of that style together on a single order line. Instead of adding and managing dozens of individual item lines on a sales or purchase order, buyers and sales staff work through a visual matrix that shows all variants at once, enter quantities per variant in one view, and let the system generate the individual order lines automatically. The feature removes repetitive line-by-line entry from high-variety ordering and replaces it with a structured, fast, and accurate workflow.

Go to UseDynamics to watch videos about the feature

Feature Overview

Each group of related items is associated with a Style. Within the style, one item is designated the Style Master — it acts as the representative product and carries the Style Template that defines the columns shown in the variant selection views. The remaining items in the group are Style Variants and inherit the style group membership. When a style master is added to a sales or purchase order, the order line acts as a header for the style; the actual quantities are distributed across the variants through the Item Variant Overview or Item Variant Matrix Order pages, which open directly from the order line. Once quantities are confirmed, the system creates or updates individual order lines for each variant automatically. Inventory levels per variant are always visible in these views, so the person entering the order can see availability before committing. A dedicated Item Variant Creation Worksheet supports bulk creation of new variant items from a template, making it efficient to introduce an entire new style into the product catalogue.

Typical Use Cases

As a sales representative taking an order for a clothing style that comes in six colours and four sizes, I want to open the Item Variant Matrix Order from the sales order line and enter quantities in a grid where colours are rows and sizes are columns, so that the 24 individual order lines are created automatically without entering each one by hand.
As a buyer placing a replenishment order for a footwear style, I want to open the Item Variant Overview from the purchase order line and see the current Inventory next to each size, so that I can set the right Quantity per variant and let the system write the purchase lines directly without switching between screens.
As a product manager onboarding a new collection of 40 variants across two styles, I want to use the Item Variant Creation Worksheet to bulk-create all variant items from a template and assign their specification values in a single operation, so that the entire collection is ready in the system before the season starts.
As an order administrator reviewing an existing sales order that contains a style, I want to use Set Style Master Filter on the order lines to hide all individual variant lines and see only the style header rows, so that I can get a clean summary of which styles are on the order and their total variant quantities.
As an inventory planner, I want to open the Item Variant Inventory Level matrix directly from the item card for a style master, so that I can see a cross-tabulation of all variants with their current inventory quantities at a glance without navigating to separate item cards for each variant.

Key Concepts

Style — the shared identity that groups all variants of the same product together. All items in the group carry the same style code.
Style Master — the item within a style group that acts as the representative product. The style master item is added to order lines; it must have a Style Template assigned and cannot have a direct quantity on the order line.
Style Variant — an individual item that belongs to a style but is not the master. Style variants receive the actual quantities that come out of the variant ordering views.
Style Template — an Import Worksheet template assigned to the style master item. It defines which specification columns appear in the variant selection views and which values are used to populate the matrix columns and rows.
Item Variant Overview — a list view that shows one row per variant item, with specification columns and fields for Quantity, Unit Price, Direct Unit Cost, Line Discount %, and Inventory. Used when variants should be ordered line by line with individual pricing.
Item Variant Matrix Order — a matrix view where one specification value (typically colour or size) becomes the columns, and the remaining specification values form the rows, with a quantity cell at each intersection. Used for fast visual quantity entry across a large number of variant combinations.
Item Variant Inventory Level — a read-only variant of the matrix view, opened from the item card, that shows inventory quantities per variant without placing an order.
Total Variant Quantity — a calculated field on the style master order line that shows the sum of quantities across all variant lines for that style. Visible directly in the order subform.
Variant Matrix Column Code — a setting in the Master Data Information Setup that controls which specification code becomes the column headers in the matrix view (for example, size). The remaining specifications form the row groupings.
Auto update price from Style Master — a setting in the Master Data Information Setup that causes the variant item prices and discounts on order lines to be recalculated based on the total ordered quantity for the style, applying quantity-break pricing rules automatically.

Relations to Other Features or Apps

Within the Master Data Information app, Item Variants rely on Information Codes and Information Values to define the variant attributes that appear as rows and columns in the matrix views. The Style Template is an Import Worksheet template, so the same template configuration drives both bulk item creation and the variant ordering experience. The variant overview and matrix pages are opened directly from the Information Matrix infrastructure, using the same column definition mechanism.

Within standard Business Central, variant order lines are standard sales or purchase lines written with the correct item number, variant code, quantity, price, and discount. They participate in the full standard order flow — shipment, invoicing, item tracking, reservation, and posting — without any special handling. Prices are retrieved through the standard Business Central price calculation engine, including customer-specific and quantity-break price lists.

The feature works alongside the Item Variant Creation Worksheet (part of the Import Worksheet feature) for initial data setup, and with the Order Matrix (part of the Information Matrix feature) for inventory planning across the item catalogue.

When This Feature Adds Value

When your product catalogue contains items sold in multiple dimensions such as colour, size, material, or configuration, and those combinations are each managed as separate item numbers in Business Central.
When sales or purchase orders regularly contain many lines for the same product family, making line-by-line entry slow and error-prone.
When pricing for a style is quantity-dependent and the correct price should be determined by the combined quantity across all variants on the order rather than per individual line.
When buyers or sales staff need to see current inventory per variant at the moment they are entering order quantities, without leaving the order document.