Activity Forums Salesforce® Discussions Relation Between OpportunityLineitem & Pricebook entry

  • Satyakam

    Member
    December 14, 2016 at 7:33 am

    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 7 years, 11 months ago by  Satyakam.
  • Vikas Kumar

    Member
    January 4, 2017 at 5:36 am

    Hi Satyakam,

    thanks for the answer

  • chanchal kumar

    Member
    September 13, 2018 at 7:08 am

    Hi,

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

  • Parul

    Member
    September 13, 2018 at 9:33 am

    Hi,

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

    Thanks.

  • shariq

    Member
    September 14, 2018 at 1:24 am

    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.

Log In to reply.

Popular Salesforce Blogs