Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Splitting purchase item into multiple pieces item

(0) ShareShare
ReportReport
Posted on by

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 149 Super User 2025 Season 1

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 57

#3
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 53 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans