Salesforce CPQ: Prorate Additional Discount Amount Using the ProrateAmountDiscount__c Formula Field

When a quote's subscription term differs from a product's default subscription term, Salesforce CPQ does not automatically prorate a flat Additional Discount Amount. This means a $10 discount entered on a product with a 12-month default subscription term applies in full even when the quote term is only 6 months, resulting in a lower net price than intended.

To enable prorated discount behavior, a special formula field named ProrateAmountDiscount__c must be created on the Quote Line object. When this field exists, CPQ detects it and automatically prorates the Additional Discount Amount by the ratio of the quote term to the product's default subscription term.

 Example scenario:

- Quote subscription term: 6 months

-Product default subscription term: 12 months 

-Product unit price: $50

-Additional Discount entered: $10

Without proration, the net price calculates as $15. With the ProrateAmountDiscount__c field present, the $10 discount is halved (6 ÷ 12 = 0.5), producing a prorated discount of $5 and a net price of $20.

Important considerations before implementing:

- This feature applies to Additional Discount Amount only. Percent discounts and unit discounts are not prorated when this field exists.

- Users who toggle between amount and percent discount types may experience confusion, because the entered discount amount will not equal the actual amount applied.

- To prevent confusion, it is recommended to disable Additional Discount % and Unit Override options. This is done by creating the Quote Line Additional Discount Unit field and removing percent, Unit Override, and Total Override from the picklist values. Refer to the Additional Discount Unit article for full instructions.

- ProrateAmountDiscount__c is a formula field. Conditional logic can be added to the formula to control when proration applies based on specific use case requirements.