Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Item with different sizes/colors

(0) ShareShare
ReportReport
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!

*This post is locked for comments

  • 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 3,049 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 78 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans