The Problem
You need an Effective End Date on the Quote Line, that will never be blank and will contain the end date of the subscription for a given line.
The problem with the
SBQQ__EffectiveEndDate__cfield is that it’s empty when the subscription term is used and not the end date.
The Solution
The solution is pretty simple, you need to create a custom formula field on the SBQQ__QuoteLine__c object, with the formula as follows:
IF( !ISBLANK(SBQQ__EffectiveEndDate__c),
SBQQ__EffectiveEndDate__c,
ADDMONTHS( SBQQ__EffectiveStartDate__c , SBQQ__EffectiveSubscriptionTerm__c )-1
)
One reply on “Which date field on the Quote Line has the End Date of the subscription?”
The start Date and Subscription Term fields filled in the quote end date field need to be updated automatically for this
I have created a flow and this is a formula but it does not work if I choose below or above 12-month terms
{!$Record.StartDate__c} + (({!$Record.SubscriptionTerm__c} * 30) +6)
its start date 12 months into 30 days + 6 days (as 6 months have 31 days)
(If the user chose 3 months or 6 months end date will get 3 days or 6 days more)
If there is any other way it will be helpfu