Multi Month Opportunity Reporting

(1) Share

Report

Posted on by JF-27040902-0

Hi,

How do I config D365 Sales to do the following:

Create a Contract Opportunity where the total Estimate Revenue will be split over six Months

Example:

We have an opportunity for a dev to be contracted to a client for a six month period. The cost for this is $12000. This Opportunity should be split over the specified six months. The Close date is 31 Mar 2024. The contract will run from 1 May to 31 Oct 2024.

Do I create a new field in the Opportunity Form?

This must surely be a common requirement but I've not been able to source anything useful online.

Cheers

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Amit Katariya007 10,409 Moderator on at

Like (2)

Report
Copy link

Link copied!

Dear User,

You can create a calculated field which will take input as the estimated revenue and no of months.

So that you can divide it with the no of months and will get the value

Thank you,

Amit katariya

Was this reply helpful? Yes No
JF-27040902-0 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you Amit.

I'll look into that

Was this reply helpful? Yes No
Verified answer

ANInnoSolutions 534 on at

Like (1)

Report
Copy link

Link copied!
Hello Community member,

in Microsoft Dynamics 365 Sales and by Design it is not really foreseen to split amounts in an Opportunity over a specific interval. It is easily not included in the by design process. Even in the Sales Forecast Functionality it is not really possible to display splitted amounts - it is much more related to fixed price topics where an Opportunity or an Opportunity Close is related to a total amount.

To reach your goal you need to workaround it with own extensions, if really necessary.

If you often work with projects and amounts to split, maybe Dynamics 365 Project Operations would be a better fit.

Rg,

Alexander

*Due to the complex and different possibilities of deploying Dynamics 365 I highly recommend not to setup the application without some expert/partner or support. (For more information contact me under anassl@inno-solutions.info or visit www.inno-solutions.de)

*The Information comes directly from the manufacturer or provider and are validated (not guaranteed) up to date of creation of the posting.

References:

Microsoft Licensing Guide

Microsoft Doc`s/Learn

Was this reply helpful? Yes No
JF-27040902-0 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you Alexander, thought as much

Cheers

Was this reply helpful? Yes No
CU27040910-10 4 on at

Like (0)

Report
Copy link

Link copied!
To configure Dynamics 365 Sales for this requirement:

Navigate to the Opportunity entity customization.

Create a custom field for "Total Estimate Revenue" if not already present.

Additionally, create custom fields for "Start Date" and "End Date" to define the contract period.

Develop a custom plugin or workflow to split the "Total Estimate Revenue" evenly across the six months based on the contract period.

Update the Opportunity form to display these custom fields for easy input and reference.

Ensure the logic is in place to handle any adjustments or changes to the contract duration.

This approach allows you to maintain accurate financial forecasting and revenue recognition in line with the contract terms. If needed, consult with a Dynamics 365 consultant or developer for more tailored assistance. hydrogen executor

Was this reply helpful? Yes No

Join the conversation

Community site session details

Multi Month Opportunity Reporting

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Multi Month Opportunity Reporting

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates