Edit

Opportunity tables

The Opportunity table represents a potential sale to new or established customers. It helps you forecast future business demands and sales revenues. You can create a new opportunity in Dynamics 365 for Customer Engagement to monitor an inquiry from your existing customer, or convert a qualified lead into an opportunity. Salespeople often use opportunities to keep track of the sales engagements that they're currently working on.

You can track the estimated revenue, estimated close date, and rating of the opportunity and what stage the opportunity is in. You can track the potential customer's name and salesperson's name. You can monitor activities related to the potential sale, such as telephone calls, email messages, and tasks.

An opportunity must be associated with one account or contact. An account and a contact can have links to multiple opportunities. Opportunities contain competitor information that helps you analyze and find effective selling strategies.

Each opportunity can have multiple products associated with it. The opportunity product table represents an association between an opportunity and a product.

After you determine whether the prospective customer or an existing customer wants to purchase your product or service, you can close an opportunity. When you close an opportunity, you deactivate it, but you don't delete it. This deactivation gives you an option to reopen it later. When you close an opportunity, you create an opportunity close activity. The opportunity close table represents this activity. You can use this table to store information about the revenue, why you closed the opportunity, close date, and the competitor. It also contains the information about the user that created the opportunity.

To provide a complete set of information about the sales engagement, associate the following tables with an opportunity: activities, notes and attachments, competitors, quotes, orders, and sales literature.

Creating an Opportunity
Converting an Opportunity to a Quote, Sales Order or Invoice
Opportunity table
Opportunity Product (OpportunityProduct) table
Opportunity Close (OpportunityClose) table
Sample: Create an Opportunity (Early Bound)
Sample: Retrieve an Opportunity (Early Bound)
Sample: Convert an Opportunity to a Quote (Early Bound)
Sales Entities
Quote, order, and invoice entities
Set default price level for opportunity, quote, order, invoice