Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / Configure Opportunity ...
Sales forum
Suggested answer

Configure Opportunity Split Revenues for a team

Posted on by 863

Hello,

Assuming that a team owns an opportunity that consists of 3 members.

We would like to split the revenue between these sales team members to measure their performance when working on an opportunity together.

I am aware that the Opportunity split is not available by default and we need to create that custom entity.

https://learn.microsoft.com/en-us/dynamics365/sales/configure-forecast-using-custom-rollup-entity#opportunity-split

So, for each opportunity, a sales manager should manually split the revenue across those members by going to that custom table and later on configure a forecast based on that.

What about if we set a goal for this sales member and the opportunity is won? Will the targeted amount be updated under goals management based on the revenue amount specified under the opportunity split? If so, what query do we need to set up for the goals between opportunity and opportunity split?

Can this approach be considered the most effective way to achieve the opportunity split process? Can you please provide a small example of the goal management query?

Any help is greatly appreciated.

Best regards,
EBMRay

  • Suggested answer
    Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: Configure Opportunity Split Revenues for a team

    Hi EBMRay,

    Here is a link about split revenue over members of a sales team when an opportunity is won: How to split revenue over members of a sales team when an opportunity is won - Microsoft Dynamics CRM Forum Community Forum

    Hope this link will help you!

    Best Regards,

    Sayen Zhang

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans