Print      Open PDF Version of Online Help

Sales > Opportunities > Managing Opportunities > Linking Products to Opportunities

Linking Products to Opportunities

You can link products to opportunities to:

• Track which products belong to the opportunity
• Calculate opportunity revenue based on product revenue
• Base your company’s forecasts on product revenue and product quantities

You can also link a product to an opportunity when you create the opportunity. If your company administrator has enabled the Save and Add Product button on the Opportunity Edit page, you can click the Save and Add Product button to save the new opportunity record and navigate directly to the Product Revenue Edit page. If you cancel adding the product revenue record, then Oracle CRM On Demand displays the Opportunity Detail page for the previously saved opportunity record.

If your user role has at least one of the following privileges, then you can use the Mass Update feature to update the values in a group of product revenue records linked to an opportunity at the same time:

• Mass Update Any Field
• Mass Update Editable Fields Available on the Page Layout

The Mass Update button is available in the Opportunity Product Revenues section of the Opportunity Detail page and is also available in the Opportunity Product Revenue List page, which opens when you click the Show Full List link in the Opportunity Product Revenues section of the Opportunity Detail page.

NOTE: If your user role has the Mass Update Editable Fields Available on the Page Layout privilege and does not have the Mass Update Any Field privilege, then the set of fields that you can update through the Mass Update feature might be restricted. For more information about how the privileges determine which fields you can update, see Updating Groups of Records.

About Updating Opportunity Totals

Depending on your company setup, the revenue and expected revenue on an opportunity might be automatically updated when you update the products that are linked to the opportunity. If your administrator selects the Enable Automatic Update of Opportunity Totals option on the company profile, then the revenue and expected revenue on an opportunity are automatically updated whenever you make a change to a product that is linked to that opportunity. Similarly, the revenue and expected revenue on an opportunity are automatically updated when you link a product to the opportunity, or remove a product from the opportunity.

If your administrator does not select the Enable Automatic Update of Opportunity Totals option on the company profile, then the revenue and expected revenue on an opportunity are not automatically updated when you update the products that are linked to the opportunity. Instead, the Update Opportunity Totals button is available in the title bar of the Opportunity Product Revenues related information section in the Opportunity Detail page. To update the revenue and expected revenue on the opportunity after you make a change to any of the products that are linked to an opportunity, you must click the Update Opportunity Totals button.

For the Update Opportunity Totals button to work correctly, the Quantity and Revenue fields on the Product Revenue Edit page must be displayed and populated. Your administrator can customize your page layout to make these fields available.

About Product Probability Averaging

When the opportunity revenue is calculated, the calculation that is performed depends on whether the Product Probability Averaging Enabled option is enabled on the company profile, as follows:

• If the Product Probability Averaging Enabled option is selected, then Oracle CRM On Demand uses each linked product to update the Revenue field and the Probability percentage field on the opportunity. Therefore, the Expected Revenue is calculated using the average probability for all linked products.
• If the Product Probability Averaging Enabled option is not selected on the company profile, then Oracle CRM On Demand uses the total product revenue for each linked product to update the Revenue field on the opportunity. The value in the Probability percentage field on the opportunity is not updated. Therefore, the Expected Revenue is calculated using the existing percentage in the Probability percentage field on the opportunity.

NOTE: The method of calculating the Expected Revenue is the same regardless of the setting of the Enable Automatic Update of Opportunity Totals check box on the company profile.

Before you begin:

• Your company needs to inform you of the forecasting method it wants to use. The company forecasting method determines which fields you must select when linking products to your opportunities.
• To update a group of records, your user role must have at least one of the following privileges: Mass Update Any Field, or Mass Update Editable Fields Available on the Page Layout.

To link products to opportunities

1. Select the opportunity.

   For instructions on selecting opportunities, see Finding Records.

2. On the Opportunity Detail page, scroll down to the Opportunity Product Revenues section and do one of the following:
   • To link a product, click Add.
   • To update product information, click the Edit link next to the existing product.
3. On the Opportunity Product Revenue Edit page, fill in the Quantity, Purchase Price, and Close Date fields.
4. If the product represents recurring revenue, fill in the Frequency and # of Periods fields in the Recurring Revenue Information section.
5. If your company forecasts revenue based on product revenue, and you want to include this product revenue record as part of your forecasted revenue totals, or your forecasted quantities, or both, select the Forecast check box.

   NOTE: If your company forecasts revenue, based on opportunities, rather than products, it is best not to select the Forecast check box on the Opportunity Product Revenue record.

6. Save the record.

To calculate opportunity revenue based on linked product revenue

1. Select the opportunity.

   For instructions on selecting opportunities, see Finding Records.

2. On the Opportunity Detail page, scroll to the Product Revenues section and do one of the following:
   • To link a product, click Add.
   • To update product information, click the Edit link next to the existing product. (If inline editing is enabled, you can edit the Product Revenues fields inline on the Opportunity Detail page; for more information about editing fields in related information sections, see Updating Linked Records from Main Records.)
3. On the Opportunity Product Revenue Edit page, fill in the Quantity, Purchase Price, and Start/Close Date fields.
4. If the product represents recurring revenue, fill in the Frequency and # of Periods fields in the Recurring Revenue Information section.
5. Save the record.
6. If the Update Opportunity Totals button is available in the Opportunity Product Revenue section of the Opportunity Detail page, then click Update Opportunity Totals to update the opportunity totals.

   This totals the product revenue for each linked product and displays it in the Revenue and Expected Revenue fields for the Opportunity.

To base your company’s forecasts on product revenue records

1. Select the opportunity.

   For information on selecting opportunities, see Finding Records.

2. On the Opportunity Detail page, scroll to the Opportunity Product Revenues section, and do one of the following:
   • To link a product, click Add.
   • To update product information, click Edit. (If inline editing is enabled, you can edit the Opportunity Product Revenues fields inline on the Opportunity Detail page. For more information about editing fields in related information sections, see Updating Linked Records from Main Records.)
3. On the Opportunity Product Revenue Edit page:
   1. Fill in the Quantity, Purchase Price, and Start/Close Date fields.
   2. Make sure that the date in the Start/Close Date field falls within the forecast period, and that the record is owned by a forecast participant.
   3. Select the Forecast check box to indicate that you want this record information to contribute to your forecast revenue totals.
   4. If the product represents recurring revenue, fill in the Frequency and # of Periods fields in the Recurring Revenue Information section.
4. Save the record.

   NOTE: If a product is not sold, you can update the associated Start/Close date and deselect the Forecast check box on the Product Revenue page for that product to prevent the revenue for the product from being added to your company's forecasts. Alternatively, if one of several products linked to the opportunity is on hold, you can remove the product from the opportunity, and create another opportunity for that product to prevent its revenue from being included in the forecast.

To update a group of opportunity product revenue records

1. In the Opportunity Detail page, scroll to the Opportunity Product Revenues section, and do one of the following:
   • If you want to update only the records that are currently displayed in the Opportunity Product Revenues section, then click Mass Update.
   • If you want to update more records than are currently displayed in the Opportunity Product Revenues section, click Show Full List to open the list of opportunity product revenue records, and then click Mass Update in the Opportunity Product Revenue List page.

     NOTE: When you click Mass Update in the Opportunity Product Revenue List page, only the records that are displayed in the Opportunity Product Revenue List page are available for you to update. For example, if you display only 10 records in the Opportunity Product Revenue List page, then only those 10 records are available for you to update. You can display a maximum of 100 records in the Opportunity Product Revenue List page. If there are more than 100 records in the list, then you can repeat the task until all of the records are updated.

2. In Step 1, clear the check box for the records you do not want to update, and then click Next.
3. In Step 2, select the fields that you want to update, and enter new values for those fields.

   You can select up to five fields to update to new values. To remove existing values from a field, leave the Value column blank in Step 2.

4. Click Finish.

Opportunity Product Revenue Fields

The following table describes field information for product revenue. Your administrator can add, relabel, or delete fields, so the fields you see might differ from those in this table.

CAUTION: If your company bases its forecasts on products, the information that you enter for product revenue can affect its calculations.