5

I have custom objects named Order and Order Line Item, just like Opportunity and Opportunity Line Item, they have same fields and relationships but Order Line Item has no need for Pricebook, products can be added directly. Also Order object has Lookup to Opportunity so every Order has a related Opportunity. What I need is when add a product to Order Line Item of the Order, same product must be added to Opportunity Line Item of the related Opportunity. I cannot give Lookup between Order Line Item and Opportunity Line Item, so don't know how get Opportunity, PriceBookEntryId values. I tried it in this trigger:

trigger CreateOpportunityProduct on Order_Line_Item__c(after insert, after update){
    List<OpportunityLineItem> OppLineList = new List<OpportunityLineItem>();
    for(Order_Line_Item__c OrderLineObj : Trigger.new){
        OpportunityLineItem OppL = new OpportunityLineItem(
            Opportunity=OrderLineObj.?,  //Opportunity field is required but I don't know how to get it. 
            PricebookEntryId=OrderLineObj.Price_Book__c,  //I done a lookup named Price_Book__c to Price Book object but I don't know if it's helps.
            UnitPrice=OrderLineObj.UnitPrice__c,
            Quantity=OrderLineObj.Quantity__c
        );
        OppLineList.add(OppL);
    }
    if(OppLineList.size()>0)
        insert(OppLineList);
}

I write this trigger now but still having some errors, how can I make it run:

trigger CreateOpportunityProduct on Order_Line_Item__c(after insert, after update){   
if(trigger.isInsert){   
   List<ID> pricebookID=new List<ID>();
   List<ID> opportunityID=new List<ID>();  
List<OpportunityLineItem> newopportunitylineitemlist=new List< OpportunityLineItem>();
    for(Order_Line_Item__c orderlist: Trigger.new){
OpportunityLineItem Oppitem=new OpportunityLineItem();
Oppitem.Quantity=orderlist.Quantity__c;
Oppitem.UnitPrice=orderlist.UnitPrice__c;
pricebookID.add(Oppitem.PriceBookEntryId); //Error: Compile Error: Invalid field PriceBookEntryId for SObject Order_Line_Item__c at line 11 column 17
opportunityID.add(Oppitem.OpportunityId); //Error: Compile Error: Invalid field OpportunityId for SObject Order_Line_Item__c at line 12 column 19
newopportunitylineitemlist.add(Oppitem);}
List<Order__c> orderlist= new List<Order__c>([Select Id,Opportunities__c From Order__c Where Opportunities__c IN:opportunityID]);   
List<PricebookEntry> pricebookentrylist = new List<PricebookEntry>([Select Id,Product2Id From PricebookEntry Where Id IN:pricebookID]); 
if(newopportunitylineitemlist.size()>0)
insert(newopportunitylineitemlist);}
}
6
  • 1
    Spring 14 has a new Order object, You may want to take a look at that if you are still in the implementation phase. org62.my.salesforce.com/help/pdfs/en/… Jan 14, 2014 at 15:04
  • I know, but Order object here must be custom object.
    – user5204
    Jan 14, 2014 at 15:06
  • Just wanted to make sure you were aware that there was some standard functionality coming very soon that might solve some of your issues. Jan 14, 2014 at 15:07
  • @DanielHoechst - have you just exposed your SF domain? na1, eu1 or login would work equally well...
    – eyescream
    Jan 14, 2014 at 16:11
  • @eyescream, I must have been logged into Salesforce's main org when I grabbed that link. I'm in a customer chatter group there. Jan 14, 2014 at 17:50

1 Answer 1

8

You cant' make a lookup to OpportunityLineItem. Best you could do is some Text(18) field filled in with triggers. You could make the lookup from Opp Line Item to Order Line Item but it'd look bit stupid (Order -> Opportunity but Opp LI -> Ord LI).

Nonetheless - a rough idea how to fetch Opps because that's a start anyway:

  1. Fetch Orders related to line items from current trigger's scope.

    Set<Id> orderIds = new Set<Id>();
    for(Order_Line_Item__c oli : trigger.new){
        orderIds.add(oli.Order__c);
    }
    
  2. Fetch Opportunities (and Pricebook selections on them) that these Orders point to. Consult http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_erd_products.htm to understand the relations

    Map<Id, Order__c> ordersMap = new Map<Id, Order__c>([SELECT Id, Name,
        Opportunity__c, Opportunity__r.Pricebook2Id
        FROM Order__c
        WHERE Id IN :orderIds]);
    
  3. To create an Opp Line Item you need Opportunity Id:

    for(Order_Line_Item__c oli : trigger.new){
       Id oppId = ordersMap.get(oli.Order__c).Opportunity__c;
       ...
    }
    
  4. and PricebookEntryId (I'm skipping the price, quantity etc). That one will be tricky because we don't know what do you have on the line items? Lookup to Product2? What do people actually fill in? You said you've made a lookup to pricebook, but it might be bit of duplicate info (the pricebook entry you'll end up picking has to match the opportunity's pricebook or the line won't save). You will need a query similar to this:

    SELECT Id, Pricebook2Id,Product2Id
    FROM PricebookEntry
    WHERE Pricebook2Id = :ordersMap.get(oli.Order__c).Opportunity__r.Pricebook2Id
    AND Product2Id = :oli.Product__c
    

Of course if you'll store say product names on Order line items, you could go ... AND Product2.Name = 'Generator' in that last line. You might also get multiple entries for that product in the pricebook if you have multiple currencies for example...

Up to you how to go from here...

10
  • Thanks. How can I use your codes in my trigger? Order object has lookup only to Opportunity(Opportunities__c). Order Line Item has lookup to Order(Order__c),Product(Product2__c) and Pricebook(Price_Book__c). Those are enough or do I need any other relationships? And what is Opportunity__r in your code?
    – user5204
    Jan 14, 2014 at 18:16
  • Opportunity__r is a way to access fields from Opportunity to which Order__c.Opportunity__c field will point. If you've never seen "dots" in Salesforce queries - they're bit like JOIN constructions from normal databases. Compare with SELECT Account.Name, Account.Owner.Name FROM Contact and check salesforce.com/us/developer/docs/dbcom_soql_sosl/Content/…
    – eyescream
    Jan 14, 2014 at 18:54
  • I want to use your codes but cant use them with my trigger, can you help with the making trigger? I posted a new trigger, can you help me to place your codes in that trigger please because I tried and get errors.
    – user5204
    Jan 15, 2014 at 9:04
  • Does your company use Currencies?
    – eyescream
    Jan 15, 2014 at 13:30
  • Sorry I didnt understand.
    – user5204
    Jan 15, 2014 at 13:58

You must log in to answer this question.