Hello,

I am a newbie to apex coding, but trying to figure out a way to override the opportunity amount once opportunity products have been added. Through research, I was able to write a trigger that allows my sales reps to override the amount on an opportunity with Opportunity products. BTW, we utilize BigMachines for quoting, so the opportunity products are sync'd over from BigMachines each time the quote is updated. 

As I mentioned before, this solution works, but in order to remove the override flag and revert back to the quote amount, the salesrep must go back into BigMachines and re-save the quote record to initiate the product update thus updating the amount. What I would like to do is figure out a way to insert logic in the For statement that will either replace the Unit Price with "RealAmount" if the override flag = true  OR utilize Unit Price if override flag is not True.

Any ideas? Trigger code is below:

trigger OverrideLISalesPrice2 on Opportunity (after insert,after update) {
List<Id> oppIds = new List<Id>{};

for (Opportunity o : Trigger.new)

{
if (o.Use_Actual_Amount__c == True && o.HasOpportunityLineItem == true)
    oppIds.add(o.id);
}

 List<OpportunityLineItem> theLines = [SELECT Id,UnitPrice,RealAmount__c FROM OpportunityLineItem WHERE OpportunityId IN :oppIds];
 
   
    for(OpportunityLineItem OLI : theLines)  
                    {  
                        OLI.UnitPrice = OLI.RealAmount__c;  
                    }  
                update theLines;