cloudanswers

CloudAnswers

for-developers

For Developers


**Background:**

Quotes in Salesforce represent a proposal of prices for your company’s products and services to a particular prospect. If the Quote object is enabled on your page layout, a Sales Rep can generate a Quote from an Opportunity and its Line Items (OLIs). Each Opportunity can have multiple associated Quotes, and any one of them can be synced with the Opportunity. When a Quote and an Opportunity are synced together, any change to product line items on the Quote syncs with Products on the Opportunity, and vice versa. All this is standard Salesforce functionality.

**Problem:**

However, this sync only happens for standard fields on the line items, not for custom fields. Since product pricing tends to be complex and requires flexibility for most businesses, this means that many OLIs have custom calculation fields that are central to a business's pricing offers. Some examples where custom fields might be lurking are annualised pricing calculations for products sold at a monthly unit price, custom descriptions or names to display to customers on the Quote document, or custom date ranges for ongoing services.

Let's take a look at an example of this issue in action.

Here's an Opportunity record with no products or quotes initially:

[![](/uploads/OpportunityRecord.png)](https://2.bp.blogspot.com/-6IXJmM4PJjc/WQhGg2lI61I/AAAAAAAABGM/VzehK5zZzvw3b69MfDJs7wGvgk-qsRqtwCLcB/s1600/OpportunityRecord.png)

Let's add a Quote to this Opportunity record by clicking "New Quote":

[![](/uploads/Quote%2Brecord.png)](https://2.bp.blogspot.com/-x5qSnnPyj3Y/WQhKf3sgsWI/AAAAAAAABGc/YLsrLRyJ-zoJvN_LIV3egKrqQdtJK4_TACLcB/s1600/Quote%2Brecord.png)

And add some products to the Quote (i.e Quote Line Items):

[![](/uploads/products%2Bunder%2Bquotes.png)](https://2.bp.blogspot.com/-4tILxUwwgHs/WQhL8irgZkI/AAAAAAAABGs/jCKhUzpQxW842y1Z6KGgucg_fFv4_j9SACLcB/s1600/products%2Bunder%2Bquotes.png)

Now when we click the "Start Sync" button on the Quote, it populates all Quote line items to the associated Opportunity (i.e it creates matching Opportunity Line Items).

[![](/uploads/products%2Bunder%2Bopportunity.png)](https://3.bp.blogspot.com/-Qz_RdNhYoEo/WQhMpwPDT8I/AAAAAAAABG0/OsmPzd7-S30fleXA-RaMcgNs24h97ppSACLcB/s1600/products%2Bunder%2Bopportunity.png)

So far so good.

If you change any value on a Quote line item, it will immediately reflect that value on the respective OLI.  But what about that cool custom field I made to tag whether this product is a renewal of a previous contract?? There's no point-and-click approach to map Opportunity Line Item fields with Quote line item fields.

Here's a description of how we've solved this quandary with some custom fields and a little Apex.

**Step 1**) Create a custom formula field on Quote line item (I call it "Opportunity Line Item ID").

![OppLineItemID](/uploads/OppLineItemID.jpg)

This will return the synced Opportunity Line Item ID on the Quote Line Item and let our quote find and link the objects.

**Note**: This field is hidden in the formula picker interface, so you have to enter it just as shown. The QLI to OLI relationship can't be referenced in a formula, and that's why you can't just add custom formula reference fields onto the Quote Line Item to look up to their OLI counterparts; you have to use Apex to keep the fields in sync.

**Step 2**) Create a handler class for QuoteLineItem trigger.

public class QuoteLineItemTriggerHandler { public static void syncQuotes(List newLineItems) { // get quote ids we need to query for Set quoteIds = new Set(); for (QuoteLineItem qli : newLineItems) { if (qli.QuoteId != null) { quoteIds.add(qli.QuoteId); } }        // Linking quote line item with Opportunity Line Items Map<ID,ID> mapQuoteLineItemSortOrder= returnDefaultLinking(quoteIds);//Fetch opportunity line item for sync Map<ID,OpportunityLineItem> mapOppLineItems=new Map<ID,OpportunityLineItem>(); for(OpportunityLineItem oli:) { mapOppLineItems.put(oli.id,oli); }

List lstOppotunityToUpdate = new List(); for (QuoteLineItem qli : newLineItems) { OpportunityLineItem oli = mapOppLineItems.get(mapQuoteLineItemSortOrder.get(qli.Id)); if (oli != null ) { oli.Renewal\_\_c=qli.Renewal\_\_c; //update more fields....

lstOppotunityToUpdate.add(oli); } } update lstOppotunityToUpdate; } private static Map<ID,ID> returnDefaultLinking(Set poIds) { Map<ID,ID> mapSortOrder= new Map<ID,ID>(); String query='select id, name,(select id, Opportunity_Line_Item_ID\_\_c from QuoteLineItems  ) from Quote where id in :poIds'; List lstQuotesWithLineItems=Database.query(query); for(Quote q: lstQuotesWithLineItems) { if(q.QuoteLineItems !=null) { for(QuoteLineitem qli : q.QuoteLineItems) { if(qli.Opportunity_Line_Item_ID\_\_c!=null) { //map quote line item id with respective opportunity line item id mapSortOrder.put(qli.Id,ID.valueOF(qli.Opportunity_Line_Item_ID\_\_c)); } } } } return mapSortOrder; } }

**Step 3**)  Create the QuoteLineItem Trigger

trigger QuoteLineItemTrigger on QuoteLineItem (after update)
{
    QuoteLineItemTriggerHandler.syncQuotes(Trigger.new);
}

**Step 4**)  Create a handler class for OpportunityLineItem Trigger

public class OpportunityLineItemTriggerHandler{
public static Boolean isTriggerFire = true;
public static void sync(Set oliIds ){
List lstQLIUpdate = new List();
for(QuoteLineItem qli: newLineItems){
lstQLIUpdate.add(new OpportunityLineItem(Id=qli.Opportunity_Line_Item_ID\_\_c, Renewal\_\_c=qli.Renewal\_\_c));
}
if(!lstQLIUpdate.isEmpty()){
isTriggerFire = false;
update lstQLIUpdate;
isTriggerFire = true;
}
}
}

**Step 5**)  Create the OpportunityLineItem Trigger

trigger OpportunityLineItemTrigger on OpportunityLineItem (after insert) {
if(Trigger.isInsert && Trigger.isAfter && OpportunityLineItemTriggerHandler.isTriggerFire){
Set qliIds = Trigger.newMap.keyset();
OpportunityLineItemTriggerHandler.sync(qliIds);
}
}

Now, return to your Quote Line Item and make a change, you will see the custom field data is also getting synced to the Opportunity Line Item now:

[![](/uploads/QLI%2Bcustom%2Bfield.png)](https://1.bp.blogspot.com/-sZV_2-hKUJ4/WQheKTnUc3I/AAAAAAAABHY/sPua2RuX8QkqxyNR8tetu35Mvvy33hycgCLcB/s1600/QLI%2Bcustom%2Bfield.png)

[![](/uploads/OLI%2Bcustom%2Bfield.png)](https://4.bp.blogspot.com/-42spN1J1Jkk/WQheNtseCUI/AAAAAAAABHc/_uzjdwP0bWYFb4tN5B52TWWh1fT3pG4IACLcB/s1600/OLI%2Bcustom%2Bfield.png)

Happy Coding!


Background: Quotes in Salesforce represe...

quotes-and-opportunity-line-items-add-a-trigger-to-sync-custom-fields

Quotes and Opportunity Line Items - Add a Trigger to Sync Custom Fields


The Salesforce CPQ Header and Footer might work out of box for demos but eventually you will need to customize it.  The most common first gripe I see is that Bill To and Ship To are reversed.

There is no way to edit the out of box template without recreating all the sections and it can be time consuming to recreate it if you did it from scratch.  You can actual actually save time by copy and pasting the out of box version into your own Quote Section.  It's not hard to find after you know where to go.

Here's how:

1. Navigate to Setup > Installed Packages > Salesforce CPQ > View Components
2. Find "Template Top" on the page and click on it (I recommend this since salesforce is still renaming things from SteelBrick to CPQ): ![](/uploads/Screenshot-2018-04-21-13.58.31.png)
3. Click "View File" to download the content: ![](/uploads/Screenshot-2018-04-21-14.00.59.png)
4. Copy & Paste the downloaded html content into your new Template Section

Follow the same process for "Template Bottom" and you will have both of the sections you need and can start doing deep customizations of the quote output.


The Salesforce CPQ Header and Footer might wo...

modify-cpq-pdf-header-and-footer

Modify CPQ PDF Header and Footer

Salesforce apps, powerful components, development and consulting. Our experienced team helps you to create and modify workflow processes in salesforce.

Quote

Quotes and Opportunity Line Items - Add a Trigger to Sync Custom Fields

Modify CPQ PDF Header and Footer

Partners

Company

Get in touch