Skip to main content

Zuora RevPro 36.002.00 Release Notes

Zuora

Zuora RevPro 36.002.00 Release Notes

This article provides a summary of new features, enhancements, and resolved issues in the Zuora RevPro version 36.002.00.

New Features and Enhancements

The following new features and enhancements are available in this release.

Contractual Prospective Functionally is Available for Contract Ratable Method

Previously, the Contractual Prospective functionality is available only for the revenue contracts whose POB ratable method is set to Ratable. Now, the Contractual Prospective functionality is also available for the revenue contracts whose POB ratable method is set to Contract Ratable.

With this functionality, if any contract modification occurs in a revision period and triggers prospective allocation, amortization must be fulfilled for the value of this period before it moves to the subsequent value.

This enhancement introduces the changes in the Release/Defer POB window in the Workbench. When you release one POB or multiple POBs, if certain conditions are met, a required field will be displayed for you to specify the time period to consider prospective release. When you want to release POB on the RC level, you can select Contract Modification Effective Date, Contract Modification Period, or Inception of the Line for the time period to consider prospective release. When you want to release POB on the POB level, you can select Contract Modification Period or Inception of the Line for the time period to consider prospective release. Note that the Contract Modification Effective Date is applicable only for the POBs with the ratable method being Ratable.

For example, the revenue start date of a sales order line is 1/1/2019 and the revenue end date is 12/31/2019. The extended selling price is 12000. Below is the original waterfall data for a sales order line.

Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019  
1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12000

Changes occur to the line for the amount of 21000 in April. Without this enhancement, the waterfall data for this line behaves like cumulative catchup, which is shown below:

Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019  
1000 1000 1000 4000 1750 1750 1750 1750 1750 1750 1750 1750 21000

With this enhancement, Contract Modification Period is selected for the time period to consider prospective release. The waterfall data for this line is as follows:

Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019  
1000 1000 1000 2000 2000 2000 2000 2000 2000 2000 2000 2000 21000

This enhancement applies to both the old UI and the new UI.

MJE Reference Columns Can Be Displayed in Revenue Reports

From this release, when you upload journal entries with additional reference columns to RevPro, such as Customer Name and Region, RevPro can copy these reference column values to the RC line that is created for the journal entry line. Then, these MJE reference columns can be displayed in all Revenue reports.
To use this functionality, you must first define and enable the mapping between MJE reference columns and RC line columns through the MJE_RC_LINE_FIELD_MAP lookup value. When you define this lookup value in the Edit Lookup Definition window, remember not to use the standard ID column values (such as Sales Order Line ID, RC ID, etc.) for the Lookup Value column. Otherwise, it might cause mapping conflicts.

After the MJE_RC_LINE_FIELD_MAP lookup value is defined, if you upload MJE with the mapped field values based on either standard or waterfall template, the mapped field values can be copied to the corresponding line in the RC line table and are retrievable in the Revenue reports.

In the following example, the Reference 1 field value of MJE is mapped to CSTMR_NM value (customer name) of the RC line and Reference 2 field value is mapped to SALES_REP_NAME value (sales rep name) of the RC line.

Sequence Lookup code (MJE value) Lookup Value (RC Line Value)
1 Reference1 CSTMR_NM
2 Reference2 SALES_REP_NAME

Configurable Waterfall Templates

Previously, the waterfall output report is generated and displayed on a periodic basis from a given as-of date. The amounts of all the previous periods are condensed together and displayed as one aggregate value in the Prior Periods column.

From this release, more flexibilities are provided by the introduction of configurable waterfall templates. When you create a waterfall template, you have three options for the waterfall format:

  • Periods/Quarters/Years: The waterfall data is built based on the combination of periods, quarters, and years. The tracker is used to specify the number of previous periods and future periods that are shown as amortized value.  

  • Quarters/Years: The waterfall data is based on quarters and years and all the periods will be collapsed as quarters and years.

  • Years: The waterfall data is built based on years and all the periods will be collapsed as years.

After you select the waterfall format, use a pointer to specify the number of periods to be condensed for the previous and future quarters or years in the waterfall data.

After the waterfall template is created, it is available to be selected when you view waterfall data in the Workbench or run a report.

This enhancement applies to the new UI only.

Access Control to Tab Layouts in Workbench

Previously, after you create a layout for the Workbench tab, this layout might be modified or overwritten by other users. From this release, you can control access to your layout by setting access permissions for your layout. Three types of access permissions are available:

  • All: This layout can be accessed and edited by any users.

  • All (Read Only): This layout can be accessed by all users but only the user who created the layout can edit the layout.

  • Owner: Only the user who created the layout can access and edit this layout.

The access permissions can also be viewed in the Accessibility column in the Manage Transaction Layouts window.

This enhancement applies to the new UI only.

Notification of Unsummarized Accounting Changes

It is mandatory to run the summarization program before you can generate key revenue reports. However, previously, when accounting changes occur, you cannot know whether the summarization program has already counted in those accounting changes or it needs to be run again.

From this release, if there are accounting changes that have not been summarized, a notification message will be displayed when you log in to RevPro or before you want to run a report.

This enhancement applies to the new UI only.

Various Enhancements for Report Download

There are multiple changes and enhancements for downloading reports:

  • When you submit or schedule a report download, you can specify the roles with which you want to share this download. The report data is then available to all the selected user roles besides you.

  • After you submit or schedule a report download, you can also select one particular report to share with any user roles.

  • The Schedule Downloads page is removed and the scheduled download information is now combined into the My Downloads page.

  • On the My Download page, a column named Download Type is added to indicate the report download is either Adhoc or Scheduled.

  • A page named Shared Downloads is added to show all the reports that are shared with you by other users.

  • In the output report file, a new header named Numbers of Rows is added to indicate the number of lines that are included in the output CSV file. 

This enhancement applies to both the old UI and the new UI.

New Accounting Treatment Option Available for Contract Price Decrease Modification

When you configure contract modification rules, a new option named Skip Contract Mod is available on the Modification Treatment list for the "Changes to existing lines - Decrease in price more than recognized on a Series Distinct/Non Distinct POB" rule. This change is introduced to avoid major swing in the revenue when the contract amendment impacts only the minimum of posted revenue.

This new option enables you to skip contract modification for this type of price decrease. With this option selected, RevPro will only perform the reallocation based on the allocation treatment that is already available on the revenue contract without creating a new version of the revenue contract.

This enhancement applies to both the old UI and the new UI.

New Columns Added to Various Reports

Many reports have new columns added to provide more useful information.

  • The following columns are added to the Booking Report and the Revenue Contract Detail Report to display more information about SSP Batch: 
    • SSP Batch Name

    • SSP Group ID

    • Above SSP Prc

    • Below SSP Prc

    • Price Point

    • Impairment Type

  • The Forecast Type column is added to the Waterfall Report to indicate whether the record is actual or forecast. You can use Forecast Type to filter out the actual records or forecast records in the report. 

  • The Creation Date column is added to the User Assignment Report to display the creation date of the user. 

  • The Last Login column is added to the User Access Report to display the last time when the user logs in to the system. 

  • The Long Term and Short Term columns are added to the RC Rollforward Report. Now, you can see the long-term and short-term revenue values for each line in this report. 

Improved RORD Processing for Canceling Billed Revenue

Previously, when RORD is processed to cancel the billed revenue, if no revenue exists in the current period and the Right to Bill value is "Y", RevPro cannot correctly reverse the billed revenue that should be canceled. It is because RevPro cannot determine to which accounting type the reversal should be booked. The reversal amount is categorized to the unbilled accounting type for the current period, which is not accurate.

From this release, RevPro is able to determine the overall percentage of billed revenue for the past periods and then apply the percentage to the canceled amount to determine the billed revenue that should be reversed. This change is applicable only for the ratable methods of Immediate Using Open Period and Immediate Using Start Date.

Support to Exclude a VC Type from Allocation

Previously, the variable consideration amount is by default included in the allocation process. From this release, you can either include or exclude the variable consideration amount in the allocation process.

In the Manage VC Types window, a toggle switch named Include in Allocation is added. Now, when you create or edit a VC type, you can also specify whether this VC type should be included in the allocation.

This enhancement applies to both the old UI and the new UI.

Download Data for Multiple Tabs with One Click In Workbench

Previously, to download all types of data about a revenue contract from the Workbench, you must go through each tab and download the data one by one. From this release, you can choose the tab values that are to be downloaded together from the workbench. The tabs that are selectable include Transactions, Waterfall, Revenue Summary, Versions, and Accounting Details tabs. Values from these tabs are downloadable with one click of the Export all icon.

This enhancement applies to the New UI only.

New Fields Added to Revenue Contract Overview

The Account Updated Date and Account Updated Period fields are added to the Overview tab on the Revenue Contract Detail page in the Workbench.

This enhancement applies to both the old UI and the new UI.

Issues Resolved in This Release

The following major problems or issues are fixed in this release. Refer to the attached CSV file to get a list of all issues that have been resolved in this release.

  • For the event-based POB with sliding ratable method, when an event with a future start date comes in, the revenue is released as condensed based on the end date of each sales order line, instead of sliding based on the event start date. 
  • When you upload the manual JE based on a waterfall template, the operation fails. The following error message can be found on the Error tab of the JE Details window: “Reversal date and Start / End date cannot be populated at the same time”. 

  • When RevPro performs prospective allocation, the Posted Percent (posted_pct) value is incorrectly calculated. 

  • On the Revenue Contract Detail page, the hold name is not displayed on the Hold drop-down list when the Level is set to RC. However, the hold is displayed correctly on the RC Holds tab of the Holds and Approvals window. 

  • In the old UI, the View Processed Events option is available on the transaction line level, which should be available on the POB level only. 

  • After you delink a POB from a revenue contract, the delinked POB does not show up in the orphan transactions. 

  • In the GL Transfer Accounting Outbound Report, credit and debit are summarized on the same line, which should be on separate lines. 

  • The RORD reversal schedules cannot be created. The Recognized Amount (REC_AMT) and Billed Recognized Amount (BLD_REC_AMT) values are updated incorrectly. 

  • When changes occur to the RC line attribute of a prospective revenue contract, the unreleased contract value is created and displayed in the Workbench. 

  • The Cumulative Flag shows N for the cumulative events in the View Processed Events window. 

  • When contract modification comes in with Revenue Start Date and Revenue End Date, the revenue schedules are not calculated starting from the Revenue Start Date in the waterfall, but starting from the open period. 

  • The Ext SSP Price of the RSSP line is wrong. 

  • In the new UI, after you move a line to the new POB, the POB name cannot be derived correctly. It is displayed as Undefined in the Workbench. 

  • In the new UI, the SSP Eligible Flag value is not consistent between the Edit Line window and the View Line window. For example, it shows Y in the Edit Line window but shows N in the View Line window. 

  • When price change order (PORD) line comes in, the posted percent is not calculated correctly for a prospective allocation because the PORD reversal schedules are not created correctly. Revenue and allocation schedules are also wrong. 

  • The Extended FV Price cannot be converted in the transactional currency for a prospective allocation. The amount is still in functional currency. 

  • The rounding of a currency does not work as expected. For example, you set the rounding of the JPY currency to 0, however, the two decimal fractions are still reserved in the JPY amount. 

  • When you take a revenue contract with Transfer Hold and then delink the line on POB level, the Hold Transfer field is changed to No on the Overview tab of the Workbench. 

  • In the new UI, you cannot proceed to the next task to open a period in the Initiate Open Period window. 

  • In the new UI, the Allow Manual Release value and Allow Manual Application value displayed on the Policies/Performance Obligations/POB Templates page do not match the values displayed in the Edit POB Template window. 

  • The Enabled toggle switch does not work to disable or enable a layout in the Edit Report window after the old UI is upgraded to the new UI. 

  • In the new UI, the Sales Order Line ID column is empty on the Revenue Contract Detail page. 

  • In the old UI, data on the Cost Element tab is not updated based on the input cost lines for a revenue contract. 

  • The allocated amount is not equal to the sum of allocatable amount and carve amount. 

  • The RC Created Period column is not included in the Contract Modification Report. ​​​​​​​

  • In the new UI, the sorting function does not work in the Delink window. For example, you cannot sort the lines in the ascending order or descending order by clicking Order Line Number. ​​​​​​​

  • Ghost or dummy lines are not created because the MR Eligible Flag value is not copied to the child lines correctly during bundle explosion.