• sekhar y 1
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 4
    Replies
trigger newSOL on Sales_Order_Line__c (Before Update) {

 String orderItemId,childOrderItemId;
 Decimal Diff, childAdjustedPrice,parentAdjustedPrice,parentUnitPrice,childUnitPrice,ratio,newChildAdjustedPrice;
 
if( Trigger.isUpdate )
{
    for (Sales_Order_Line__c orderLine: Trigger.new) {
            
         orderItemId = String.ValueOf(orderLine.OrderItemID__c);
         parentAdjustedPrice = orderLine.Adjusted_Price__c;
         parentUnitPrice = orderLine.Unit_Price__c;

        list<Sales_order_Line__c> childOrderLines= [select Product__c,Unit_Price__c,Adjusted_Price__c,Parent_OrderItemID__c,OrderItemID__c from Sales_Order_Line__c where Parent_OrderItemID__c =: orderItemId];
        List<Sales_Order_Line__c> recordsToBeUpdated = new List<Sales_Order_Line__c>();
         
        for(Sales_Order_Line__c l: childOrderLines)
        {
                    
             childOrderItemId = String.ValueOf(l.OrderItemID__c);
             childUnitPrice = l.Unit_Price__c;
             ratio = childUnitPrice / parentUnitPrice;
             childAdjustedPrice = l.Adjusted_Price__c;
            // Diff = parentUnitPrice - parentAdjustedPrice ; 
             newChildAdjustedPrice = ratio * parentAdjustedPrice;
             
              if(String.valueOf(l.OrderItemID__c) == childOrderItemId){
                 recordsToBeUpdated.Add(new Sales_Order_Line__c(Adjusted_Price__c= newChildAdjustedPrice));
             }
             
           Database.update(recordsToBeUpdated);
        }
 
        
       }
}
}

getting this error, please help me

Error:Apex trigger newSOL caused an unexpected exception, contact your administrator: newSOL: execution of BeforeUpdate caused by: System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []: Trigger.newSOL: line 31, column 1
trigger newSOL on Sales_Order_Line__c (Before Update) {

 String orderItemId,childOrderItemId;
 Decimal Diff, childAdjustedPrice,parentAdjustedPrice,parentUnitPrice,childUnitPrice,ratio,newChildAdjustedPrice;
 
if( Trigger.isUpdate )
{
    for (Sales_Order_Line__c orderLine: Trigger.new) {
            
         orderItemId = String.ValueOf(orderLine.OrderItemID__c);
         parentAdjustedPrice = orderLine.Adjusted_Price__c;
         parentUnitPrice = orderLine.Unit_Price__c;

        list<Sales_order_Line__c> childOrderLines= [select Product__c,Unit_Price__c,Adjusted_Price__c,Parent_OrderItemID__c,OrderItemID__c from Sales_Order_Line__c where Parent_OrderItemID__c =: orderItemId];
        List<Sales_Order_Line__c> recordsToBeUpdated = new List<Sales_Order_Line__c>();
         
        for(Sales_Order_Line__c l: childOrderLines)
        {
                    
             childOrderItemId = String.ValueOf(l.OrderItemID__c);
             childUnitPrice = l.Unit_Price__c;
             ratio = childUnitPrice / parentUnitPrice;
             childAdjustedPrice = l.Adjusted_Price__c;
            // Diff = parentUnitPrice - parentAdjustedPrice ; 
             newChildAdjustedPrice = ratio * parentAdjustedPrice;
             
              if(String.valueOf(l.OrderItemID__c) == childOrderItemId){
                 recordsToBeUpdated.Add(new Sales_Order_Line__c(Adjusted_Price__c= newChildAdjustedPrice));
             }
             
           Database.update(recordsToBeUpdated);
        }
 
        
       }
}
}

getting this error, please help me

Error:Apex trigger newSOL caused an unexpected exception, contact your administrator: newSOL: execution of BeforeUpdate caused by: System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []: Trigger.newSOL: line 31, column 1
Hi,

I am looking for someone to do some freelance reports and dashboard creating. Not too dificult, I just do not have the time to devote to it. Please email me if you have free time and extra enegery. We can discuss the fees.