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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Configure Opportunity Split Revenues for a team

(0) ShareShare
ReportReport
Posted on by 905

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

I have the same question (0)
  • Suggested answer
    Sayen Zhang Profile Picture
    on at

    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

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans