Business Central forum

Item price based on item options?

(2) Share

Report

Posted on by Hedi Daneels

477

Hi Everyone,

I am trying to find a way to implement items which have a LOT of variants.

Example, I have a chair item, which the price is based on the color.

So i have 1 chair. 30 colors. Every color has a different price.

The idea is not to add 30 different chair items in the system, but one chair, with a variable that can be changed when adding the item in the order/quote/invoice for example.

Is this supported in any way?

Regards

Categories:

Other

All responses (4)

Answers (0)

Hedi Daneels 477 on at

Like (0)

Report

RE: Item price based on item options?

Thank you very much for the detailed answer!
Suggested answer

AnkitKishore on at

Like (4)

Report

RE: Item price based on item options?

Since you have mentioned the item price, so here I presume you are referring to Sales Price

To set up 1 Item and have multiple variants each having different price for each of the variant.

Approach: Create variants of an item master. Then set up prices for each variant using Special Pricing

Step 1:Go to Item Master

Step 2: Select Variants using Action-> Item

Step 3: Set up variants with code and description

Step 4: Go to Item master and select Special Sales Prices and Discounts as present in the ribbon

Step 5: Select Set Special Prices

Step 6: Enable the variant code using the personalize -> More -> + Field -> Drag and drop the Variant code field.

Drag and drop Variant Code from the right pane (if not visible in the Sales Line)

Step 7: Enter the values as decided by you for each of the variant.

Step 8: Testing: How system would bring in the sales price for each of the variant

Pre-work: Make sure that the variant code is enabled in the Lines using the Personalize -> More -> + Field -> Click on the Lines

Rearrange the columns in the Lines

Go to Sales Order -> Create new -> Lines -> Select item (here 1900-S) and select the variant (eg. Blue and yellow here that I have created)

For Blue variant: 1900-S -> 1900B:

For Yellow variant: 1900-S -> 1900Y:
Suggested answer

Teddy Herryanto (Th... 13,183 Moderator on at

Like (1)

Report

RE: Item price based on item options?

There is Variants on the Item level. You can setup Color, Size, etc for Variants.

Most of BC, such as sales price, sales order, etc support Variant, but you might need to customize for document / report.
Suggested answer

Suresh Kulla 45,460 on at

Like (2)

Report

RE: Item price based on item options?

You can setup Variants for the Item, and setup prices using the sales price window.

www.inecta.com/item-variant-sell-by-colors-in-microsoft-dynamics-nav-2015

docs.microsoft.com/.../sales-how-record-sales-price-discount-payment-agreements

In the Special Price window, you need to show the Variant Code column and set up the price for that variant.