Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Show Page Sections

download

Retaining the Order of Line Items in a Generated Proposal Document

The sequence of the Line Items on the Cart depends on the addition and configuration of the products on the Catalog and Configuration pages. Using the drag and drop feature, a Sales Rep can rearrange the Line Items on the Cart and retain the rearranged sequence in a generated Quote/Proposal document.

To retain the order of the Line Items from the Cart to the Generated Quote/Proposal document, you must perform the following procedures:

Creating new formula fields for Line and Option Sequence

You must create two new custom formula fields for Proposal Line Item object, which must be derived from Line Sequence and Option Sequence fields of Line Item object.

  1. Go to Setup > Create > Objects and click Proposal Line Item.
  2. In the Custom Fields & Relationships related list, click New and create a new Formula field.
  3. Enter the field Label as Sequence Line and choose the Formula Return Type as Number.
  4. Choose the Advanced Formula tab and build the formula field using the flow- Proposal Line Item > Derived From > Line Sequence.


  5. Grant the necessary Field Level Security, assign the new custom field to the Page Layouts and click Save.
  6. Repeat step: 2 to 5 for creating a new custom formula field for Sequence Option field, which will be derived from the formula- Proposal Line Item > Derived From > Option Sequence.


Creating an Admin entry for Line and Option Sequence

  1. Click and click Admin.
  2. Do any one of the following:
    • Click Newto create a new Admin entry.
    • Click Editfor an existing admin property APTS_ProposalConfig.
  3. In the Namefield, type APTS_ProposalConfig and in the Valuefield, type XML.
  4. In the Codefield, type the following code:
    <ComplyConfig> 
    <SortSpec>
    <SortObjects>
    <SortObject> 
    <Name>Apttus_Proposal__Proposal_Line_Item__c</Name>
    <SortFields> 
    <SortField>
    <Name>SequenceLine__c</Name> 
    </SortField>
    <SortField>
    <Name>SequenceOption__c</Name> 
    </SortField>
    </SortFields>
    </SortObject>
    </SortObjects>
    </SortSpec>
    </ComplyConfig>

    Depending upon your business object (Quote/Proposal or Agreement), you can enable this for ProposlConfig or ComplyConfig respectively.

  5. All the tags defined over here are available in the ProposalConfigSchema static resource. To view this static resource, you may navigate to Setup > Develop > Installed Packages > Conga Proposal Management (Managed) > View Components > ProposalConfigSchema > View file.
  6. Click Save.

Now when you generate a Quote/Proposal document, the rearranged sequence of the Line Items is reflected.

Updating the sequence of options in bundles that are reordered might cause CPU time out error. Conga recommends refraining from updating the option sequence after reordering the bundle. You must add an admin entry to disable the sequencing of options.

Note:

Updating the sequence of options in bundles that are reordered might cause CPU time out error. Conga recommends refraining from updating the option sequence after reordering the bundle. You must add an admin entry to disable the re-sequencing of options by following the steps below:

  1. Click All Tabs icon () and click Admin.
  2. Click Newto create a new Admin entry.
  3. Fill the following details

    Field

    Value

    Name

    APTS_IncludeBundleOptionsForResequencing

    Value

    false

    Code

    Leave the field blank

  4. Click Save.