Relation Between OpportunityLineitem & Pricebook entry

Hi Vikas Kumar,

You may understand relation between Opportunity,Product,OpportunityLineItem,PricebookEntry and Pricebook.

Opportunity:
Opportunity object stores data of potential sales and pending sales.
One opportunity can only have one pricebook.
One opportunity can contain one or many line items.
Product:
Product object is a catalogue of items or services for sales.
A product may contain one or more different sets of prices (PriceBookEntry).
OpportunityLineItem:
List of products that link with opportunity containing data on types of products and respective prices.
One opportunity line item can only be linked to one opportunity.
One opportunity line item can only be linked to one price book entry.
PricebookEntry:
PricebookEntry object is a product entry in a pricebook.
This object allows products to be linked to standard price book or custom price book.
One price book entry is linked to only one product.
One price book entry can only appear in one pricebook.
One price book entry can be used in multiple line items. This also further creates flexibility for users to set their own prices.
Pricebook:
Pricebook object store a list of products and services for sale.
A pricebook can be used in one or more different opportunities.
A pricebook has one or more different price entries.

• This reply was modified 9 years, 10 months ago by  Satyakam.

Hi,

Opportunity relates to Opportunity Product, Opportunity Product relates to a Pricebook Entry, Pricebook Entry then relates to Product.

Hi,

1. OpportunitylineItem is junction object between opportunity and pricebookentry.
As We need PricebookEntry Id and opportunity Id while creating OpportunityLineItems.

2. PricebookEntry is a junction object between Product2 and PriceBook.
As we need Product2 Id and PriceBook2 Id while creating PricebookEntries.

Hope this helps.