[SalesForce] Trigger to add Products to Opportunity Line Item from a custom object without Price Book

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 have this trigger but i get some errors:

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);
opportunityID.add(Oppitem.OpportunityId);
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);    
}    
}

And the error is:REQUIRED_FIELD_MISSING, Required fields are missing: [Opportunity]: [Opportunity]: Trigger.CreateOpportunityProduct: line 20, column 1

Best Answer

As the error states, you need to specify the opportunity id. Presumably, you'll find the opportunity attached to the order.

That probably looks like this:

trigger CreateOpportunityProduct on Order_Line_Item__c(after insert, after update){       
if(trigger.isUpdate)
{          
    map<id, order__c> orders = new map<id, order__c>();
List<ID> pricebookID=new List<ID>();       
List<ID> opportunityID=new List<ID>();           
List<OpportunityLineItem> newopportunitylineitemlist=new List< OpportunityLineItem>();        
    for(order_line_item__c record: trigger.new) {
        orders.put(record.order__c, null);
    }
    orders.putall([select id, opportunity__c from order__c where id in :orders.keyset()]);
for(Order_Line_Item__c orderlist: Trigger.new){    
OpportunityLineItem Oppitem=new OpportunityLineItem();
Oppitem.Quantity=orderlist.Quantity__c;
Oppitem.UnitPrice=orderlist.UnitPrice__c;
oppitem.opportunityid = orders.get(orderlist.order__c).opportunity__c;
pricebookID.add(Oppitem.PriceBookEntryId);
opportunityID.add(Oppitem.OpportunityId);
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);    
}    
}

Adjust field names as necessary.

Related Solutions

[SalesForce] Populate a Lookup Field on OpportunityLineItem with Custom Object Record Just Created from Opportunity Line Item Trigger

So you just need to link (via lookup field) to the newly created Commission__c from the LineItem record? I think you can just do it in a before trigger for OpportunityLineItem:

Create Commission__c (insert) - you automatically get the Id back for any insert
Take the Id from Commission__c's Id and stuff it in the lookup field of OLI
Since it's a before trigger, you're done - no separate update needed!

[SalesForce] How to provide relation between a custom object and Opportunity Line Item

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:

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);
}

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]);
```

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;
   ...
}

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...

Best Answer

Related Solutions

[SalesForce] Populate a Lookup Field on OpportunityLineItem with Custom Object Record Just Created from Opportunity Line Item Trigger

[SalesForce] How to provide relation between a custom object and Opportunity Line Item

Related Topic