Hi,

My requirement is like that...

I want to delete records from a custom object based on a criteria (if a checkbox is checked). This record is also holding some attachments. But before delete the Same record should be inserted into another Custom object  along with the attachments.(this object is also configured like this.)

I don't know why my code is not working. I 'm new to the world of trigger. Please help me.

trigger DeleteInvoicePopulatePSR on Invoice_holder__c (after Insert)
 {
  List <Invoice_holder__c> selectedInvoice= new List<Invoice_holder__c>([select Id,Amount_Open__c,name,Credits__c,Debits__c,Doc_Number__c,Due_Date__c,Order_Date__c,Paid_date__c,Payment_Referance__c,Purchase_Order__c,Sales_Order_No__c,Transaction_Type__c, (Select Id From Attachments)
   from Invoice_holder__c where ID IN:Trigger.newMap.keySet()and Seven_Years_Old__c=true]);
  List <PSR_clone__c> psrInsert=new List<PSR_clone__c>();
  List <Attachment> attlist=new List<Attachment>();
  List <Invoice_holder__c> ToBeDeleted=new List<Invoice_holder__c>();
  
   for(Invoice_holder__c i:selectedInvoice)
       {
        PSR_clone__c psrCloneInsert=new PSR_clone__c();
            psrCloneInsert.Amount_Open__c=i.Amount_Open__c;
            psrCloneInsert.Credits__c=i.Credits__c;
            psrCloneInsert.Debits__c=i.Debits__c;
            psrCloneInsert.Doc_Number__c=i.Doc_Number__c;
            psrCloneInsert.Due_Date__c=i.Due_Date__c;
            psrCloneInsert.Paid_date__c=i.Paid_date__c;
            psrCloneInsert.Transaction_Type__c=i.Transaction_Type__c;
           psrInsert.add(psrCloneInsert);
          for(Attachment att:i.Attachments )
           {
             att.parentId=psrCloneInsert.ID;

             attlist.add(att);
            }
         
         
   }
    Insert psrInsert;
    Insert attlist;
    Delete selectedInvoice;
   }