web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS Purchase Orders - ...
Microsoft Dynamics RMS (Archived)

RMS Purchase Orders - Committing different values

(0) ShareShare
ReportReport
Posted on by Mattek 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member 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.

  • 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.

  • Dave Durrenberger Profile Picture
    Dave Durrenberger 1,622 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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans