Welcome to Zuora Product Documentation

Explore our rich library of product information

Create Custom Report

Learn how to create a custom report in Salesforce using Zuora Quotes to support consolidated pipeline reporting on new subscriptions, amendments, and renewals at the Quote Charge level.

  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.
    Note:

    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.

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
  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.
  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.
  6. Perform the following steps 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 the Account with Opportunity and Quote Charges.
    3. Click Create.
    4. Click Tabular and select Summary Format.
    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
    7. In the Summarize dialog box, select the summary type and click Apply.
    8. Click Run Report to create your custom report.