Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

Populate Opportunity Estimated Revenue with Actual Revenue from Quote

Posted on by Microsoft Employee

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

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

    Update-opportunity.png

    Update-opportunity.png

    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 Profile Picture
    Aileen Gusni 44,520 on at
    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:

    opprevenue.png

    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Aileen Gusni 44,520 on at
    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 Profile Picture
    Aileen Gusni 44,520 on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans