Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Splitting purchase ite...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Splitting purchase item into multiple pieces item

(0) ShareShare
ReportReport
Posted on by RoryvW

Hi All,

I've got a little problem. We buy spare parts from our mothercompany and we share the same Dynamics 365 (multiple entities). This means we are bound to the itemnumbers provided by them, but we can make our own itemnumbers. 

Some of the items are 5 pieces to a bag and in Dynamics it states 1 (bag of 5). We would like to split this item to  new itemnumber with 1 piece to a bag. 

What would be the best sollution in this case, without touching the production part of Dynamics? (Production part is not active)

  • RoryvW Profile Picture
    RoryvW on at
    RE: Splitting purchase item into multiple pieces item

    Hi Saud,

    Thanks for you're reply I will read the documentation. Thanks again.

  • Saud Ali Profile Picture
    Saud Ali 65 on at
    RE: Splitting purchase item into multiple pieces item

    Hi RoryvW ,

    No problem, I would suggest going through Microsoft documentation to learn how to manage relationships between two entities. If there is some relationship existing let say (1: N {One to Many}) then in this case, you can create multiple child items linked to the parent records and can show in a subgrid as well.  

    I would encourage you to go through doc, because it's really easy and you can do according to your business requirements.

    Here is the link to learn about relationship in Dynamics CRM.

    Dynamics CRM Relationships Guide

    Feel free to ask, if you have anything else.

    Thanks,

    Saud

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • RoryvW Profile Picture
    RoryvW on at
    RE: Splitting purchase item into multiple pieces item

    Hi Saud,

    I'm not realy a pro user so I hope I can awnser you well.

    We have 2 entities, I don't know how the tables are designed and how to find that. What I do know is that a lot is not set up yet.

  • Saud Ali Profile Picture
    Saud Ali 65 on at
    RE: Splitting purchase item into multiple pieces item

    Hi RoryvW ,

    Can you please provide some technical details how you've currently designed your tables in Dynamics CRM? Are you using Product Catalogue or having custom entities?

    If you can provide more details, it would be easy to suggest right solution according to your design.

    Moreover, it is possible in Dynamics CRM to have parent child relationship (Like 1 Bag contains multiple Product Items 1: N) and Auto-generated columns as well.

    Thanks,

    Saud

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans