[SalesForce] Trigger On Order to get Opportunity Line Item from opportunity to add in orderlineitem11

My requirement is that I am trying to create a trigger which is after insert and after update whenever i create order the opportunity line item will be added to the order line item. I have created lookup relationship from order to opportunity.

But when I am trying to edit and save the order object order items are updating with same names, ex: opportunity line item has two products like A,B when I am edit and save order items are updating A,B,A,B. Again when I edit and save order items are updating like A,B,A,B,A,B.

My requirement is to create line items only once with same name, and if different product is added like A,B,C. C product should be added to the order items when I edit and save order object. Can anyone help me

trigger creatingMenuDetails on Order (after insert, after update)
{
    // Get all related opportunities from orders
    Set<Id> opportunityIds = new Set<Id>();
    List<Order> orderList = new List<Order>();
    for(Order o : Trigger.new)
    {
        if(o.Opportunity__c != NULL)
        {
            opportunityIds.add(o.Opportunity__c);
            orderList.add(o);
        }
    }

    // Query for all opportunities with their related opportunity line items
    Map<Id, Opportunity> oppsWithLineItems = new Map<Id, Opportunity>([SELECT Id, (SELECT Description,Id,ListPrice,Name,OpportunityId,Product2Id,ProductCode,Quantity,TotalPrice,UnitPrice FROM OpportunityLineItem) WHERE Id IN :opportunityIds]);

    if(opportunityIds.size() > 0)
    {
        // Loop through orders
        List<OrderItem> orderItemsForInsert = new List<OrderItem>();
        for(Order o : ordersList)
        {
            // For each order get the related opportunity and line items, loop through the line items and add a new order line item to the order line item list for each matching opportunity line item
            Opportunity oppWithLineItem = oppsWithLineItems.get(o.Opportunity__c);
            for(OpportunityLineItem oli : oppWithLineItem.OpportunityLineItems)
            {
                orderItemsForInsert.add(new OrderItem(AvailableQuantity=Quantity,OrderId=o.Id,etc,etc,etc));
            }
        }
        // If we have order line items, insert data
        if(orderItemsForInsert.size() > 0)
        {
            insert orderItemsForInsert;
        }
    }
}

Best Answer

The reason you are getting duplicates is because when you insert the OrderItem (on after insert), this causes an OOTB roll up summary (on Order.TotalAmount) to execute on parent Order that then causes the on after update sequence to fire.

Or, you may have PB or WFR on Order that updates the Order once it is inserted (and hence on after update fires (again). Or you may have custom RSF or DLRS on Order:OrderItem

How you resolve this is application specific but at first blush, the approach might be

When Order is created, copy the OpportunityLineItem
When OpportunityLineItems are changed (added/updated/deleted), resync to OrderItem (presumably once Opportunity is closed, this can't happen)

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