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


**Who is this for:**  Salesforce CPQ developers and admins

**What's in it for me:**  Learn to inspect the PDF generation process and see how to make unconventional changes

**Background:**  Custom quote lines must be coded from scratch in CPQ, but if you want to do something simple like hide the group total?  We had one customer who uses optional groups as an alternative for the current quote, allowing them to present a PDF with a 1 year option and a 3 year option to highlight savings.

Step 1:  Open the developer console so you can watch what happens when the PDF is generated

Step 2:  Preview a quote that has a custom document with the quote lines content.

Step 3:  Check out the logs in developer console to see all the pages that were loaded:

![](/uploads/Screenshot-2018-04-21-14.54.55.png)

The one I was looking for was "sbqq\_\_lineitemscontent".  For the unindoctrinated, the name is in the format "namespace\_\_filename" (two underscores between them).  Since pages are not protected in a managed package, you are actually free to view the source and copy it for your own needs.  Just go to Setup > Pages and find the page "lineitemscontent" and you can see the markup.  Here it is for your convenience:

```xml
<apex:page language="{!vfLanguage}" controller="SBQQ.DocumentGeneratorController" contentType="application/xml" showHeader="false" sidebar="false">
    <apex:outputPanel layout="none" rendered="{!hasQuote}">
        <c:lineItemGroups quote2="{!quote2}" template="{!template}"
        	staticGroups="{!staticGroups}" dynamicGroups="{!dynamicGroups}"
        	currencyFormatPattern="{!currencyFormatPattern}"
        	fontSize="{!fontSize}" fontFamily="{!fontFamily}" textColor="{!textColor}" tableStyle="{!tableStyle}"/>
        <c:quoteTotals quote2="{!quote2}" template="{!template}"
        	staticGroups="{!staticGroups}" dynamicGroups="{!dynamicGroups}"
        	currencyFormatPattern="{!currencyFormatPattern}"
        	fontSize="{!fontSize}" fontFamily="{!fontFamily}" textColor="{!textColor}"/>
    </apex:outputPanel>
</apex:page>
```

Because the components used in this page are in global (lineItemGroups and quoteTotals) we can copy this page and refer to them in our own namespace.  The only catch: you need to switch the namespace from "c:" to "sbqq:" since you moved the page to your own namespace.

Here is what it looks like after the replace:

```xml
<apex:page language="{!vfLanguage}" controller="SBQQ.DocumentGeneratorController" contentType="application/xml" showHeader="false" sidebar="false">
    <apex:outputPanel layout="none" rendered="{!hasQuote}">
        <**sbqq**:lineItemGroups quote2="{!quote2}" template="{!template}"
        	staticGroups="{!staticGroups}" dynamicGroups="{!dynamicGroups}"
        	currencyFormatPattern="{!currencyFormatPattern}"
        	fontSize="{!fontSize}" fontFamily="{!fontFamily}" textColor="{!textColor}" tableStyle="{!tableStyle}"/>
        <**sbqq**:quoteTotals quote2="{!quote2}" template="{!template}"
        	staticGroups="{!staticGroups}" dynamicGroups="{!dynamicGroups}"
        	currencyFormatPattern="{!currencyFormatPattern}"
        	fontSize="{!fontSize}" fontFamily="{!fontFamily}" textColor="{!textColor}"/>
    </apex:outputPanel>
</apex:page>
```

In our version, we commented out the tag sbqq:quoteTotals since it was showing even if the switch for it in quote template was turned off (bug or not, project has to go live, right?).

Hope this helps you in your CPQ journey and let us know if you need any CPQ/StellBrick help.


Who is this for: Salesforce CPQ develope...

cpq-custom-quote-lines

CPQ Custom Quote Lines


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.

Cpq

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

CPQ Custom Quote Lines

Modify CPQ PDF Header and Footer

Newsletter

Company

Get in touch