Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Item with different sizes/colors

editSubscribe (0) ShareShare
ReportReport
Posted on by UG Leader

Hi,

I was wondering if anyone could assist me regarding items that have different colors and or sizes.....

Let's say that we have an item that we order from our vendor. This item comes in different sized and colors. We want this item only to have one item number in our system with ability to choose the sizes/colors.

But our issue is that our vendor sells this item to us with different item numbers for each size and color of the item.

Example:

We are selling a dog collar with the item number: IT0001 - This item is available in 3 different sizes with three different colors.

Vendor has an item number for each size and color for this dog collar;

Dog Collar

Vendor Item Number

Size

Color

VN001

S

Blue

VN002

M

Blue

VN003

L

Blue

VN004

S

Red

VN005

M

Red

VN006

L

Red

VN007

S

Green

VN008

M

Green

VN009

L

Green

What we would want to do is have only one item number for this dog collar with attributes/variants for sizes and colors and make the inventory management know the difference regarding stock quantities. Each item has a different barcode also if that matters.  We would find this easier regarding our retail stores and also when connecting this through the ecommerce platform.

What is the best way to set this up in Dynamics Nav 2016 regarding inventory management and item card if possible that is?

All suggestions are welcomed!

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: Item with different sizes/colors

    Hi,

    As other Suggested you can go by Item Variants to maintain size/color for one Particular item No.

    You can also maintain the quantity and cost for same.

    Also have a look on mentioned link : community.dynamics.com/.../inventory-item-variants

    Best Regards

    Paras Mehan

  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 2,874 UG Leader on at
    RE: Item with different sizes/colors

    Hi Óðinn Thor Harðarson ,

    What you want to do is to have only one item number for this dog collar with different attributes.

    You can do this by creating the following:

    1- One ITEM for the Dog Collar.

    2- Multiple Variants by using "Stock Keeping Units" on the item.

    3- Create "Item Variant" (System Available 1 Variant Only)

    Suggested Variants as follows:

    • Blue Small.
    • Blue Medium.
    • Blue Large.

    4- Link the "Stock Keeping Units" with the "Item Variant".

    5- Cross Reference to add Vendor Item Number and Names.

    If you find this solution helpful, Click YES to Verify the answer & credit my answer to share this solution with other community members.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Item with different sizes/colors

    You can use vendor item no. as cross reference & item variant as color & size.

  • KTA Profile Picture
    KTA 1,200 on at
    RE: Item with different sizes/colors

    Using item cross reference you can solve that.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans