Hi All,

I wrote to code to trigger to calculate the total opportunity amount on Account but the trigger is not working for After Insert event. It throwing the below error. 

"AfterDelete caused by: System.NullPointerException: Attempt to de-reference a null object:"

Here is my trigger:

trigger Opportunity_AIUD on Opportunity (after insert, after update, after delete) {
    Map<Id, List<Opportunity>> acctIdOpptyListMap = new Map<Id, List<Opportunity>>();
    Map<Id, Opportunity> OldList = new Map<Id, Opportunity>();
    Set<Id> acctIds = new Set<Id>();
    List<Opportunity> opptyList = new List<Opportunity>();
    if(trigger.isUpdate || trigger.isInsert){
        for(Opportunity oppty : trigger.New){
            if(oppty.AccountId != null){
                acctIds.add(oppty.AccountId);
            }
        }    
    }
    
    If(trigger.isafter){
    if(trigger.isDelete){
        for(Opportunity oppty : trigger.old){
            if(oppty.AccountId != null){
                acctIds.add(oppty.AccountId);
                system.debug('*******acctIds*******'+acctIds);
             
            }
        }    
    }
  }
    
   
        System.debug('*****acctIdOpptyListMap ***'+acctIdOpptyListMap);
        System.debug('*********acctIds.size()***'+acctIds.size());
  
        if (acctIds.Size()>0){
        opptyList = [SELECT ID,Amount,AccountId FROM Opportunity WHERE AccountId IN : acctIds];
        System.debug('*****opptyList'+opptyList);
        for(Opportunity oppty : opptyList){
            if(!acctIdOpptyListMap.containsKey(oppty.AccountId)){
                acctIdOpptyListMap.put(oppty.AccountId, new List<Opportunity>());
                System.debug('acctIdOpptyListMap1'+ acctIdOpptyListMap);
            }
            acctIdOpptyListMap.get(oppty.AccountId).add(oppty); 
            System.debug('acctIdOpptyListMap2'+ acctIdOpptyListMap);
        } 
        
        List<Account> acctList = new List<Account>();
        acctList = [SELECT Total_Opportunity_Amount__c FROM Account WHERE Id IN: acctIds];
        System.debug('*******acctList' + acctList);
        if (acctList.size()>0){
        for(Account acct : acctList){
            List<Opportunity> tempOpptyList = new List<Opportunity>();
            tempOpptyList = acctIdOpptyListMap.get(acct.Id);
            System.debug('******** tempOpptyList' +tempOpptyList);
            Double totalOpptyAmount = 0;
            for(Opportunity oppty : tempOpptyList){
                if(oppty.Amount != null){
                    totalOpptyAmount += oppty.Amount;
                    System.debug('********totalOpptyAmount' +totalOpptyAmount);
                }
            }
            acct.Total_Opportunity_Amount__c = totalOpptyAmount;
        }
      }
        if (acctList.size()>0){
        update acctList;
        }
    }

}

I will appreciate any help. Thanks.

Hi All,

I am getting this below error while upserting the permission set to the user object. I would appreciate someone can provide me with the correct solution. The requirement is to give one common permission to both the users.

Error: Invalid Data. 
Review all error messages below to correct your data.
Apex trigger Addpermission caused an unexpected exception, contact your administrator: Addpermission: execution of AfterUpdate caused by: System.DmlException: Upsert failed. First exception on row 0; first error: DUPLICATE_VALUE, Duplicate PermissionSetAssignment. Assignee: 00546000000aUk8; Permission Set: 0PS46000000IhId: [AssigneeId, PermissionSetId]: Class.userHandler.addPermission: line 44, column 1

Below is the class

Public class userHandler{

Public static void addPermission(List<user>newUser) 
    {
    
    List<PermissionSetAssignment> permissionSetList = new List<PermissionSetAssignment>();
    List<User> userList= [SELECT ID,UserRole.Name,Profile.Name,IsActive FROM User WHERE Profile.Name = 'Solution Manager' or Profile.Name='Marketing User' ];
    for (User u : userList)
    { 
       if(u.Profile.Name=='Solution Manager')
       {
        system.debug(u);
        PermissionSetAssignment psa1 = new PermissionSetAssignment (PermissionSetId = Label.Test, AssigneeId = u.Id);
        permissionSetList.add(psa1);
        PermissionSetAssignment psa2 =new PermissionSetAssignment (PermissionSetId = Label.CRM_Permission_Set, AssigneeId = u.Id);
        permissionSetList.add(psa2);
        }
        
        Else if(u.Profile.Name=='Marketing User')
       {
        system.debug(u);
        PermissionSetAssignment psa3 = new PermissionSetAssignment (PermissionSetId = Label.Test, AssigneeId = u.Id);
        permissionSetList.add(psa3);
        PermissionSetAssignment psa4 =new PermissionSetAssignment (PermissionSetId = Label.Service_Cloud_User, AssigneeId = u.Id);
        permissionSetList.add(psa4);
        }
   
    }
    
  Boolean isinsertfirstTime = true;
  try{  
      upsert permissionSetList;
     }catch (DMLException e) 
     {
     system.debug('exception caught' + e);
     if(isinsertfirstTime)
      {
       upsert permissionSetList;
      }
     }
 }
}

Hi All,

I wrote a test class for QuotLineItem and I am getting the below error.
Method Name    getQLI
Pass/Fail    Fail
Error Message    System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, field integrity exception: []
Stack Trace    Class.QuoteLineItemResourceTest.getQLI: line 36, column 1

The Test which I am using:

@isTest
public class QuoteLineItemResourceTest {
    public static testMethod void getQLI() {
    
        Account objaccount=new Account();
        objaccount.Name='TestAccount';
        insert objaccount;
        
        PriceBook2  objPricebook2= new PriceBook2();
        objPricebook2.Name='Standard Price Book1';
        objPricebook2.IsActive=true;
        insert objPricebook2;
        
           List<Pricebook2> objPricebook = [Select id,Name from PriceBook2 where isStandard =: true];
           Id standardPB = Test.getStandardPricebookId();
        
               
                 
         Product2 objProduct2=new Product2();
         objProduct2.Name='ABC';
         objProduct2.CurrencyIsoCode='USD';
         insert objProduct2;
         
         PricebookEntry objpricebookentry =new PricebookEntry();
         objpricebookentry.Product2ID = objProduct2.id;
         objpricebookentry.UnitPrice=23.50;
         objpricebookentry.UseStandardPrice=true;
         objpricebookentry.Pricebook2ID=standardPB;
         insert objpricebookentry;
         
         Opportunity objopportunity=new Opportunity();
        objopportunity.AccountID=objaccount.id;
        objopportunity.Name='TestOpportunity';
        objopportunity.StageName='Prospecting';
        objopportunity.CloseDate=Date.today();
        objopportunity.Pricebook2Id = standardPB;
        insert objopportunity;
         
         Quote q1 = new Quote();
         q1.Name = 'Quote 1';
         q1.Budget_Estimate__c = 100;
         q1.OpportunityId = objopportunity.Id;
         q1.Pricebook2ID=standardPB;
         insert q1;
         
         QuoteLineItem objQLI = new QuoteLineItem(QuoteId = q1.Id,
                                                Quantity = 5,
                                                UnitPrice = 10,
                                                PricebookEntryId=objpricebookentry.id,
                                                Product2ID=objProduct2.id,
                                                Operating_System_Id__c = '1;2', 
                                                Third_Party_Provider_Id__c = '3;4',
                                                Third_Party_Audience_Id__c = '5;6',
                                                Country_Id__c = '7;8',
                                                State_Id__c = '4;5',
                                                DMA_Id__c = '6;7',
                                                Content_Limitation_Id__c = '4;5',
                                                Carriers_Id__c = '1;3',
                                                Weather_Temperatures_Id__c = '2;3',
                                                Weather_Conditions_Id__c = '4;5',
                                                Geosegment_Id__c = '2;3',
                                                Start_Date__c = Date.today().addDays(1),
                                                End_Date__c = Date.today().addDays(10),
                                                Planned_Cost__c = 100,
                                                Rate__c = 10,
                                                Planned_Unit__c = 100,
                                                Cost_Method__c = 'CPM');
        insert objQLI;
    

       
       Test.startTest();
        RestRequest req = new RestRequest(); 
        RestResponse res = new RestResponse();
        req.requestURI = '/services/apexrest/QuoteLineItem/'+objQLI.Id; 
        req.httpMethod = 'GET';
        req.addHeader('Content-Type', 'application/json'); 
        RestContext.request = req;
        RestContext.response = res;
        QuoteLineItemResource.doGet();
       
   Test.stopTest();   
   
   
    }
}

I would Appreciate if anyone can help me what can cause this error?


​​​​​​​Thanks

Hi All,

I am getting below error when I run a test on a QuoteLineItem test class I created.
System.DmlException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Pricebook2Id]: [Pricebook2Id]

My test class is below:

@isTest
public class QuoteLineItemResourceTest {
    public static testMethod void getQLI() {
    
        Account objaccount=new Account();
        objaccount.Name='TestAccount';
        insert objaccount;
        
        Id standardPB = Test.getStandardPricebookId();
        
        Opportunity objopportunity=new Opportunity();
        objopportunity.AccountID=objaccount.id;
        objopportunity.Name='TestOpportunity';
        objopportunity.StageName='Prospecting';
        objopportunity.CloseDate=Date.today();
        objopportunity.Pricebook2Id = standardPB;
        insert objopportunity;
        
                 
         Product2 objProduct2=new Product2();
         objProduct2.Name='ABC';
         objProduct2.CurrencyIsoCode='USD';
         insert objProduct2;
         
         PricebookEntry objpricebookentry =new PricebookEntry();
         objpricebookentry.Product2ID = objProduct2.id;
         objpricebookentry.UnitPrice=23.50;
         objpricebookentry.UseStandardPrice=true;
         objopportunity.Pricebook2ID=standardPB;
         insert objpricebookentry;
         
         Quote q1 = new Quote();
         q1.Name = 'Quote 1';
         q1.Budget_Estimate__c = 100;
         q1.OpportunityId = objopportunity.Id;
         q1.Pricebook2ID=standardPB;
         insert q1;
         
         QuoteLineItem objQLI = new QuoteLineItem(QuoteId = q1.Id,
                                                Quantity = 5,
                                                UnitPrice = 10,
                                                PricebookEntryId=objpricebookentry.id,
                                                Product2ID=objProduct2.id,
                                                Operating_System_Id__c = '1;2', 
                                                Third_Party_Provider_Id__c = '3;4',
                                                Third_Party_Audience_Id__c = '5;6',
                                                Country_Id__c = '7;8',
                                                State_Id__c = '4;5',
                                                DMA_Id__c = '6;7',
                                                Content_Limitation_Id__c = '4;5',
                                                Carriers_Id__c = '1;3',
                                                Weather_Temperatures_Id__c = '2;3',
                                                Weather_Conditions_Id__c = '4;5',
                                                Geosegment_Id__c = '2;3',
                                                Start_Date__c = Date.today().addDays(1),
                                                End_Date__c = Date.today().addDays(10),
                                                Planned_Cost__c = 100,
                                                Rate__c = 10,
                                                Planned_Unit__c = 100,
                                                Cost_Method__c = 'CPM');
        insert objQLI;
    

       
       Test.startTest();
        RestRequest req = new RestRequest(); 
        RestResponse res = new RestResponse();
        req.requestURI = '/services/apexrest/QuoteLineItem/'+objQLI.Id; 
        req.httpMethod = 'GET';
        req.addHeader('Content-Type', 'application/json'); 
        RestContext.request = req;
        RestContext.response = res;
        QuoteLineItemResource.doGet();
       
   Test.stopTest();   
   
   
    }
}

Any help will be appreciated. Thanks.

Hi Everyone,
I have created a @HTTP get method which working fine.

@RestResource(urlMapping='/Opportunity/*')
global with sharing class OpportunityResource {
    @HttpGet
    global static Opportunity doGet() {
        RestRequest req = RestContext.request;
        RestResponse res = RestContext.response;
        String opportunity_id = req.requestURI.substring(req.requestURI.lastIndexOf('/')+1);
        Opportunity result = [SELECT Id, Name, OwnerId, CurrencyIsoCode, IO_Status__c, Agency_Buyer__c, Campaign_Summary__c, Campaign_Goals__c, KPI_s_and_success_metrics__c, Ad_Ops_Lead__c, User__c, Campaign_Performance_Analyst__c, Account_Manager__c, Discount_Off_Rate_Card__c, Viewability_Tags__c, Additional_Tags__c, Opportunity_ID__c, Quote_Flight_Start_Date__c, Quote_Flight_End_Date__c, Quote_Total_Impressions__c FROM Opportunity WHERE Id = :opportunity_id];
        return result;
    }
}

I wrote a test class but I need help with inserting test data to the test class. Can anyone help me with writing the test class with test data?

Appreciate your help.
 

Hi Friends,

Is it possible to get the Opportunity split data from a custom Opportunity split object into Opportunity object? I just need the rep name and the %split.

For example: If there are 2 reps,  rep1 with a 50% split and rep2 with a 50% split. I want to get this data in four fields in Opportunity
Opportunity Field:
rep1 Name: rep1 from Opportunity Split
rep1 %:  50%  from Opportunity Split
rep2 Name: rep2 from Opportunity Split
rep2 %:  50%  from Opportunity Split

Any help will be appreciated.

Regards,
Vikas

 

Hi All,

Need your help. I am trying to create a report where I can show Sales rep Quota Vs Actual. I had put the Quota information on User Object (Q1 Quota, Q2 Quota etc).  I created a summary report to compare their achievements with their Quota, I summarized the Sum of Q3 booked amount and Q3 Goal but when I create a chart, I am only getting one column (either sum of Q3 booked or Q3 Goal) but not both. Can anyone please help me how to get both these data fields?

Hi Friends,

I want the approval process to enter the 2nd step only if below criteria's are met.
1) Step 1 is approved
2) The amount is more than 200000
3) Attribution Report Vendor (multi-select picklist) is not null
4) Brand Study Vendor is not null.

But the Approval process is skipping the 2nd step even though Attribution Report Or Brand Study Vendor is not null.


Appreciate your help.

Also, is there a way we can Auto-Approve the Opportunity if the above criteria are true?

Thanks,
Vikas



 

Hi All,

Need your help. I have written a workflow which triggers an email with Opportunity data. But the team wants some data from the Quote (Amount, Start Date, End Date, Discount) which was created last. I know this is only possible using Visualforce email template. I have never created a Visualforce template, can anyone please help me with the template, Apex controller, and the component which I have to write to get this data.
Thanks for the help in advance.

Regards,
​Vikas

Hi Friends,

On Opportunity, I have two fields. One is LOB (Line of Business), which is a Picklist field (With Values like Managed Services, Enterprise, Partner) another Field (Rate Card) is a lookup field.

I want to Auto-populate the Rate Card Field based on the value we select for the LOB, for example, if I select "Managed Services" as LOB then I want "Rate Card X" to appear in Rate Card field. 

if I select "Enterprise" as LOB then I want "Rate Card Y" to appear in Rate Card field. 


Also, I want to Opportunity Name to say "Auto Populate-Please do not fill". 
 
I want to achieve two things.

1) Opportunity Name to reflect- (Auto Created) for all the Opportunities.
2) Based on what we select in Line Of Business, I want Rate Card to get populated on UI.



Please let me know if this we can achieve using a Visualforce page?

Regards,
Vikas
 

Hi All,

I have created a custom button on Avail object which is a related list on Opportunity.

Now, when I click on the button. The Opportunity Name is not populating.



Can anyone please help if I am missing something in the logic.



/a0O/e?CF00N500000032hk3={!Avail_Request__c.Opportunity__c}
&CF00N500000032hk3_lkid={!Avail_Request__c.OpportunityId__c}
&retURL=%2F0061g000002tm0Y

Regards,
Vikas

Hi Friends,
 
In opportunities vendor is a multiselect picklist field. I am creating a Process Builder to create a task if a with subject (“vendor-test please call”) if Vendor is “Vendor test – Contracted” or “Vendor test – Background” and if Vendor is
“Vendor – Contracted” or “Vendor– Background” it should create a task if a with subject (“vendor please call”). It is working fine is we are selecting only one value, but is failing if more than one vendor is selected.
 
 For example: if we select two picklist value Vendor – Contracted and Vendor-Paid
“Vendor – Contracted; Vendor-Paid” , the task is not getting created. Any help will be appreciated.
 
Regards,
Vikas
 

Hi All,

I wrote to code to trigger to calculate the total opportunity amount on Account but the trigger is not working for After Insert event. It throwing the below error. 

"AfterDelete caused by: System.NullPointerException: Attempt to de-reference a null object:"

Here is my trigger:

trigger Opportunity_AIUD on Opportunity (after insert, after update, after delete) {
    Map<Id, List<Opportunity>> acctIdOpptyListMap = new Map<Id, List<Opportunity>>();
    Map<Id, Opportunity> OldList = new Map<Id, Opportunity>();
    Set<Id> acctIds = new Set<Id>();
    List<Opportunity> opptyList = new List<Opportunity>();
    if(trigger.isUpdate || trigger.isInsert){
        for(Opportunity oppty : trigger.New){
            if(oppty.AccountId != null){
                acctIds.add(oppty.AccountId);
            }
        }    
    }
    
    If(trigger.isafter){
    if(trigger.isDelete){
        for(Opportunity oppty : trigger.old){
            if(oppty.AccountId != null){
                acctIds.add(oppty.AccountId);
                system.debug('*******acctIds*******'+acctIds);
             
            }
        }    
    }
  }
    
   
        System.debug('*****acctIdOpptyListMap ***'+acctIdOpptyListMap);
        System.debug('*********acctIds.size()***'+acctIds.size());
  
        if (acctIds.Size()>0){
        opptyList = [SELECT ID,Amount,AccountId FROM Opportunity WHERE AccountId IN : acctIds];
        System.debug('*****opptyList'+opptyList);
        for(Opportunity oppty : opptyList){
            if(!acctIdOpptyListMap.containsKey(oppty.AccountId)){
                acctIdOpptyListMap.put(oppty.AccountId, new List<Opportunity>());
                System.debug('acctIdOpptyListMap1'+ acctIdOpptyListMap);
            }
            acctIdOpptyListMap.get(oppty.AccountId).add(oppty); 
            System.debug('acctIdOpptyListMap2'+ acctIdOpptyListMap);
        } 
        
        List<Account> acctList = new List<Account>();
        acctList = [SELECT Total_Opportunity_Amount__c FROM Account WHERE Id IN: acctIds];
        System.debug('*******acctList' + acctList);
        if (acctList.size()>0){
        for(Account acct : acctList){
            List<Opportunity> tempOpptyList = new List<Opportunity>();
            tempOpptyList = acctIdOpptyListMap.get(acct.Id);
            System.debug('******** tempOpptyList' +tempOpptyList);
            Double totalOpptyAmount = 0;
            for(Opportunity oppty : tempOpptyList){
                if(oppty.Amount != null){
                    totalOpptyAmount += oppty.Amount;
                    System.debug('********totalOpptyAmount' +totalOpptyAmount);
                }
            }
            acct.Total_Opportunity_Amount__c = totalOpptyAmount;
        }
      }
        if (acctList.size()>0){
        update acctList;
        }
    }

}

I will appreciate any help. Thanks.

Hi All,

I wrote a test class for QuotLineItem and I am getting the below error.
Method Name    getQLI
Pass/Fail    Fail
Error Message    System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, field integrity exception: []
Stack Trace    Class.QuoteLineItemResourceTest.getQLI: line 36, column 1

The Test which I am using:

@isTest
public class QuoteLineItemResourceTest {
    public static testMethod void getQLI() {
    
        Account objaccount=new Account();
        objaccount.Name='TestAccount';
        insert objaccount;
        
        PriceBook2  objPricebook2= new PriceBook2();
        objPricebook2.Name='Standard Price Book1';
        objPricebook2.IsActive=true;
        insert objPricebook2;
        
           List<Pricebook2> objPricebook = [Select id,Name from PriceBook2 where isStandard =: true];
           Id standardPB = Test.getStandardPricebookId();
        
               
                 
         Product2 objProduct2=new Product2();
         objProduct2.Name='ABC';
         objProduct2.CurrencyIsoCode='USD';
         insert objProduct2;
         
         PricebookEntry objpricebookentry =new PricebookEntry();
         objpricebookentry.Product2ID = objProduct2.id;
         objpricebookentry.UnitPrice=23.50;
         objpricebookentry.UseStandardPrice=true;
         objpricebookentry.Pricebook2ID=standardPB;
         insert objpricebookentry;
         
         Opportunity objopportunity=new Opportunity();
        objopportunity.AccountID=objaccount.id;
        objopportunity.Name='TestOpportunity';
        objopportunity.StageName='Prospecting';
        objopportunity.CloseDate=Date.today();
        objopportunity.Pricebook2Id = standardPB;
        insert objopportunity;
         
         Quote q1 = new Quote();
         q1.Name = 'Quote 1';
         q1.Budget_Estimate__c = 100;
         q1.OpportunityId = objopportunity.Id;
         q1.Pricebook2ID=standardPB;
         insert q1;
         
         QuoteLineItem objQLI = new QuoteLineItem(QuoteId = q1.Id,
                                                Quantity = 5,
                                                UnitPrice = 10,
                                                PricebookEntryId=objpricebookentry.id,
                                                Product2ID=objProduct2.id,
                                                Operating_System_Id__c = '1;2', 
                                                Third_Party_Provider_Id__c = '3;4',
                                                Third_Party_Audience_Id__c = '5;6',
                                                Country_Id__c = '7;8',
                                                State_Id__c = '4;5',
                                                DMA_Id__c = '6;7',
                                                Content_Limitation_Id__c = '4;5',
                                                Carriers_Id__c = '1;3',
                                                Weather_Temperatures_Id__c = '2;3',
                                                Weather_Conditions_Id__c = '4;5',
                                                Geosegment_Id__c = '2;3',
                                                Start_Date__c = Date.today().addDays(1),
                                                End_Date__c = Date.today().addDays(10),
                                                Planned_Cost__c = 100,
                                                Rate__c = 10,
                                                Planned_Unit__c = 100,
                                                Cost_Method__c = 'CPM');
        insert objQLI;
    

       
       Test.startTest();
        RestRequest req = new RestRequest(); 
        RestResponse res = new RestResponse();
        req.requestURI = '/services/apexrest/QuoteLineItem/'+objQLI.Id; 
        req.httpMethod = 'GET';
        req.addHeader('Content-Type', 'application/json'); 
        RestContext.request = req;
        RestContext.response = res;
        QuoteLineItemResource.doGet();
       
   Test.stopTest();   
   
   
    }
}

I would Appreciate if anyone can help me what can cause this error?


​​​​​​​Thanks

Hi Everyone,
I have created a @HTTP get method which working fine.

@RestResource(urlMapping='/Opportunity/*')
global with sharing class OpportunityResource {
    @HttpGet
    global static Opportunity doGet() {
        RestRequest req = RestContext.request;
        RestResponse res = RestContext.response;
        String opportunity_id = req.requestURI.substring(req.requestURI.lastIndexOf('/')+1);
        Opportunity result = [SELECT Id, Name, OwnerId, CurrencyIsoCode, IO_Status__c, Agency_Buyer__c, Campaign_Summary__c, Campaign_Goals__c, KPI_s_and_success_metrics__c, Ad_Ops_Lead__c, User__c, Campaign_Performance_Analyst__c, Account_Manager__c, Discount_Off_Rate_Card__c, Viewability_Tags__c, Additional_Tags__c, Opportunity_ID__c, Quote_Flight_Start_Date__c, Quote_Flight_End_Date__c, Quote_Total_Impressions__c FROM Opportunity WHERE Id = :opportunity_id];
        return result;
    }
}

I wrote a test class but I need help with inserting test data to the test class. Can anyone help me with writing the test class with test data?

Appreciate your help.
 

Hi All,

I have created a custom button on Avail object which is a related list on Opportunity.

Now, when I click on the button. The Opportunity Name is not populating.



Can anyone please help if I am missing something in the logic.



/a0O/e?CF00N500000032hk3={!Avail_Request__c.Opportunity__c}
&CF00N500000032hk3_lkid={!Avail_Request__c.OpportunityId__c}
&retURL=%2F0061g000002tm0Y

Regards,
Vikas