Configure Renewal Opportunity Process

use case overview renewal opportunities play a major role in the executive dashboards and reporting suppose the customer already has an automated flow that creates a renewal opportunity as soon as an opportunity is closed/won nue will use this renewal opportunity to add a link to associate the subscription(s) that are created this association will allow nue to know which renewal opportunity to update each time the subscription version is updated each time the subscription version is updated, the renewal opportunity will be updated with the following fields total tcv (add a field to opportunity) total acv (add a field to opportunity) also, there are arr related formula fields on the opportunity that will be automatically updated arr (add a field to opportunity) renewal lost arr (add a field to opportunity) renewal target arr (add a field to opportunity) renewal won arr (add a field to opportunity) how it works enable flows there are two sample flows within nue on salesforce package, you need to clone each of them and make changes according to your business requirements flow 1 generate opportunity subscriptions this flow is used to generate the opportunity subscription(junction table) records between renewal opportunities and subscriptions, and populate the total acv and total tcv to the generated opportunity subscription records login to salesforce org navigate to the flow list page open the sample flow ‘generate opportunity subscriptions sample’ make the changes on the criteria of how to get the renewal opportunity based on the customer’s business requirements generate opportunity subscription flow\ jpg save the flow as a new one if necessary active the flow, now the flow will generate opportunity subscriptions for the renewal opportunities when subscriptions are updated note by default, there is no picklist option ‘renewal’ on opportunity type field, if you are using the default criteria to get renewal opportunity, make sure to add the option to the type field on opportunity object first add renewal picklist value jpg flow 2 update opportunity subscription arr this flow is used to calculate the arrs for each subscription and populate the arrs to opportunity subscription records login to salesforce org navigate to the flow list page open the sample flow ‘update opportunity subscription arr sample’ make the changes on the criteria of how to get the renewal opportunity based on the customer’s business requirements update opportunity subscription arr flow\ jpg save the flow as a new one if necessary active the flow, now the flow will calculate the arrs and store them to opportunity subscriptions when asset order products are updated add metrics fields to the opportunity object please create the following fields on opportunity object manually, these fields are not packaged because of the special case documented below field name field type details total tcv (nue) roll up summary sum of opportunitysubscription tcv where parentsubscriptionid equals empty total acv (nue) roll up summary sum of opportunitysubscription acv where parentsubscriptionid equals empty arr(nue) roll up summary sum of opportunitysubscription arr renewal target arr (nue) roll up summary sum of opportunitysubscription targetarr renewal lost arr (nue) formula if(and(ispickval(type,"renewal"),ispickval(stagename,"closed lost")), renewal target arr nue c ,if(and(ispickval(type,"renewal"),ispickval(stagename,"closed won")), renewal target arr nue c renewal won arr nue c ,0)) renewal won arr (nue) formula if(and( ispickval(type,"renewal"), ispickval( stagename ,"closed won")), arr nue c ,0) migrate for existing renewal opportunities enable the ‘calculate metrics on a daily basis' setting on nue to calculate the subscription today’s arr and today’s cmrr, this will update all subscriptions nightly the update action will trigger the ' generate opportunity subscriptions ' flow to generate opportunity subscription records for existing subscriptions if you need to see the results immediately, please run the following batchable job from the developer console ruby subscriptionmetricscalculatorbatchable subscriptionmetricscalculatorbatchable = new ruby subscriptionmetricscalculatorbatchable(); database executebatch(subscriptionmetricscalculatorbatchable, 200); for ‘ update opportunity subscription arr ', it is triggered when asset order product object gets updated we don’t have a daily job to update this object, so for any existing renewal opportunities, if you want to see the latest arr values, please run the following batchable job from the developer console ruby opportunitysubscriptionarrbatchable opportunitysubscriptionarrbatchable = new ruby opportunitysubscriptionarrbatchable(); database executebatch(opportunitysubscriptionarrbatchable, 200); note please make sure to run this code after the ‘calculate metrics on a daily basis' job gets executed at least once (this will generate the opportunity subscription records for renewal opportunities) additional notes when 'advanced currency management' is turned on, you cannot create a rollup summary field on opportunity object to aggregate the currency type field from the custom child object so we have to use a workaround in this case, please refer to this doc https //help salesforce com/s/articleview?id=000386732\&type=1 https //help salesforce com/s/articleview?id=000386732\&type=1 in the opportunity subscription object, we have already introduced some number type fields, and these fields are all populated with the same values as the corresponding currency type fields if your org has enabled the 'advanced currency management' feature, please create the rollup summary fields (arr, target arr, total acv, total tcv) on opportunity object against these number type fields and then create other formula fields to convert the rollup summary number fields to currency type this is a workaround for this special case put it all together the out of the box flows in nue are a powerful tool that can help organizations optimize their renewal processes, and provide more accurate forecast arr metrics for the executive team