Microsoft Dynamics CRM (Archived)

Populate Opportunity Estimated Revenue with Actual Revenue from Quote

(0) Share

Report

Posted on by Community Member

As above, how can we get the Opportunity Estimated Revenue to update the amounts added to the quote?

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

It sounds like you have Opportunities with no products on them (perfectly reasonable) and then you want to update the Estimated Revenue with the total amount from the latest Quote to be issued.

You can do this most easily using a workflow. Create a workflow for the Quote entity, triggered by status change and scope of Organization. Add a condition to check that the Quote is Active (so we don't do anything when a Quote is revised or won). Update the Opportunity to set the Estimated Revenue to the Quote's Total Amount.

You might want to check that the Revenue field (IsRevenueSystemCalculated) is set to "User Provided" by default (you can change this in the properties for the field). Otherwise, it expects to calculate the estimated revenue field from the values of products added to the opportunity.
Aileen Gusni 44,524 on at

Like (0)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

Edlyin,

First of all.

Are you actually referring to the Opportunity revenue by Quotes (Won ones)?

if yes, this is what I am referring to:

By default it's set to User Provided, you need to change its value to 'System Calculated'

You can also change the default value via CRM Customization.

Go to the Opportunity form editor then go to the field, double click and edit, go to the details, edit it after that change the default value from User Provided to System Calculated.

Please verify that this what you wanted.

Hope this helps.

Thank you.

Thanks,.
Suggested answer

Community Member on at

Like (0)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

There are 2 ways in which you can do this.

1. update the Quote Products from the Quote to the Opportunity when the Quote is Activated. Make sure there is only one active Quote or else the Products will be updated from the latest Activated Quote.

2. Update the Quote Amount to Opportunity Est. Rev when the Quote is activated. You will also have to update the Revenue bit field to User Provided. Also in this case your Opportunity Products and the Est. Rev will not match.

I would recommend the first approach. For this you will have to write a plugin or a custom workflow.
Community Member on at

Like (0)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

Aileen, thanks for your response. I'm still very new at this, so how do I set the value to System Calculation? Do i edit the field at the solutions level?
Aileen Gusni 44,524 on at

Like (0)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

Edlyin,

After you choose to system calculation

Your total will be calculated and displayed in the Est. Revenue field.

Do not use the 'user provided' instead, use the system calculated

www.crminnovation.com/.../calculatedpricing.png

Hope this helps.

Thanks.
Aileen Gusni 44,524 on at

Like (0)

Report

RE: Populate Opportunity Estimated Revenue with Actual Revenue from Quote

Edlyn,

You have set the revenue calculation to system calculation right?

Or your question here is you want to update back the Quote?

Once you set this to system calculation, the revenue from this opportunity will be calculated automatically from the Won Quote

Let's say you have 2 Quote ($100k and $200k)

Then your revenue will be $300 if both are won.

The problem is you still can change this once you click the close Opportunity, is that what you are referring to?

Thank you.