Configure Opportunity Split Revenues for a team

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

Quick Links

Subscribe to this forum!