Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

RMS Purchase Orders - Committing different values

Posted on by 90

Our company is looking to convert purchase order entries based on the quantity we receive. In other words, if we want to order one(1) case of a product and list that on the purchase order, we would like to commit the case as twelve(12) or twenty-four(24) individual cans of food received in the database, as they are sold. We have tried using MPQ and have dabbled in Parent - Child, but we are not sure what direction to towards.

Any help would be greatly appreciated. Thank you!

*This post is locked for comments

  • Dave Durrenberger Profile Picture
    Dave Durrenberger 1,620 on at
    RE: RMS Purchase Orders - Committing different values

    Hi Mattek,

    We have an Add On that will do exactly that, it is called RMS Multi Unit Receiving Calculator:

    www.syssolutionsllc.com/.../ReceivingCalculator

    System Solutions

  • Dick Harrison Profile Picture
    Dick Harrison 700 on at
    RE: RMS Purchase Orders - Committing different values

    Take care when using the Parent in a PO: the cost assigned to the Parent when the PO is committed will NOT be transferred to the Child item. This means that, although the PO total will match the subsequent Invoice, the sales margin on the Child item may not be correct.

    To avoid having to remember to adjust the Child cost whenever the Parent cost changes, we have made it a rule to always receive only those items that will be sold. The original order will have been raised in terms of the Parent, of course, but this has to be converted to Child items when the goods are received.

    Rather inconvenient, but we found our Child costs were getting hopelessly out-of-date.

    Consequently, we have now largely abandoned Parent-Child. To tie up the items when converting outer to item, we often take the Reorder Number of the outer (which must appear on the PO sent to the supplier) and add '-1' to it to signify the item within the outer. The MPQ tells us the number within the outer.

    Incidentally, due to our only considering saleable items after delivery, stock-taking becomes more straightforward.

    The same argument applies to Kits. Only separately-packaged components can be received and committed and then the kits are built so that the stock may be determined. Before stock-taking, the kits are broken out again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS Purchase Orders - Committing different values

    Sounds like to accomplish what you're looking for, you'll have to use the Parent - Child feature.

    In your case, the "Parent" item would be the case of food and is what would be entered on the purchase order.

    The "Child" item would be the individual can of food and what is actually sold.

    When you receive the Purchase Order, you receive the case (Parent item). As your individual cans of food are sold, RMS will automatically "break" one Parent into its children components.

    For example:

    I have a child item code CANS and a parent item code BOX. There are 12 CANS in each BOX.

    At the moment I have 6 CANS on hand and no full cases (0 BOX).

    I want to order another case, so I add 1 BOX to a purchase order. When I receive that purchase order, my quantity of 6 CANS will stay unchanged and my quantity of 0 BOX will go up by to 1 BOX.

    When I sell those 6 individual cans, RMS will take the BOX quantity to 0 and take the CANS quantity to 12.

    Make sense?

    MPQ won't help you with what you want to do unless you want to enter each individual can of food to the purchase order as opposed to cases. That's more for your reference so you know how many come in a full case.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans