Consider a checkbox field as "abc" is checked on quote, I want to apply the change to all quote line items attached to it with the same change(I have the same checkbox field on both quote and quote line items). And similarly when the checkbox is unchecked and saved, It should do the same. I observed that I can't achieve this using field updates. Can Someone help me With how I can achieve this using apex trigger.
I am attaching my trigger that I have done sofar, but it has errors, Can some one help me to get it executed.
trigger updateabc on Quote (after insert, after update){
QuoteLineItem ql = [select abc__c from QuoteLineItem where Quote = :trigger.new[0].id ];
If a checkbox field on quote is checked can i reflect the change on all quote line items in salesforce?
Consider a checkbox field as "abc" is checked on quote, I want to apply the change to all quote line items attached to it with the same change(I have the same checkbox field on both quote and quote line items). And similarly when the checkbox is unchecked and saved, It should do the same. I observed that I can't achieve this using field updates. Can Someone help me With how I can achieve this using apex trigger.
public EO_TNQT.TaxSvc.TaxSvcSoap getTaxService() { // EO_TNQT.TaxSvc.TaxSvcSoap taxService = new EO_TNQT.TaxSvc.TaxSvcSoap( 'https://development.avalara.net' ); // Dev EO_TNQT.TaxSvc.TaxSvcSoap taxService = new EO_TNQT.TaxSvc.TaxSvcSoap( 'https://avatax.avalara.net' ); // Production EO_TNQT.TaxSvc.Security security = new EO_TNQT.TaxSvc.Security(); EO_TNQT.AddressSvc.UsernameToken_element token = new EO_TNQT.AddressSvc.UsernameToken_element();
EO_TNQT.TaxSvc.ArrayOfLine lines = new EO_TNQT.TaxSvc.ArrayOfLine(); EO_TNQT.TaxSvc.Line line;
/* line = new EO_TNQT.TaxSvc.Line(); line.No = '101'; // line.ItemCode = 'Item001'; line.TaxCode = item1TaxCode; line.Qty = 1; // line.Amount = 1000.00; line.Amount = 890.00; //added in 4.12 release // line.CustomerUsageType = 'G'; // I think the usage type is to denote tax exempt status per Anya // line.CustomerUsageType = 'ST080120'; line.Description = 'Sample Description'; lines.Line = new List<EO_TNQT.TaxSvc.Line>(); lines.Line.add( line );
// line = new EO_TNQT.TaxSvc.Line(); // line.No = '102'; //// line.ItemCode = 'FR'; // Anya also recommended sending freight over with FR as the tax code not the item code //// line.TaxCode = 'FR'; // line.Qty = 1; // line.Amount = 10.00; // lines.Line.add( line ); /**/ lines.Line = new List<EO_TNQT.TaxSvc.Line>();
line = new EO_TNQT.TaxSvc.Line(); line.No = '101'; line.ItemCode = 'IHOME'; line.TaxCode = 'P0000000'; line.Qty = 1; line.Amount = 595.00; line.Description = 'IHOME'; lines.Line.add( line );
line = new EO_TNQT.TaxSvc.Line(); line.No = '102'; line.ItemCode = 'OPP'; line.TaxCode = 'P0000000'; line.Qty = 1; line.Amount = 295.00; line.Description = 'OPP'; lines.Line.add( line );
request.Lines = lines;
EO_TNQT.TaxSvc.TaxSvcSoap taxService = getTaxService(); EO_TNQT.TaxSvc.GetTaxResult result = taxService.GetTax( request );
Taxable Amount : -------------- Non taxable Amount : ------------- Sub : -----------------(sum(Taxable and Non taxable amounts)) Tax :---------------(shld be automatically generated) Total : -------------(sum of (sub + tax))
// Update the Leads if(LeadIDs.size()>0){ for(Lead l: [Select l.Id, l.Open_Tasks_Count__C, (Select Id From Tasks where IsClosed = False) From Lead l where Id in :LeadIDs]) LeadsToUpdate.add(new Lead(Id=l.Id, Open_Tasks_Count__C = l.Tasks.size())); update LeadsToUpdate; } }
But still many leads are not updating except a few. Can anyone help on this. It needs to check each and every lead already existed and newly upcoming leads and check if there is any activity and update the count. If anyone have any other existing trigger to solve this purpose please post it along with the test code. Thank you in advance.
I just wanted to know. As an admin how can i give access or permissions to my marketing user to activate and deactivate the campaign.
I already tried enabling them as marketing user and gave all permissions to read, create, edit, delete, view all and modify all permissions on campaign still after creating a campaign they can't check it as active while creating a campaign.
I got assigned a work to implement the open task count of leads.So i implemented the trigger and wrote a test class
I got a test coverage of 78%. so i deployed it to the production and the admin is saying he got the following errors:
: TBN_CountCompletedCallsPerOpptyBatch.test_TBN_CountCompletedCallsPerOpptyBatch() Class 120 1 Failure Message: "System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, UpdateLeadOpenTasksCount: execution of AfterInsert caused by: System.NullPointerException: Attempt to de-reference a null object Trigger.UpdateLeadOpenTasksCount: line 12, column 1: []", Failure St...
TBN_TaskContactAssignTriggerHandler.test_TBN_TaskContactAssignTriggerHandler() Class 113 1 Failure Message: "System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, UpdateLeadOpenTasksCount: execution of AfterInsert caused by: System.NullPointerException: Attempt to de-reference a null object Trigger.UpdateLeadOpenTasksCount: line 12, column 1: []", Failure St...
Trigger:
trigger UpdateLeadOpenTasksCount on Task (after delete, after insert, after undelete, after update) {
// Declare the variables
public set<Id> LeadIDs = new Set<Id>(); public list<Lead> LeadsToUpdate = new List<Lead>();
// Build the list of Leads to update if(Trigger.isInsert || Trigger.isUnDelete || Trigger.isUpdate){ for(Task t: Trigger.new){ if(string.valueOf(t.WhoId).startsWith('00Q')) LeadIDs.add(t.WhoId); } }
if(LeadIDs.size()>0){ for(Lead l: [Select l.Id, l.Open_Tasks_Count__c, (Select Id From Tasks where IsClosed = False) From Lead l where Id in :LeadIDs]) LeadsToUpdate.add(new Lead(Id=l.Id, Open_Tasks_Count__c = l.Tasks.size())); update LeadsToUpdate; } }
Test class:
@isTest private class TestOpenTasksCountUpdate { static testMethod void LeadTest(){ // Create a Lead Lead newLead = new Lead(LastName='Test', Company='ABC', Status='Targeted'); insert newLead;
// Create a Task Task newTask = new Task(Subject='Open Tasks Count', Status='Not Started', WhoId=newLead.Id); test.startTest(); insert newTask; test.stopTest();
// Verify that the # Open Tasks Count is correct newLead = [select Open_Tasks_Count__c from Lead where Id=:newLead.Id ]; System.assertEquals(1,newLead.Open_Tasks_Count__c); }
static testMethod void CompletedTest(){ // Create a Lead Lead newLead = new Lead(LastName='Test', Company='ABC', Status='Targeted'); insert newLead;
// Create a Completed Task Task newTask = new Task(Subject='Open Tasks Count', Status='Completed', WhoId=newLead.Id); test.startTest(); insert newTask; test.stopTest();
// Verify that the # Open Tasks is empty newLead = [select Open_Tasks_Count__c from Lead where Id=:newLead.Id ]; System.assertEquals(0,newLead.Open_Tasks_Count__c); }
static testMethod void BatchTest(){ // Create 100 Leads List<Lead> newLeads = new List<Lead>(); for (Integer i = 0; i < 200; i++) { newLeads.add(new Lead(LastName='Test '+i, Company='ABC', Status='Targeted')); } insert newLeads;
// Create a task for each one List<Task> newTasks = new List<Task>(); for(Lead l : newLeads){ newTasks.add(new Task(Subject='Open Tasks Count', Status='Completed', WhoId=l.Id)); }
// Insert the tasks test.startTest(); insert newTasks; test.stopTest();
// We could verify that the Open Tasks fields were updated correctly, // but this is just testing the governor limits so it's not necessary } }
I want to implement a trigger to scan the activities and check whoid to see if it is a lead. if not ignore it and if it is alead i want to pull the next activity date of every lead and display it lead detail page by creating a field something like Next open Activity Date or Earliest Activity Date.
Consider a checkbox field as "abc" is checked on quote, I want to apply the change to all quote line items attached to it with the same change(I have the same checkbox field on both quote and quote line items). And similarly when the checkbox is unchecked and saved, It should do the same. I observed that I can't achieve this using field updates. Can Someone help me With how I can achieve this using apex trigger.
I am attaching my trigger that I have done sofar, but it has errors, Can some one help me to get it executed.
trigger updateabc on Quote (after insert, after update){
QuoteLineItem ql = [select abc__c from QuoteLineItem where Quote = :trigger.new[0].id ];
Consider a checkbox field as "abc" is checked on quote, I want to apply the change to all quote line items attached to it with the same change(I have the same checkbox field on both quote and quote line items). And similarly when the checkbox is unchecked and saved, It should do the same. I observed that I can't achieve this using field updates. Can Someone help me With how I can achieve this using apex trigger.
I am attaching my trigger that I have done sofar, but it has errors, Can some one help me to get it executed.
trigger updateabc on Quote (after insert, after update){
QuoteLineItem ql = [select abc__c from QuoteLineItem where Quote = :trigger.new[0].id ];
// Update the Leads if(LeadIDs.size()>0){ for(Lead l: [Select l.Id, l.Open_Tasks_Count__C, (Select Id From Tasks where IsClosed = False) From Lead l where Id in :LeadIDs]) LeadsToUpdate.add(new Lead(Id=l.Id, Open_Tasks_Count__C = l.Tasks.size())); update LeadsToUpdate; } }
But still many leads are not updating except a few. Can anyone help on this. It needs to check each and every lead already existed and newly upcoming leads and check if there is any activity and update the count. If anyone have any other existing trigger to solve this purpose please post it along with the test code. Thank you in advance.
I just wanted to know. As an admin how can i give access or permissions to my marketing user to activate and deactivate the campaign.
I already tried enabling them as marketing user and gave all permissions to read, create, edit, delete, view all and modify all permissions on campaign still after creating a campaign they can't check it as active while creating a campaign.
