Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Item with different sizes/colors

Posted on by Microsoft Employee

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 User Group 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans