Using Mobileforce CPQ with Sugar CRM
  • 07 Jun 2023
  • 7 Minutes to read
  • Contributors
  • Dark

Using Mobileforce CPQ with Sugar CRM

  • Dark

Article Summary

Mobileforce CPQ seamlessly integrates with your CRM, so you can easily access the CPQ module from the SugarCRM User Interface as well as creating a proposal from the SugarCRM Opportunities module. Additional benefits include:

Same Credentials:
Mobileforce CPQ uses SugarCRM's user credentials when requesting access, removing the need for separate Mobileforce credentials.

Embedded User Interface:
The Mobileforce CPQ user interface is embedded and accessible directly from the SugarCRM interface and has the same look and feel (font, color scheme, and user experience) as any SugarCRM table.


Access Control:
Mobileforce CPQ supports access control of CPQ screens and operations using Mobileforce expressions in conjunction with SugarCRM roles.


You can use a Quote UI Layout to restrict access to a column in the Line Items table from users who do not satisfy the role "is_ibs_opportunity". This role is itself computed using Mobileforce expressions.


Video Overview

Implementation of Mobileforce CPQ for Sugar CRM

Mobileforce CPQ is a cloud-hosted product, which can be directly implemented to your cloud-hosted SugarCRM platform.

For now, please use the direct method to install Mobileforce apps (CPQ and FSM) onto your Sugar instance from Install & Configure Mobileforce in a Sugar Instance (Direct Method)

In future, to use Mobileforce CPQ with your existing SugarCRM platform, you must implement and configure the solution from the Sugar CRM Marketplace. The new SugarCRM Marketplace is "Sugar Outfitters" which will eventually enable direct installation of Mobileforce Apps onto your Sugar instance from the marketplace.

Sugar Outfitters:


This task can only be performed by a Sugar CRM user with admin capabilities.

Launching Mobileforce CPQ from SugarCRM

Once you have implemented the Mobileforce CPQ solution with your SugarCRM platform, you can launch the Mobileforce CPQ application directly as a module from the SugarCRM platform using one of the following methods:

  • Creating a Mobileforce CPQ proposal/quote directly from an existing SugarCRM Opportunity, allowing Mobileforce to populate the quote with the applicable Opportunity data.
  • Launching the Mobileforce CPQ application as a module directly from the SugarCRM Navigation Bar. From the Mobileforce CPQ application, you can create new proposals, associating it with existing CRM opportunity and customer information.

Opening the Mobileforce CPQ Application

When Mobileforce CPQ is installed, you can directly access the Mobileforce CPQ module from the navigation pane on the left side of the screen,. The CPQ module will be the last module by default (highlighted in yellow).


Update the navigation bar

If you want to configure the SugarCRM navigation bar to better prioritize the CPQ module, you can configure it using your user preferences, where you can select which modules you want to display, as well as the order they appear in the navigation bar. For more information, refer to the SugarCRM Getting Started documentation.

Viewing the CPQ Module

When you click the CPQ button, the CPQ main menu is displayed.



You can click the image.png button to expand the Mobileforce menu to navigate it, and click again to collapse the menu when finished.


This matches the Sugar CRM functionality where you can click the image.png icon to open the Sugar navigation pane.

From here you can do the following actions:

Creating a Mobileforce CPQ Proposal from an Opportunity

SugarCRM allow you to create a proposal directly from one of its existing (native) module/objects: Opportunities.


Click the CPQ button and select Create.


Mobileforce CPQ populates the Customer Info section with the applicable information from the SugarCRM Opportunity. For more detailed information, see How does Mobileforce CPQ Interact with SugarCRM

You can then update the proposal as needed. For more information, see Creating a Proposal.

Writing CPQ output back to SugarCRM

Once you have completed your proposal/quote in Mobileforce CPQ, you save the quote back to the associated SugarCRM Quote Table , at which point, Mobileforce CPQ updates the SugarCRM Opportunity object as well as the SugarCRM Quote Table as follows:

  • The Likely amount in the Opportunity is updated with the Adjusted Total amount from the Quote tab.
  • The quote and the line items are added to the associated SugarCRM Quote Table and the Quoted Line Items Table, where they can be processed. In effect, a new Quote object is created within SugarCRM , and it is made the primary quote.
  • Under this newly created SugarCRM Quote object, a product is created for each line item in the Mobileforce Quote.
  • In addition, optionally, Mobileforce can create a Revenue Line Item in the opportunity object for each CPQ line item.
  • The Latest generated CPQ quote document is also uploaded to the SugarCRM Opportunity object.
  • The status of the deal or opportunity advances to the next stage (for example, the status changing from In Progress to Quote Sent to Customer.

For more detailed information, see How does Mobileforce CPQ Interact with SugarCRM

Additionally your organization can create custom actions that Mobileforce CPQ will invoke when the proposal is saved to SugarCRM. These actions can only be completed by a user with admin privileges.

How does Mobileforce CPQ interact with SugarCRM

This section proivides greater detail about the interfacing between Mobileforce CPQ and SugarCRM. This information is primarily useful for SugarCRM admins who want to know the specifics of how Mobileforce CPQ is interacting with the SugarCRM database.

  • SugarCRM has the following relations (tables) that are central to CPQ: Opportunity , Revenue Line Items, Quote., and Quoted Line Items.
  • Note that each Opportunity contains one or more Revenue Line Items, and similarly, each Quote contains one or more Quote Line Items.
  • Mobileforce CPQ directly manipulates two objects related to the tables:
    • Quote Line Item (QLI): A child of the Quote table.
    • Revenue Line Item (RLI): A child of the Oppotunity table.

The above SugarCRM Tables are typically updated using pricing fields in the quote which are mostly predefined default system fields. However, some quotes may customize the default pricing computations for one or more line item tables. For such quotes, we need some means to override the pricing fields used.

Mobileforce lets you customize the generation of SugarCRM Revenue Line Items and Quote Products for a line item table by adding custom attrbutes to that table. This is done by adding these attributes to the 'Custom Attributes' section of the line item table in the Quote UI Layout. By convention, all custom attribute names used by the 'Save to CRM' action start with 'crm-'.

Most custom attributes are field attributes. Field attributes identify which fields in the CPQ form should be read to fetch the relevant data needed to generate the SugarCRM entries. By convention, the names of field attributes start with 'crm-field-'.


For more information about field attributes, please contact Mobileforce Support.


If desired, Mobileforce Support can configure Mobileforce CPQ to not update Revenue Line Items, as well as update other objects or fields in SugarCRM. In effect, Mobileforce supports updates to any field of any SugarCRM table with values taken from the CPQ generated quote. For more information about this or any other required customization, please contact Mobileforce Support.

Proposal/Quote creation

At the beginning of the CPQ process, when a proposal/quote is created, Mobileforce CPQ extracts information from the SugarCRM Opportunity table (for example: Account, Contact, and Close Date) for use throughout the CPQ process.


Saving a Proposal/Quote back to SugarCRM

At the completion of the CPQ process, where the seller saves a Mobileforce CPQ quote to SugarCRM, Mobileforce adds a new Quote object to the Quote relation, and writes each line items in the quote as a Quote Line Item in Sugar CRM.


Each time that a quote is saved, a new Quote object and the corresponding Quote Line Items are created. Mobileforce never overwrites previously created Quotes or Quote Line Items in SugarCRM.

This enables the user to view history of all quotes and their associated QLIs.

SugarCRM does not provide access for Mobileforce CPQ to update the Amount field in the SugarCRM Opportunity table, so Mobileforce CPQ creates a Revenue Line Item object in SugarCRM for each line item in the proposal, creating a 1-to-1 relationship between them. In addition, you can use automation from SugarCRM to update the Amount field in an Opportunity object based on the values of the Revenue Line Items.


Each time that a quote is saved, a Mobileforce overwrites the existing Revenue Line Items with new information to reflect the latest version of the Mobileforce Proposal/Quote.


SugarCRM Admin Tasks

SugarCRM admins can add trigger rules to update the Amount field in the SugarCRM Opportunity table whenever Mobileforce CPQ creates a new RLI object. This can only be performed by a SugarCRM Admin, and is outside the scope of Mobileforce CPQ.

Was this article helpful?