Knowledge Center

Knowledge Center > Zuora CPQ > Zuora Quotes > Manage Quotes > Create a Custom Report

Create a Custom Report

This article describes how to create reports using the custom report types in Zuora Quotes.

About Zuora Quotes Custom Reports

Zuora Quotes supports consolidated pipeline reporting on new subscriptions, amendments, and renewals at the Quote Charge level. It provides the following custom report types for this feature:

  • Account with Opportunity and Quote Charges
  • Opportunity with Quote Charges

Prerequisites

Perform the following steps before using the Zuora Quotes custom reports: 

  1. Make the associated Apex classes available to your user profiles in Salesforce. See Upgrading Zuora Quotes for more information. 
  2. Enable the Enable Consolidated Charge-level Reports setting in Quote Settings if in version 6.4x or earlier version of Zuora Quotes.

 After configuring Enable Consolidated Charge-level Reports, a background process runs and gathers the data for Opportunity Products Pipeline Reports. The time required to complete the process depends on the amount of existing quote charge data in the Salesforce. The report may not produce accurate results until the process is completed.

Create a Zuora Quotes Report

To create a report in Zuora Quotes using the custom report types:

  1. On the Reports tab in Salesforce, click New Report
  2. In the Select Report Type list, click one of the following report types:
    • Account with Opportunity and Quote Charges in the Accounts & Contacts folder
    • Opportunity with Quote Charges in the Opportunities folder
  3. Click Create
    CreateReport.png
  4. Use Salesforce's reporting wizard to build the report that you need.
  5. Click Save to save your edits, or Run Report to test the report that you built.

The following example scenario walks you through creating a custom report.

To create an example custom report:

  1. On the Reports tab in Salesforce, click New Report
  2. In the Select Report Type list, expand the Accounts & Contacts folder​ and ​click Account with Opportunity and Quote Charges.
  3. Click Create
  4. Click Tabular and select Summary Format.
    SummaryView.png
  5. Drag and drop the following fields from the Fields list:
    • Account Name
    • Opportunity Name
    • Quote Charge Name
    • Stage
    • Amount
    • Close Date
    • List Price
    • Discount
    • Effective Price
    • Quantity
    • Total Price
    • MRR​
    • TCV
  6. Click the arrow next to the following fields and select Summarize this Field...:
    • Amount
    • MRR​
    • TCV
      Summarize.png
  7. In the Summarize dialog box, select the summary type and click Apply.
  8. Click Run Report to create your custom report. 
    FinalReport1.png
Last modified

Tags

Classifications

(not set)