Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Assembly, kitting, parent/child, lot matrix? Which would be best?

Posted on by Microsoft Employee

I have a situation where we have 3 different flavors of soft drinks that can be sold as a single unit, a 6 pack, or a case (4-6 packs.)  To add to that a case can be a mixture of the 3 different flavors(2-6 packs of one flavor 2 of another, 2 of 1 and 1 each of the other 2 flavors, etc. etc.)  Prices for the single unit, 6 pack, and case all are different on a per unit(individual bottle) price.

The inventory is ordered from the vendor in 6 packs only.  For each flavor the single unit and the six pack have their own upc code.  Cases do not have their own upc code(there is a case upc but it is universal and doesn't differentiate what flavor it is for.)  For this reason I am considering eliminating the upc code for the case from our system.

For the 6 pack to case I was thinking of setting it up as a mix and match discount when a total of 4 6packs are purchased.  This would allow for the price difference as well as keeping the inventory counts for each correct.  This is the best solution that I can see for this part of the problem.

The part I cannot figure out(and I'm probably over analyzing it) is keeping up with the bottles vs 6 packs.  Any ideas?  I've looked at assembly, kitting, parent/child, and lot matrix. 

*This post is locked for comments

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Assembly, kitting, parent/child, lot matrix? Which would be best?

    Create a case, a 6 and a 1

    Parent 6 to the 1

    Assemble the case from any 6 or single

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans